final
Using the provided data set, you will generate descriptive statistics, data visuals, and a summary of your analysis. The data for this assignment is simulated data from a hypothetical web-based survey design. Subjects in this study were graduate psychology students. Subjects’ email addresses were randomly selected from a random sample of universities in the United States.
Remember, this is a data set for which you were not one of the primary researchers.
Use descriptive and inferential statistics to test the following hypotheses and research question:
- For U.S. psychology majors, younger students are healthier than older students.
- There is no difference between men and women on aggression.
- Is there a relationship between personality and life satisfaction?
For each of the above:
- Identify the type of statistical procedures used to test the hypothesis and why you selected this procedure
For example: A Pearson correlation was conducted to determine the relationship between height and weight.
- State the result of the procedure- was there a significant finding?
For example: There is a significant positive correlation between height and weight (r =.91, p <.05).
- Provide an interpretation of the result and clearly explain what these findings mean (350-400 words)
For example: For this sample, the taller someone is the heavier he or she will be
Next, choose one of your findings and create a data visual (e.g., graph) to accompany your results.
Use Sheet 2 from the Excel spreadsheet for this part.
If you are running an actual analysis (using SPSS, for example) then use Sheet 1.
Your graph should depict the result you have chosen. Ensure that your graph contains the following:
- A title
- Labels on each axis
- A legend or labels on the data points
- A brief explanation that tells the reader how to look at the graph and interpret your findings
Helpful Resources
https://stats.idre.ucla.edu/spss/whatstat/what-statistical-analysis-should-i-usestatistical-analyses-using-spss/
https://www.socscistatistics.com/tutorials/ttest/default.aspx
How to Make a Graph in Excel & Add Visuals to Your Reporting
https://blog.hubspot.com/marketing/how-to-build-excel-graph
Figure 1
As seen in Figure 1, as height increases along the x axis, weight also increases on the y axis. For example, individuals with a height of 5’1 weight 90lbs on average, whereas individuals who were 6 feet weight approximately 189lbs.
>Sheet 1 1 1 2 1 2 3 3 9 1 1 2 1 2 7 3 1 2 3 3 3 1 2 4 2 4 7 1 2 3 4 4 3 1 5 5 5 8 2 1 3 3 5 1 1 2 5 6 3 10 2 1 2 3 2 3 4 0.04 2 6 3 5 6 4 1 2 2 3 8 4 1 2 6 4 5 10 4 2 6 2 3 4 2 8
1 6 6 2 1 1 39 1 5 6 3 9 2 4
2 3 5 4 3 2 2 6 2 1 7 1 2 3 5 2 8 3 0.66 1 2 4 2 1 4 24 1 3 5 3 9 3 1 5 1 2 3 3 1 1 1 1 2 1 61 2 4 4 5 6 4 39 1 3 6 4 3 2 0.73 61 2 1 3 5 7 1 1 3 3 6 3 4 28 1 4 5 3 7 1 1 6 4 3 9 2 28 2 5 6 6 7 3 47 1 1 2 4 4 4 8
31 1 1 6 3 5 2 1 5 1 3 4 3 40 1 1 3 1 3 3 39 2 6 2 3 10 4 34 2 3 6 6 5 3 0.05 2 1 1 5 8 4 52 2 3 3 1 2 4 24 1 4 1 2 4 2 0.2 2 6 4 5 7 3 32 2 2 4 6 3 2 0.02 69 2 6 6 4 5 2 72 54 1 3 5 4 6 2 0.11 21 1 3 4 2 9 3 8 68 1 2 6 1 7 2 20 2 4 2 3 5 3 27 2 6 5 1 9 2 52 1 4 6 2 1 3 0.3 70 1 4 4 2 5 3 0.01 43 2 2 2 2 2 4 42 2 2 6 3 10 2 54 2 4 4 2 8 2 0.18 40 2 6 1 4 7 1 0.65 56 1 3 1 2 4 1 19 1 1 2 6 1 1 0.07 38 1 3 6 3 8 3 0.24 52 1 5 2 4 5 3 26 1 5 1 1 4 3 0.02 35 1 1 6 1 5 2 0.17 45 2 6 2 2 6 3 0.73 60 1 1 4 5 3 1 70 1 5 3 1 10 3 63 2 4 1 3 5 4 53 2 3 5 1 8 1 23 1 4 6 2 9 1 46 1 1 4 3 9 2 1.12 56 1 3 5 4 8 2 54 1 5 6 1 6 2 30 2 4 4 4 3 4 0.41 21 1 6 4 6 8 3 48 1 1 4 2 1 3 0.19 36 1 5 6 3 7 3 0.38 45 1 2 5 3 5 4 0.9 28 1 1 6 6 6 2 19 2 6 5 3 6 1 0.34 50 2 2 2 3 3 4 0.47 58 1 6 3 1 1 3 67 2 4 4 3 10 4 0.43 69 1 1 2 1 7 2 0.24 62 2 2 2 6 1 2 60 2 2 4 1 4 1 50 1 3 3 2 5 2 19 1 4 3 1 5 2 0.59 33 2 3 3 5 10 4 0.1 30 1 1 1 3 9 4 52 1 5 5 3 7 2 48 1 4 4 2 3 1 0.16 61 1 6 6 3 9 2 0.13 56 1 5 5 6 4 3 0.05 55 1 2 1 3 3 3 53 1 2 4 4 5 1 0.1 43 2 3 3 2 1 2 0.41 36 1 3 4 4 4 2 53 2 4 3 3 3 2 67 2 5 5 6 8 2 1.12 61 2 5 5 4 3 2 0.62 28 1 2 1 6 2 3 0.41 22 2 5 5 3 3 1 42 2 4 5 2 8 2 1 69 2 6 5 6 10 2 0.11 27 1 3 4 5 8 1 0.65 51 1 4 4 1 6 2 0.07 60 1 5 6 1 7 1 0.56 63 1 1 1 2 9 4 41 1 2 3 3 3 1 0.07 24 2 4 2 4 7 1 0.68 62 2 3 4 4 10 3 0.66 63 1 3 3 5 1 1 0.44 18 2 5 6 3 10 2 0.66 25 1 2 3 2 3 4 0.04 61 2 6 3 5 6 4 0.72 46 2 6 4 5 10 4 0.31 66 1 2 6 3 2 2 0.24 47 2 6 2 1 7 1 0.1 48 2 3 5 2 8 3 0.66 24 1 3 5 3 9 3 0.44 58 1 5 1 2 3 3 0.73 61 2 4 4 5 6 4 1.14 61 2 1 3 5 7 1 0.5 34 1 3 3 6 3 4 0.33 28 1 4 5 3 7 1 0.65 38 1 6 4 3 9 2 0.49 65 2 5 4 5 5 1 0.41 27 1 5 4 1 1 4 0.16 40 1 1 3 1 3 3 0.5 39 2 6 2 3 10 4 0.42 50 1 4 3 5 7 3 0.19 23 2 4 1 3 7 2 0.14 41 2 6 5 2 7 3 0.95 34 1 1 2 1 3 1 0.62 34 1 4 3 3 3 1 0.72 54 1 3 5 4 6 2 0.11 66 2 4 4 1 9 4 1.09 21 1 3 4 2 9 3 27 2 6 5 1 9 2 0.01 70 1 4 4 2 5 3 0.01 54 2 4 4 2 8 2 0.18 53 1 4 2 4 5 3 1.1 61 1 5 1 3 4 1 0.24 38 1 3 6 3 8 3 0.24 35 1 1 6 1 5 2 0.17 70 1 5 3 1 10 3 0.25 23 1 4 6 2 9 1 0.59 46 1 1 4 3 9 2 1.12 56 1 3 5 4 8 2 1.03 60 2 2 4 1 4 1 0.84 50 1 3 3 2 5 2 0.86 48 1 4 4 2 3 1 0.16 55 1 2 1 3 3 3 1.02 67 2 5 5 6 8 2 1.12 42 2 4 5 2 8 2 1 27 1 3 4 5 8 1 0.65 51 1 4 4 1 6 2 0.07 This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Students and Health
Exemplary
Accomplished
Developing
Beginning
Did not attempt
Criterion Score
Statistical Procedure
8 points Student uses an appropriate statistic to test each research question and provides an accurate justification for why that procedure was used.
6.8 points Student uses an appropriate statistic to test most research questions and provides mostly an accurate justification for why that procedure was used.
6 points Student uses an appropriate statistic to test some research questions and provides some accurate justifications for why that procedure was used.
5.2 points Student uses an appropriate statistic to test few research questions and provides few accurate justification for why that procedure was used.
0 points Student does use appropriate statistics to test research questions and does not provide justifications for why the procedure was used.
/ 8 This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Student and Health Exemplary Accomplished Developing Beginning Did not attempt Criterion Score Statistical Outcome 8 points Student provides a clear and an accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values. 6.8 points Student provides a mostly accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values. 6 points Student provides a report of the outcome for the test conducted but does not indicate the test statistic values or p-values. 5.2 points Student provides a vague report of the outcome for the test conducted but does not indicate the test statistic values and p-values. 0 points Student does not provides an accurate report of the outcome for the test conducted and does not indicate the test statistic values and p-values. / 8 Accomplished Developing Beginning Did not attempt Criterion Score Interpreting Results 8 points Student provides an insightful explanation of the results. Explanations are clear, articulate, and help the reader understand the results. Explanation is between 350-400 words. 6.8 points Student provides an accurate explanation of the results. Explanations are mostly clear and help the reader understand the results. Explanation is between 350-400 words. 6 points Student provides a marginal explanation of the results. Explanations are somewhat difficult to read and follow.Explanation is between 250-350 words. 5.2 points Student attempts an explanation of the results, but does not demonstrate conceptual understanding. Explanations are difficult to read and follow. Explanation is less than 250 words. 0 points Student does not provide an explanation of results that the reader can follow or understand. / 8 This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Agression and Gender Exemplary Accomplished Developing Beginning Did not attempt Criterion Score Accomplished Developing Beginning Did not attempt Criterion Score This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Aggression and Gender Exemplary Accomplished Developing Beginning Did not attempt Criterion Score Accomplished Developing Beginning Did not attempt Criterion Score This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Personality and Life Satisfaction Exemplary Accomplished Developing Beginning Did not attempt Criterion Score Student uses an appropriate statistic to test few research questiona and provides few accurate justifications for why that procedure was used. 0 points Student does use appropriate statitics to test research questions and does not provide justifications for why the procedure was used. / 8 Accomplished Developing Beginning Did not attempt Criterion Score Accomplished Developing Beginning Did not attempt Criterion Score Student provides a marginal explanation of the results. Explanations are somewhat difficult to read and follow. Explanation is between 250-350 words. 5.2 points This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.VIsualization Exemplary Accomplished Developing Beginning Did not attempt Criterion Score Visualization Components 8 points Student uses appropriate labels for each element and elements are easily distinguishable. Graph is organized and visually appealing. 6.8 points Student uses mostly appropriate labels for each element and elements are easily distinguishable. Graph is organized and visually appealing. 6 points Student uses some appropriate labels for elements. Graph is somewhat organized but difficult to follow. 5.2 points Student uses few appropriate labels for elements. Graph contains indistinguishable elements Inappropriately overlapping or covering of elements. 0 points Student does not present a graph for finding. / 8 This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Visualization Exemplary Accomplished Developing Beginning Did not attempt Criterion Score Visualization Interpretation 8 points Student provides an insightful interpretation of the visualization and draws multiple connections between elements in the visual to the explanation of the findings. 6.8 points Student provides an interpretation of the visualization and draws a connection between elements in the visual to the explanation of the findings. 6 points Student provides a marginal interpretation of the visualization and attempts to draw a connection between elements in the visual to the explanation of the findings. 5.2 points Student attempts to provide an interpretation of the visualization and attempts to draw a connection between elements in the visual but does not relate to what is presented in the visual. 0 points Student does not provide an interpretation of the visual and draw connections between elements to explain the findings. / 8 Writing Formatting 12 points Work is presented in a logical and coherent way. Writing is clear, articulate, and error free. Citations are composed in proper APA format with few or no errors. 10.2 points Work is grammatically sound with a few minor errors. Citations are composed in proper APA format with some errors. 9 points Work contains frequent grammatical errors. Citations are inaccurate or improperly formatted. 7.8 points Work contains frequent grammatical errors. Citations are not included for article. 0 points Work does not demonstrate appropriate graduate level writing. Difficult to follow ideas. Citations are not included for article. / 12 Rubric Total ScoreTotal / 108
2
1
ID
Age
Sex
Extraversion
Agreeableness
Conscientiousness
Agression
Satisfaction
Health
1
6
3
9
4
0.6
7
2
42
0.
37
3
39
0.
22
4
41
0.07
5
24
0.6
8
6 24 2 4 6 5 7 3
0.05
7
62
10
0.
66
8
59
0.04
9
63
0.
44
10
18
0.66
11
25
12
61
0.
72
13
70
14
46
0.
31
15
49
1.1
16
60
0.
78
17
0.41
18 66 1 2 6 3 2 2
0.2
19
64
0.
85
20
47
0.1
21
48
22
30
0.18
23
0.44
24
58
0.73
25 70 2 2 1 5 7 2 1
26
45
1.19
27
1.14
28
29
0.5
30 20 2 5 2 2 9 2
0.46
31
34
0.
33
32
0.
65
33
38
0.49
34 65 2 5 4 5 5 1 0.41
35
0.13
36
0.
52
37 24 1 6 6 3 8 3
0.26
38 58 2 4 3 5 5 4
0.02
39 19 1 4 4 5 6 2
0.3
40
0.09
41 27 1 5 4 1 1 4
0.16
42
56
0.64
43
0.65
44 37 1 6 1 2 3 1
0.
53
45 23 1 3 6 5 5 1
0.63
46 63 1 3 5 2 1 2
0.
71
47 39 1 2 1 5 7 4
0.29
48 45 2 2 5 6 7 2
0.22
49 52 1 6 6 5 3 1
0.
98
50
0.42
51
52
57
0.38
53 29 1 2 3 6 2 1
0.52
54
0.34
55
56 50 1 4 3 5 7 3
0.19
57 44 2 5 5 5 10 1 0.42
58 34 1 2 6 3 5 2
0.48
59 58 1 2 1 2 2 3
0.72
60 23 2 4 1 3 7 2
0.14
61 44 2 1 2 5 5 4 0.29
62 33 1 6 6 2 7 3
0.03
63
68
0.17
64 46 1 2 1 4 3 1 0.02
65 41 2 6 5 2 7 3
0.
95
66 34 1 1 2 1 3 1
0.62
67
68 41 2 2 3 1 8 3
1.2
69
0.68
70 34 1 4 3 3 3 1 0.72
71 50 2 6 6 3 4 2 1.14
72 54 1 3 5 4 6 2
0.11
74
0.
75
75 58 1 6 3 2 2 2
0.9
76
0.
88
77
0.43
78 34 2 1 5 4 7 4 0.03
79
0.01
80
81
82
0.06
83
1.16
84
85 53 1 4 2 4 5 3 1.1
86
87
1.12
88 61 1 5 1 3 4 1
0.24
89
90
91
0.37
92
93
94
95 65 1 2 4 5 6 3 0.3
96
1.09
97
0.25
98 56 2 5 4 4 5 1
1.07
99
0.47
100
0.95
101
0.59
102
103
1.03
104
0.31
105
106
0.56
107
108
109
110
0.21
111
112
113
0.28
114
115
116
0.91
117
0.84
118
0.86
119
120
121
0.71
122
0.12
123
124
125
126
1.02
127
128
129
0.54
130
0.58
131
132
133
134
0.33
135
136
137
138
139
140
0.67
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
0.75
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
Sheet2
ID Age Sex Extraversion Agreeableness Conscientiousness Agression Satisfaction Health
1 22 1 4 4 5 6 2 0.38
2 31 1 1 6 3 5 2 0.09
3 27 1 5 4 1 1 4 0.16
4 56 1 5 1 3 4 3 0.64
5 40 1 1 3 1 3 3 0.65
6 37 1 6 1 2 3 1
0.53
7 23 1 3 6 5 5 1 0.63
8 46 1 3 5 2 1 2 0.49
9 39 1 2 1 5 7 4 0.29
10 45 2 2 5 6 7 2 0.22
11 52 1 6 6 5 3 1
0.98
12 39 2 6 2 3 10 4 0.42
13 34 2 3 6 6 5 3 0.05
14 57 2 1 1 5 8 4 0.38
15 29 1 2 3 6 2 1 0.52
16 52 2 3 3 1 2 4 0.34
17 24 1 4 1 2 4 2 0.2
18 50 1 4 3 5 7 3 0.19
19 44 2 5 5 5 10 1 0.42
20 34 1 2 6 3 5 2 0.48
Sheet3
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Students and Health
Exemplary
Statistical Procedure
8 points
Student uses an appropriate statistic to test each research question and provides an accurate justification for why that procedure was used.
6.8 points
Student uses an appropriate statistic to test most research questions and provides mostly an accurate justification for why that procedure was used.
6 points
Student uses an appropriate statistic to test some research questions and provides some accurate justifications for why that procedure was used.
5.2 points
Student uses an appropriate statistic to test few research questions and provides few accurate justification for why that procedure was used.
0 points
Student does use appropriate statistics to test research questions and does not provide justifications for why the procedure was used.
/ 8
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Agression and Gender
Exemplary
Statistical Outcome
8 points
Student provides a clear and an accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values.
6.8 points
Student provides a mostly accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values.
6 points
Student provides a report of the outcome for the test conducted but does not indicate the test statistic values or p-values.
5.2 points
Student provides a vague report of the outcome for the test conducted but does not indicate the test statistic values and p-values.
0 points
Student does not provide an explanation of results that the reader can follow or understand.
/ 8
Statistical Outcome
8 points
Student provides a clear and an accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values.
6.8 points
Student provides a mostly accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values.
6 points
Student provides a report of the outcome for the test conducted but does not indicate the test statistic values or p-values.
5.2 points
Student provides a vague report of the outcome for the test conducted but does not indicate the test statistic values and p-values.
0 points
Student does not provide an explanation of results that the reader can follow or understand.
/ 8
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Aggression and Gender
Exemplary
Interpreting Results
8 points
Student provides an insightful explanation of the results. Explanations are clear, articulate, and help the reader understand the results. Explanation is between 350-400 words.
6.8 points
Student provides an accurate explanation of the results. Explanations are mostly clear and help the reader understand the results. Explanation is between 350-400 words.
6 points
Student provides a marginal explanation of the results. Explanations are somewhat difficult to read and follow.Explanation is between 250-350 words.
5.2 points
Student attempts an explanation of the results, but does not demonstrate conceptual understanding. Explanations are difficult to read and follow. Explanation is less than 250 words.
0 points
Student does not provide an explanation of results that the reader can follow or understand.
/ 8
Statistical Procedure
8 points
Student uses an appropriate statistic to test each research question and provides an accurate justification for why that procedure was used.
6.8 points
Student uses an appropriate statistic to test most research questions and provides mostly an accurate justification for why that procedure was used.
6 points
Student uses an appropriate statistic to test some research questions and provides some accurate justifications for why that procedure was used.
5.2 points
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Personality and Life Satisfaction
Exemplary
Statistical Outcome
8 points
Student provides a clear and an accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values.
6.8 points
Student provides a mostly accurate report of the outcome for the test conducted and correctly indicates the test statistic values and p-values.
6 points
Student provides a report of the outcome for the test conducted but does not indicate the test statistic values or p-values.
5.2 points
Student provides a vague report of the outcome for the test conducted but does not indicate the test statistic values and p-values.
0 points
Student does not provide an explanation of results that the reader can follow or understand.
/ 8
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.Personality and Life Satisfaction
Exemplary
Interpreting Results
8 points
Student provides an insightful explanation of the results. Explanations are clear, articulate, and help the reader understand the results. Explanation is between 350-400 words.
6.8 points
Student provides an accurate explanation of the results. Explanations are mostly clear and help the reader understand the results. Explanation is between 350-400 words.
6 points
Student attempts an explanation of the results, but does not demonstrate conceptual understanding. Explanations are difficult to read and follow. Explanation is less than 250 words.
0 points
Student does not provide an explanation of results that the reader can follow or understand.
/ 8