Stats again

profileclbffmillenx4
Data_Sets.xlsx
Home>Education homework help>Stats again

Directions

Unit 5 Assignment 2: Inferential Statistics and Generalization
Directions:
As you create your inferential statistics you may place your output on a separate sheet in this spreadsheet.
1. Test the following research hypothesis using the Quizzes tab. “There is an increase in performance between the first quiz and the fifth quiz.”
2. Test the following research hypothesis using the GPA-IQ tab. “There is a positive correlation between a person’s measured IQ and their GPA at graduation.” Based on the regression equation predict the GPA for a person with a measured IQ of 120.
3. Test the following research hypothesis using the Total Points by Gender tab. “Females score higher on the examination that males.”
4. Test the following research hypothesis using the Total Points by Race tab. “There is no difference between the mean scores based on racial identification.”
5. Save your work often while completing the Assignment.

Quizzes

Directions: Test the following research hypothesis using the data below. “There is an increase in performance between the first quiz and the fifth quiz.”
Student Quiz 1 Quiz 2 Quiz 3 Quiz 4 Quiz 5
1 7 8 6 7 10
2 4 8 10 10 7
3 4 6 5 4 5
4 7 10 9 8 9
5 4 5 6 6 6
6 7 8 9 8 10
7 3 6 2 6 6
8 10 8 10 10 8
9 10 10 10 10 9
10 6 7 9 6 8
11 9 8 10 10 10
12 8 6 7 8 9
13 10 10 10 10 8
14 7 6 10 8 7
15 8 9 8 8 7
16 8 10 10 8 9
17 10 9 10 10 9
18 10 8 10 10 7
19 6 5 7 6 8
20 10 9 10 10 10
21 5 7 4 7 6
22 7 9 10 10 9
23 7 6 9 8 8
24 6 9 9 7 10
25 6 7 7 7 5
26 7 8 7 7 6

GPA-IQ

Directions: Test the following research hypothesis using the data below. “There is a positive correlation between a person’s measured IQ and their GPA at graduation.” Based on the regression equation predict the GPA for a person with a measured IQ of 120.
IQ GPA
118 2.32
112 2.34
103 2.8
108 3.53
123 3.84
110 1.84
110 3.7
110 3.9
103 2.03
99 2.28
100 1.91
108 2.66
124 3.9
120 2.56
102 2.92
125 3.9
131 3.28
105 2.02
121 1.18
124 2.84
110 1.66
97 2.38
108 2.8
105 1.61
114 1.77
119 3.98
115 3.49
117 2.09
124 2.38
102 2.34
121 3.17
128 3.35
97 1.24
122 2.56
125 3.9
124 3.13
135 4
121 2.31
125 3.49
95 1.14
132 3.42
101 1.77
113 2.57
114 2.27
121 2.43
123 2.56
113 2.84
132 2.22
111 2.11

Total Points by Gender

Directions: Test the following research hypothesis using the data below.. “Females score higher on the examination that males.”
Males Females
85 100
75 88
70 80
75 82
83 100
87 85
65 75
92 70
82 65
70 94
100 99
85 77
90 100
75 78
82 85
84 88
88 82
69 91
70 88
85 94

Total Points by Race

Directions: Test the following research hypothesis using the Total Points by Race tab. “There is no difference between the mean scores based on racial identification.”
Caucasian African-American Hispanic Mixed
84 75 80 60
81 92 89 72
100 64 79 69
100 96 65 84
76 92 94 61
77 94 60 78
73 73 70 62
86 76 97 80
99 83 64 60
66 60 99 65
90 73 74 71
82 88 93 63
78 71 75 77
77 92 98 88
64 93 62 90
96 62 83 77
62 66 94 99
77 74 86 92
90 73 78 85
79 87 73 91

Grading Rubric

ED572 Unit 5: Inferential Statistics and Generalization
Directions: Your instructor will review your Excel spreadsheet with the assumption that you have earned the full 150 points. If there are any deductions from that score, a comment will be provided to let you know what you did and what you should do better or to correct any errors. You are urged to use this rubric as a guide when you are completing your Unit 5 Assignment.
Criteria Expectation Possible Points
Use of Excel The correct Excel procedure was used to conduct the test of hypothesis. 25
Interpretation of Statistical Output The interpretation of the statistical output includes the correct description of the following: • Value of Test Statistic • Degrees of Freedom • Level of Significance • P-Value 50
Test of Hypothesis Decision The decision to reject or fail to reject the Null Hypothesis is explained in terms of the relationship between the selected level of significance and the p-value. 50
Explanation of Decision The decision to reject or fail to reject the Null Hypothesis is explained in terms of the research hypothesis. The conclusion is explained in non-technical language. 25
Instructor Comments:
Total 150 Points