Statistical Analysis – Create questions and analyis

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

© Open Polytechnic 1

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Here’s an example of what your report might look like. A covering memo and a Terms of

Reference are not required, but a Title page is. Including an Executive Summary or Abstract

is optional. You may prefer to use alternative terms (for example Procedure instead of

Methodology) in line with reports you have written for other subjects. Further help on

writing reports is found here:

http://www.openpolytechnic.ac.nz/study-with-us/study-resources-for-

students/assignments/types-of-assignments/reports/how-to-write-a-report/

Title Page (This will include your full name, student number and the title of your
report.)

Table of Contents (This lists the sections below.)

1. Introduction to topic and aims (Give a general discussion about your topic, discuss why the
questions you are asking are important and include two or more

clearly stated aims.)

(Title page, Table of Contents, Introduction: 20 marks)

2. Data

2.1 Data description (Give a general description of the data, its source, how it was
collected and name and describe the variables you will be using.)
2.2 Method of sampling (Say how your sampling was done and state the sample size.)
(Data description, method of sampling: 10 marks)

3. Data analysis
3.1 Methodology (Give a brief description of the analysis which will follow.)
3.2 Analysis (Show your analysis here – an example is shown on page 3 of this
document)

(Methodology, data analysis: 40 marks)

4. Conclusions (Summarise your findings in the context of your topic/aims and
discuss the implications).

5. Recommendations (Not all reports will have recommendations.)
(Conclusion, recommendations: 20 marks)

6. List of references (Data and any publications used should be referenced in correct APA
format. You do not need to reference information obtained from the

set text.)

72160 Statistical Analysis

Assignment 4 formatting instructions

http://www.openpolytechnic.ac.nz/

http://www.openpolytechnic.ac.nz/study-with-us/study-resources-for-students/assignments/types-of-assignments/reports/how-to-write-a-report/

http://www.openpolytechnic.ac.nz/study-with-us/study-resources-for-students/assignments/types-of-assignments/reports/how-to-write-a-report/

72160 Statistical Analysis Assignment 4 formatting instructions

© Open Polytechnic 2

7. Appendices (Include a sample of your data and manual workings or computer
output.)

(Presentation, referencing: 10 marks)

Headings: Use bold headings, with larger font for main headings. Imagine this is a

business report and you are preparing it for publication.

Tables: Tables should be labelled Table 1, Table 2 in the order they occur. This should go

above the table and on the following line there should be a title in italics.

For example:

Table 1

Means and standard deviations of cooking times

Mean (mins) Standard deviation (mins)

Men 42 23

Women 39 6

The table must be clear and easily ready. Data and headings should be centred. If you are

copying summary statistic tables from Excel or other software, delete any unnecessary

values, round to an appropriate number of decimal places and put in the units of

measurement.

Graphs. Graphs should be labelled Figure 1, Figure 2 etc below the graph, with a title. For

example

Figure 1: Normal quantile plot of density of the earth.

72160 Statistical Analysis Assignment 4 formatting instructions

© Open Polytechnic 3

It is optional whether you put a title on the graph as well as below it.

Appendices. This should start on a new page and be labelled Appendix. If there are more

than one, start each on a new page and label as Appendix A, Appendix B etc.

Page breaks. As we will be marking online, you need to use page breaks to keep the

correct pagination. Use the keyboard shortcut: Ctrl + Enter in all versions of Word. Put a

page break after your title page, after your Table of Contents and between appendices.

Keep all tables on one page, rather than splitting them in the middle.

Footer. Insert a footer and include your full name, student number, 72160 Assignment 4

and page numbers in this footer. On Word 2010 and 2007 this is on the Insert ribbon. On

Word 2003 use View, Header and Footer and hover over the icons to see the one which

switches between header and footer.

APA referencing style. If you refer to any publications, you must cite and reference these

correctly. You can find help with referencing on the main Online Campus page under Find

Support.

Here’s an example of what the analysis section might look like.

