Expert answer:student chart included along with the instructions below please 1500 word requirement not including chart
student_data_save_as.xls
statistics_homework_unit_four.docx
Unformatted Attachment Preview
ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Gender
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Employ
Unemployed
Full Time
Part Time
Full Time
Full Time
Unemployed
Full Time
Full Time
Part Time
Full Time
Part Time
Full Time
Full Time
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Unemployed
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Part Time
Unemployed
Part Time
Full Time
Full Time
Unemployed
Full Time
Full Time
Part Time
Part Time
Full Time
Unemployed
Full Time
Part Time
Full Time
Full Time
Full Time
Unemployed
Full Time
Age
39
55
43
56
38
54
30
37
38
42
52
35
37
53
51
40
33
53
43
35
57
32
59
48
34
53
35
38
37
46
44
31
51
47
56
42
44
54
51
42
45
55
47
43
57
MBA_GPA
2.82
3.49
3.28
3.25
3.26
2.87
3.16
3.4
2.84
3.72
3.22
3.44
3.65
3.02
3.03
3.8
3.23
3.26
3.53
3.75
3.15
3.66
3.36
3.79
2.85
3.74
3.23
3.52
3.32
2.89
2.83
2.93
3.71
3.47
3.52
2.83
3.64
2.96
3.59
3.33
3.38
3.44
3.31
3.03
3.26
BS GPA
3.05
3.45
3.5
3.55
3.3
3.05
3.35
3.35
3.05
3.7
3.5
3.55
3.9
3.3
3.25
3.8
3.5
3.5
3.75
3.9
3.2
3.75
3.45
3.85
3.05
3.9
3.25
3.7
3.45
3.1
3.05
3.1
3.8
3.75
3.65
3.05
3.55
3.1
3.8
3.55
3.6
3.35
3.45
3.25
3.4
Hrs_Studying
3
7
7
7
6
4
6
6
3
7
7
7
8
6
6
8
7
7
8
8
6
8
7
8
3
8
6
7
7
4
3
5
8
8
7
3
7
4
8
7
7
6
7
6
7
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Full Time
Part Time
Full Time
Full Time
Full Time
Full Time
Full Time
Full Time
Unemployed
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Full Time
Full Time
Full Time
Full Time
Full Time
Unemployed
Full Time
Part Time
Full Time
Part Time
Full Time
Part Time
Full Time
Full Time
Full Time
Full Time
Full Time
Full Time
Full Time
Unemployed
Full Time
Full Time
Full Time
Full Time
Full Time
Full Time
Full Time
Part Time
Full Time
Full Time
Full Time
Full Time
36
58
46
53
59
49
34
46
46
33
56
39
51
55
38
33
34
31
37
46
31
47
54
52
43
44
34
59
45
30
32
32
40
48
51
30
31
35
33
35
31
38
46
45
59
58
46
3.04
2.98
2.8
3.75
3.64
3.65
3.18
3.44
3.06
3.51
3.33
2.81
3.64
3.05
2.85
3.56
2.92
3.35
3.46
3.59
3.11
3.65
3.17
2.97
3.77
3.21
3.17
3.65
2.94
3.53
3.65
3.61
3.7
2.91
3.09
3.77
3.79
3.59
3.38
3.57
2.97
3.44
3.64
3.48
2.99
3.73
2.91
3.25
3.1
3.05
3.75
3.65
3.8
3.3
3.4
3.15
3.75
3.4
3.05
3.8
3.4
3.05
3.6
3.1
3.5
3.35
3.75
3.2
3.7
3.5
3.1
3.9
3.2
3.15
3.65
3.1
3.7
3.6
3.7
3.9
3.1
3.25
3.95
3.8
3.6
3.5
3.5
3.1
3.65
3.55
3.4
3.1
3.8
3.05
6
5
2
8
7
8
6
7
6
8
7
2
8
7
3
7
5
7
6
8
6
8
7
5
8
6
6
7
5
8
7
8
8
5
6
9
8
7
7
7
5
7
7
7
5
8
4
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
No Major
Leadership
No Major
Leadership
Leadership
No Major
Leadership
No Major
No Major
Leadership
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
No Major
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Full Time
Part Time
Full Time
Full Time
Full Time
Full Time
Full Time
Full Time
Unemployed
Full Time
Part Time
Full Time
Full Time
Full Time
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Full Time
Unemployed
Full Time
Full Time
Part Time
Unemployed
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Unemployed
Part Time
Full Time
Part Time
Full Time
Unemployed
Part Time
Full Time
Full Time
Full Time
Full Time
Unemployed
Full Time
Part Time
Full Time
35
53
31
50
38
50
48
53
53
30
32
42
56
46
49
32
36
42
37
31
31
42
39
47
28
28
52
35
38
44
38
52
53
53
31
47
51
37
46
48
54
48
36
39
28
45
31
3.78
3.4
3.13
3.14
3.24
3.56
3.16
3.53
3.01
3.3
3.62
3.21
3.39
3.65
3.47
3.44
3.88
3.83
3.53
3.22
3.56
3.2
3.17
3.41
3.56
3.34
3.44
3.76
3.55
3.88
3.31
3.09
3.82
3.01
3.66
3.64
3.59
3.49
3.13
3.83
3.04
3.91
3.56
3.96
3.46
3.22
3.27
3.95
3.4
3.15
3.25
3.3
3.5
3.25
3.55
3.15
3.35
3.6
3.4
3.4
3.8
3.7
3.6
3.95
3.95
3.6
3.3
3.8
3.25
3.3
3.6
3.7
3.6
3.6
3.8
3.45
3.9
3.45
3.15
4
3.2
3.85
3.7
3.65
3.55
3.2
3.9
3.15
4
3.7
4
3.4
3.15
3.2
9
7
6
6
6
7
6
7
6
6
7
7
7
8
8
7
9
9
7
6
8
6
6
7
8
7
7
8
7
8
7
6
9
6
8
8
7
7
6
8
6
10
8
9
7
6
6
140
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
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Finance
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Marketing
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Full Time
Part Time
Full Time
Part Time
Unemployed
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Part Time
Full Time
Unemployed
Full Time
Part Time
Full Time
Full Time
Part Time
Unemployed
Part Time
Full Time
Full Time
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Full Time
Unemployed
Part Time
Full Time
Full Time
Part Time
Full Time
Full Time
Part Time
Full Time
Unemployed
Full Time
Full Time
Full Time
Full Time
Full Time
Unemployed
Full Time
47
35
52
52
55
52
46
31
33
45
50
33
37
33
46
55
30
51
35
40
29
52
27
51
56
35
46
39
31
52
32
32
44
43
38
54
27
38
45
48
43
34
54
36
45
28
37
3.43
3.85
3.89
3.37
3.32
3.54
3.8
3.74
3.17
3.27
3.32
3.56
3.95
3.56
3.79
3.93
3.79
3.71
3.05
3.22
3.85
3.82
3.23
3.56
3.53
3.62
3.8
3.47
3.64
3.03
3.17
3.22
3.92
3.82
3.26
3.8
3.2
3.46
3.67
3.06
3.66
3.96
3.75
3.83
3.22
3.36
3.21
3.45
3.95
3.9
3.45
3.3
3.55
3.9
3.85
3.45
3.55
3.3
3.45
4
3.75
3.75
4
3.85
3.85
3.35
3.2
3.95
3.95
3.95
3.65
3.65
4
3.95
3.35
3.65
3.15
3.25
3.2
4
3.95
3.55
3.85
3.2
3.35
3.75
3.4
3.85
4
3.85
3.85
3.2
3.35
3.25
7
9
8
7
6
7
8
8
7
7
6
7
9
8
8
9
8
8
6
6
9
9
9
7
7
9
9
6
7
5
6
6
10
9
7
8
6
6
8
7
8
10
8
8
6
6
6
187
188
189
190
191
192
193
194
195
196
197
198
199
200
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Leadership
Full Time
Full Time
Unemployed
Full Time
Full Time
Full Time
Unemployed
Full Time
Unemployed
Part Time
Full Time
Full Time
Part Time
Full Time
27
31
45
48
50
32
33
49
27
28
36
35
47
33
3.02
3.99
3.07
3.65
3.67
3.06
3.98
3.93
3.41
3.43
3.7
3.76
3.9
3.23
3.15
4
3.15
3.65
3.85
3.35
3.7
4
3.3
3.5
3.65
3.75
3.9
3.3
5
10
6
7
8
6
8
10
6
7
7
8
8
6
Works FT
0
1
0
1
1
0
1
1
0
1
0
1
1
1
0
1
1
0
1
0
1
0
1
1
0
1
0
0
0
1
1
0
1
1
0
0
1
0
1
0
1
1
1
0
1
Variable descriptions
Gender = 0 (male), 1 (female)
Major = student’s major
Age = age of student in years
MBA_GPA = overall GPA in the MBA program
BS_GPA = overall GPA in the BS program
Hrs_Studying = average hours studied per week
Works FT = 0 (No), 1 (Yes)
1
0
1
1
1
1
1
1
0
1
0
1
1
0
1
1
1
1
1
1
0
1
0
1
0
1
0
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
0
1
1
1
1
1
0
1
1
1
1
1
1
0
1
0
1
1
1
1
0
1
1
0
1
1
0
1
1
0
0
1
0
1
1
0
1
0
0
1
0
1
0
0
1
1
1
1
0
1
0
1
1
0
1
0
0
1
0
1
1
0
1
0
1
0
1
0
1
1
0
0
0
1
1
1
0
1
1
0
1
1
0
0
1
1
0
1
1
0
1
0
1
1
1
1
1
0
1
1
1
0
1
1
1
0
1
0
0
1
1
0
1
PLEASE READ CAREFULLY
Instructions: Please complete the assignment in APA format. Each question has they own
instructions. A total of four outside references. The total word count must be 1500 please.
For Example: Question:XYZ
Use the Student_Data.xls file which consists of 200 MBA students at Whatsamattu U. It
includes variables regarding their age, gender, major, GPA, Bachelors GPA, course load,
English speaking status, family, and weekly hours spent studying.
1. It is pretty common across most schools to find the grades at the MBA level divided between
A’s and B’s. As such, you expect the mean GPA to be around 3.50. Using the sample of 200
MBA students, conduct a one-sample hypothesis test to determine if the mean GPA is different
from 3.50. Use a .05 significance level. (520 word count please, with 2 outside references).
2. Assume you read in the Whatsamatta U website that the average age of their MBA students is
45. Is this really true or have they failed to update this correctly? You think it is far less because
there have been a lot more students going straight from their Bachelors to their Masters since the
economy is so bad. You took a sample of 200 students (in the data file). Conduct a one-sample
hypothesis test to determine if the mean age is less than 45. Use a .05 significance level. (520
word count please, with 2 outside references).
3. You have heard from idle chatter that most students don’t declare a major in their MBA
programs. You took a sample of 200 students (in the data file). Conduct a one-sample hypothesis
test to determine if the proportion without a major is greater than 50%. Use a .05 significance
level. (520 word count please, with 2 outside references).
…
Purchase answer to see full
attachment
