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 each of the above:
For example: A Pearson correlation was conducted to determine the relationship between height and weight.
For example: There is a significant positive correlation between height and weight (r =.91, p <.05).
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:
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
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
We create perfect papers according to the guidelines.
We seamlessly edit out errors from your papers.
We thoroughly read your final draft to identify errors.
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
Dedication. Quality. Commitment. Punctuality
Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.
We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.