Assignment 2: Inferential Statistics and Generalization

/in /by

Assignment 2: Inferential Statistics and Generalization

Assignment Introduction

When reporting the results of a quantitative study it is necessary to provide descriptive statistics in order to detail information about your independent and dependent variables as you did in your Unit 3 Assignment. You also need to provide appropriate inferential statistics to test the research hypothesis. Beyond using the correct statistical procedure the most important aspect of reporting the inferential statistics is the appropriate interpretation of those results. This Assignment is concerned with the appropriate inferential statistics based on specific hypotheses.

Contents hide
1 Save your time - order a paper!
2 Directions
3 Quizzes
4 GPA-IQ
5 Total Points by Gender
6 Total Points by Race
7 Grading Rubric

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

Assignment Directions

Open the Assignment 5 Excel Spreadsheet and save it to your computer using the following naming convention:

Last_name_Unit 5_Descriptive_Statistics.

Once you have saved the spreadsheet to your computer, test the following hypotheses using the appropriate inferential statistics. Be sure to include your interpretation of the results, including the test statistic and the p-value where provided.

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.

You will be submitting your Excel Spreadsheet so make sure that you have saved all your work to the spreadsheet before submitting the Assignment.

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