3. Data Analysis

3.1 Methodology

(Give a brief description of the analysis which will follow)

3.2 Analysis

3.2.1 Comparison of mean cooking times taken by men and women

To compare the mean times taken by men and women to complete the task of cooking

dinner, the following side-by-side boxplots were prepared.

(Insert your graph here)

As can be seen, there appears to be little difference in median times, which are around

40 minutes. However, the men have one observation at 240 minutes, which appears

to be an outlier. Use of the 1.5IQR rule confirms this (see Appendix D). This

observation was checked for authenticity, found to be a legitimate value and retained

for further analysis. The minimum times are similar for both men and women at

around 20 minutes.

The means and standard deviations for cooking time are given in the following table.

(Insert your table here)

Although the means are similar, the men’s times have more variation.

A two-sample t test confirms that there is no statistically significant difference in mean

times taken. Using a one-sided alternative hypothesis that men take longer than

women, on average, to cook dinner, the hypotheses for this were:

0
:

w m
H  

72160 Statistical Analysis Assignment 4 formatting instructions

© Open Polytechnic 4

:
a w m

H  

The test is valid as the sum of the sample sizes exceeds 40.

Results show t(80) = 1.01, P = 0.17 (see software output in Appendix E). This large P-

value means that there is no evidence to reject
0

H and I can conclude that … .

3.2.2 Comparison of average number of dishes used by men and women

…..

72160 Statistical Analysis Assignment 4 formatting instructions

© Open Polytechnic 5

Reporting results of descriptive and inferential statistics
in APA format

Important note: APA presentation of statistical results is outlined as follows, but you

will not be penalised for not using this style. You will notice that some symbols are not

consistent with what has been used in our course (e.g. APA style uses M for sample

mean, rather than for median) and some formats are not what we have taught as

good practice (e.g. APA style has no leading zeros in decimal numbers less than 1). To

maintain consistency with our course textbook, we recommend you use the

conventions you have used during the trimester and follow the examples above.

In reporting the results of statistical tests, report the descriptive statistics (means and

standard deviations), the test statistic, degrees of freedom, obtained value of the test, and

the p-value. Test statistics and p-values should be rounded to two decimal places. All

statistical symbols that are not Greek letters should be italicised (M, SD, n, t, p, etc.)

Tables are useful if you find that a paragraph has almost as many numbers as words. If you

do use a table, do not also report the same information in the text. It’s either one or the

other.

Use a zero before the decimal point with numbers that are less than 1 when the statistic can

exceed 1 (e.g. 0.75 cm). Do not use a zero before a decimal fraction when the statistic

cannot be greater than 1 (e.g. correlation, proportion and levels of statistical significance).

Mean and Standard Deviation are most clearly presented in parentheses:

In the sample of 100 Statistical Analysis students the average Assignment 1 mark was

relatively high (M = 72.5%, SD = 9.4%).

In the Statistical Analysis course the average Assignment 1 mark for the sample of

100 students was 72.5% (SD = 9.4%).

Percentages are also most clearly displayed in parentheses with no decimal places:

Nearly half (49%) of participants in the sample were working full time.

Correlation:

The two variables were strongly correlated, R = .91.

Regression results are often best presented in a table. APA doesn’t say much about how to

report regression results in the text. You may use the following format:

Consumption = 225.75 + 0.86 Income, R = .89, R
2
= 79%

Confidence interval should be presented in squared parentheses with confidence level:

Mean: M = $300.5, 95% CI [$255.75, $344.25]

72160 Statistical Analysis Assignment 4 formatting instructions

© Open Polytechnic 6

Proportion: p = .55, 95% CI [.45, .65]

p-values

p = value (no leading zeros); e.g. p = .07

p < .01 (if the value is less than .01)

t-test should be include test statistic, degrees of freedom, value of the test and p-value,

i.e. t(df) = value, p-value:

one sample t-test: One sample t-test showed that the difference in quiz scores between

the current sample (n = 6, M = 3.45, SD = 2.11) and the

hypothesized value (µ = 3.00) was not statistically significant, t(5) =

1.25, p = .26, 95% CI [1.24, 5.66].

two sample t-test: Two sample t-test showed that the difference in Assignment 1 marks

between Statistical Analysis students in Trimester 1 and Trimester 2

was marginally significant, t(5) = 1.25, p = .08.

match pairs t-test: The 25 participants had an average difference from pre-test anxiety

scores of -4.8 (SD = 5.5), indicating the anxiety treatment resulted in

significant decrease in anxiety levels, t(24) = -4.36, p < .01 (one-

tailed).

Chi-square statistics are reported with degrees of freedom and sample size in

parentheses, and p-value:

As can be seen by the counts in the two-way table in Table xx, there is a significant

relationship between marital status and depression, χ
2
(3, n = 126) = 24.7, p < .01.

The relationship between these variables was not significant, χ
2
(1, n = 100) = 1.96, p

= .15. Whether the students posting their coursework activities or not did not differ by

gender.

Based on:

American Psychological Association. (2010). Publication manual of the American

Psychological Association (6
th
ed.). Washington, DC: Author.

Bloggs.Karen.72160.A3.1234567 1

72160 Statistical Analysis: Assignment 3

This is an example of how your Assignment 3 should look. Do not copy and paste from

this document – you need to use your own words! A blank version of the template can

be found on the Online Campus in the Assessments section. Save it to your computer, fill in

your project details and upload the file under the Assignment 3 link on the Online Campus.

Student name: Karen Bloggs Student number: 1234567

Title

The title of my project is:

1. Introduction

Give a brief description of your project. Discuss why it is important to investigate your aims and why

the project is of general interest. This should be covered briefly here and in more depth on the actual

project.

2. Aims

Specify two or more aims. These should be written in clear statistical language.

For example:

1. to test if the mean value of a variable differs for two populations (specify the variable and

populations)

2. to estimate the proportion of …… from a stated population

3. to investigate if there is a linear relationship between … and… (specify the two numeric

variables )

4. to investigate if there is any association between … and… (specify the two categorical

variables )

Bloggs.Karen.72160.A3.1234567 2

3. Methodology

3.1 Data collection and sampling method

State the source of your data (give the link if this comes from a website) and how the data was

collected. You need a simple random sample from a larger population or a stratified random sample

(e.g. divide your population into men and women and randomly sample from each). State what your

population is, your method of sampling and your sample size.

Note:

1. A sample size of about 100 is suitable, but if the dataset is already a sample of 200, then use

all 200.

2. If you get your data from a website, you may need to make some assumptions about how the

data was collected and how the sampling was done.

3. Data which has already been summarised, such as weekly totals of phone calls, cannot be

used. You need a sample of individual phone calls.

4. Data which is in time series order (e.g. weekly sales for the last two years) is not a random

sample and can only be used in conjunction with other data.

5. Possible sources for data are given on the 72160 page of the Online Campus under

Assignment 3 in the Assessments section.

3.2 Variables

Name your variables and state whether they are numeric or categorical variables. Give the range of

possible values each variable can take.

Note: your dataset must contain at least one numeric variable.

4. Analysis

Specify your planned analysis to answer Aim 1.

This should include the exploratory work (summary statistics, check for outliers), graphs you will use

and a form of inference.

For example, if the aim is to compare exam marks for men and women you might say your analysis

will include:

 Histograms of men’s marks and women’s marks with comments

 5 number summary of marks for men and women with comments

 Side by side boxplots of marks with comments

 Check for outliers using 1.5IQR rule and comment on outlier values

 Mean and standard deviation of men and women’s marks with comments

Bloggs.Karen.72160.A3.1234567 3

 Normal quantile plots of men and women’s marks with comments

 A two sample t test to compare mean marks for men and women*

 A confidence interval for the difference between the two means

*Think carefully about whether a two-sample t test or a matched-pairs t test is appropriate.

Repeat for Aim 2.

Note:

1. When doing tests of significance you are expected to show hypotheses, comment on validity,
test statistic, degrees of freedom, P-value and conclusion in your final project and include the
output in the appendix. See Formatting Instructions found under Assignment 4 in the

Assessments section of the Online Campus.

2. We have not covered inference for regression in this course, so if you are doing regression
you will be expected to find and discuss the following: scatterplot, R, R

2
, regression equation

and residual plot, but we do not expect t-tests or confidence intervals when addressing this

aim.

5. Data

Insert your dataset (or part of it; at least 5 observations) here. Make sure the columns are clearly

labelled with the variable names you have referred to above. Do not include any confidential

information, such as names.

For example:

ID number Gender Age Income ($) Location

1 Male 23 45000 Wellington

2 Female 45 87000 Wellington

3 Male 40 55500 Auckland

4 Female 25 28400 Christchurch

5 Female 33 37650 Auckland

Important Note: See the Assignment 4 Formatting Instructions in under Assignment 4 in
Assessments section of the Online Campus. Also refer to the relevant information in your Assessment

booklet (pink pages or in Assessments section of the Online Campus).

Stuck for data?

You will find some suggested data sources under Assignment 3 in Assessments section of the Online

Campus.

2

>Sheet

1

http://www.statsci.org/data/oz/ms

21

2.html

Height Weight Age Gender Smokes Alcohol Exercise Ran Pulse1 Pulse2 Year 1

7

3 57 18

2 2 1 2 2

86 88 93 1

79 58 19

2 2 1 2 1

82 1

50

93
1

67 62

18 2 2 1 1 1

96 1

76

93
1

95 84

18 1 2 1 1 2

71 73

93
173 64

18 2 2 1 3 2

90

88 93
184 74 22

1 2 1 3 1

78 1

41

93
162

57

20

2 2 1 2 2

68 72

93
1

69 55

18 2 2 1 2 2 71

77

93
164 56

19 2 2 1 1 2 68 68 93
168 60 23

1 2 1 2 1 88

150

93
1

70 75

20 1 2 1 1 1 76 88 93
178

58 19 1 2 2 3 2 74 76 93
170

68 22 1 1 1 2 2 70 71 93
1

87 59

18 1 2 1 1 2 78 82 93
1

80

72 18 1 2 1 2 2 69 67 93
1

85 110

22 1 2 1 3 2 77 73 93
170 56 19 1 2 2 3 2 64

63

93
180

70 18 1 2 1 2 1 80

1

46

93
1

66

56 21 2 1 2 2 2

83

79 93
155

50 19 2 2 2 2 2 78 79 93
175

60 19 1 2 2 3 2 88 86 93
140

50

34

2 2 2 3 1 70

98

93
163

55 20 2 2 2 3 2 78 74 93
182

75

26

1 1 1 2 2 80 76 93
176

59 19 1 2 2 2 2 68 69 93
177

74 18 2 2 2 2 1 70 96 93
170 60 18 1 2 1 2 2 62 59 95
172

60 21 2 2 2 3 2

81

79 95
1

89

60 19 1 2 1 2 1 78 168 95
178 56 21 2 2 1 2 1 86 150 95
175 75 20 1 2 1 2 1 59

92

95
180 85 19 1 1 1 2 1 68

1

25

95
160

57 19 2 2 2 2 1 75

130

95
164 66 23 2 2 2 3 1 74 168 95
175

65

19 1 2 1 2 1 60

104

95
163 55 20 2 2 2 2 1 70

119

95
185

90 18 1 2 2 3 1 80 140 95
169

68 19 1 2 2 2 2 58 58 95
165

63 18 2 2 1 2 2 84 84 95
155

49

18 2 2 1 2 2 104 92 95
175 66 20 1 2 1 2 2 66 68 95
178 63 23 1 2 1 3 2 84 90 95
184 65 21 1 1 2 2 2 65 67 95
170 60 19 2 2 1 2 2 80 80 95
162 60 19 2 2 1 2 2 66 60 95
164 46 18 2 2 2 2 2 104 96 95
171

70 26 2 2 2 2 2 76 76 95
182 85 20 1 1 1 3 2 70 68 95
174

60 19 2 2 1 3 1 66 89 96
167

70 22 1 1 1 3 2 92 84 96
157

41 20 2 2 2 2 1 70 95 96
183

73 20 1 2 1 2 2 63 65 96
167 75 20 2 2 1 2 2 65 67 96
171 67 18 2 2 1 3 2 76 74 96
182 63 20 1 2 1 1 1 56 110 96
173 70 20 1 2 1 1 1 64

126

96
182 85 20 1 2 1 1 2 60 56 96
158 51

18 2 2 2 2 1 68 84 96
160 49 19 2 2 2 3 2 80 72 96
180 75 20 1 2 1 2 1 65 82 96
180 77 18 2 2 2 2 1

47 136

96
188

87 20 1 2 1 1 1 50 90 96
164

54

18 2 2 2 3 2 80 76 96
180

102

20 1 2 1 2 2 76 72 96
178 62 21 1 2 2 3 2 70 74 96
166

50 19 2 2 1 3 1 76

132

96
175 57 20 2 2 1 2 1 72

115

96
180 80 21 1 2 1 2 2 80 80 96
182 98 19 1 2 1 2 1 76 150 96
151 42

22 2 2 2 3 1 85 130

97 186

87 23 1 2 1 1 1 49 83 97
190

82 19 1 2 2 2 2 76 73 97
179

80 20 1 2 1 2 1

1

45

155 97
165

48

19 2 2 2 3 2 83 84 97
172

53

20 1 2 2 3 1 72 136 97
173 64 20 2 2 1 2 2

NA

NA 97
170

53.5

20 2 2 2 3 2 60 62 97
170

58.5

20 1 2 2 3 2 80 82 97
163 51 18 2 2 1 3 1 70

120

97
191

78 19 1 2 1 1 1 68 136 97
172 59 18 2 2 1 2 1 78

129

97
171 71 41 1 2 2 3 2

52

60 97
180 76 21 1 2 2 1 2 74 72 97
194

110 25 1 2 2 2 2 75 75 97
167 63

28

1 2 1 2 2 72 68 97
192 105

21 1 2 2 2 2 80 73 97
194 95 18 1 2 1 2 1 84 140 97
189

88 45 1 2 2 2 2 74 72 97
162 50 19 2 2 1 2 1 90 160 97
175 54 18 2 2 1 2 2

61

59 97
175

78.5

19 1 2 1 3 1 85

131

97
186 96 19 1 2 1 3 1 78 132 97
178 86 21 1 1 1 3 2 76 80 98
170 58 21 1 1 1 2 2 90 84 98
165 58 23 2 2 1 3 2 64 68 98
164 78 28 2 2 2 2 1 64 120 98
180 65 20 1 2 2 2 1 88

144

98
170 62 20 2 2 1 2 2 64 64 98
155 55 20 2 2 1 1 2 82 87 98
165 60 19 2 1 1 3 1 88 120 98
168 55

24

2 2 2 2 2 74 70 98
68 63 19 1 2 2 2 1 88 136 98
170 63 20 2 2 1 3 1 92 120 98
179 80 20 1 2 2 2 1 76 168 98
163 47 23 2 1 1 3 1 71

125

98
93

27

19 2 2 2 3 2 119 120 98
161 43

19 2 2 2 3 2 90 89 98
182 60 22 1 2 1 3 2 86 84 98
170 65 18 1 2 1 1 2 69 64 98
185 85 19 1 2 1 2 2 75 68 98

http://www.statsci.org/data/oz/ms212.html

Sheet2

Sheet3

Still stressed with your coursework?
Get quality coursework help from an expert!