Solver ... Hypothesis Testing for Two or more Samples
helpneded20160524173549student_data_file.xls
Students
ID | Gender | Major | Age | MBA_GPA | BS GPA | Hrs_Studying | Works FT | |||
1 | 1 | No Major | 39 | 2.82 | 3.05 | 3 | 1 | Variable descriptions | ||
2 | 1 | No Major | 55 | 3.49 | 3.45 | 7 | 1 | Gender = 0 (female), 1 (male) | ||
3 | 1 | No Major | 43 | 3.28 | 3.5 | 7 | 0 | Major = student's major | ||
4 | 1 | No Major | 56 | 3.25 | 3.55 | 7 | 1 | Age = age of student in years | ||
5 | 1 | No Major | 38 | 3.26 | 3.3 | 6 | 0 | MBA_GPA = overall GPA in the MBA program | ||
6 | 1 | No Major | 54 | 2.87 | 3.05 | 4 | 1 | BS_GPA = overall GPA in the BS program | ||
7 | 1 | No Major | 30 | 3.16 | 3.35 | 6 | 1 | Hrs_Studying = average hours studied per week | ||
8 | 1 | No Major | 37 | 3.4 | 3.35 | 6 | 0 | Works FT = 0 (No), 1 (Yes) | ||
9 | 1 | No Major | 38 | 2.84 | 3.05 | 3 | 0 | |||
10 | 1 | No Major | 42 | 3.72 | 3.7 | 7 | 1 | |||
11 | 1 | No Major | 52 | 3.22 | 3.5 | 7 | 1 | |||
12 | 1 | No Major | 35 | 3.44 | 3.55 | 7 | 1 | |||
13 | 1 | No Major | 37 | 3.65 | 3.9 | 8 | 0 | |||
14 | 1 | No Major | 53 | 3.02 | 3.3 | 6 | 0 | |||
15 | 1 | No Major | 51 | 3.03 | 3.25 | 6 | 1 | |||
16 | 1 | No Major | 40 | 3.8 | 3.8 | 8 | 1 | |||
17 | 1 | No Major | 33 | 3.23 | 3.5 | 7 | 1 | |||
18 | 1 | No Major | 53 | 3.26 | 3.5 | 7 | 1 | |||
19 | 1 | No Major | 43 | 3.53 | 3.75 | 8 | 0 | |||
20 | 1 | No Major | 35 | 3.75 | 3.9 | 8 | 1 | |||
21 | 1 | No Major | 57 | 3.15 | 3.2 | 6 | 0 | |||
22 | 1 | No Major | 32 | 3.66 | 3.75 | 8 | 1 | |||
23 | 1 | No Major | 59 | 3.36 | 3.45 | 7 | 0 | |||
24 | 1 | No Major | 48 | 3.79 | 3.85 | 8 | 0 | |||
25 | 1 | No Major | 34 | 2.85 | 3.05 | 3 | 0 | |||
26 | 1 | No Major | 53 | 3.74 | 3.9 | 8 | 1 | |||
27 | 1 | No Major | 35 | 3.23 | 3.25 | 6 | 0 | |||
28 | 1 | No Major | 38 | 3.52 | 3.7 | 7 | 1 | |||
29 | 1 | No Major | 37 | 3.32 | 3.45 | 7 | 1 | |||
30 | 1 | No Major | 46 | 2.89 | 3.1 | 4 | 0 | |||
31 | 1 | No Major | 44 | 2.83 | 3.05 | 3 | 1 | |||
32 | 1 | No Major | 31 | 2.93 | 3.1 | 5 | 1 | |||
33 | 1 | No Major | 51 | 3.71 | 3.8 | 8 | 1 | |||
34 | 1 | No Major | 47 | 3.47 | 3.75 | 8 | 1 | |||
35 | 1 | No Major | 56 | 3.52 | 3.65 | 7 | 1 | |||
36 | 1 | Finance | 42 | 2.83 | 3.05 | 3 | 0 | |||
37 | 1 | Finance | 44 | 3.64 | 3.55 | 7 | 1 | |||
38 | 1 | Finance | 54 | 2.96 | 3.1 | 4 | 0 | |||
39 | 1 | Finance | 51 | 3.59 | 3.8 | 8 | 1 | |||
40 | 1 | Finance | 42 | 3.33 | 3.55 | 7 | 1 | |||
41 | 1 | Finance | 45 | 3.38 | 3.6 | 7 | 0 | |||
42 | 1 | Finance | 55 | 3.44 | 3.35 | 6 | 1 | |||
43 | 1 | Finance | 47 | 3.31 | 3.45 | 7 | 0 | |||
44 | 1 | Finance | 43 | 3.03 | 3.25 | 6 | 0 | |||
45 | 1 | Finance | 57 | 3.26 | 3.4 | 7 | 1 | |||
46 | 1 | Finance | 36 | 3.04 | 3.25 | 6 | 0 | |||
47 | 1 | Finance | 58 | 2.98 | 3.1 | 5 | 0 | |||
48 | 1 | Finance | 46 | 2.8 | 3.05 | 2 | 0 | |||
49 | 1 | Finance | 53 | 3.75 | 3.75 | 8 | 1 | |||
50 | 1 | Finance | 59 | 3.64 | 3.65 | 7 | 1 | |||
51 | 1 | Finance | 49 | 3.65 | 3.8 | 8 | 1 | |||
52 | 1 | Finance | 34 | 3.18 | 3.3 | 6 | 0 | |||
53 | 1 | Finance | 46 | 3.44 | 3.4 | 7 | 1 | |||
54 | 1 | Finance | 46 | 3.06 | 3.15 | 6 | 1 | |||
55 | 1 | Finance | 33 | 3.51 | 3.75 | 8 | 0 | |||
56 | 1 | Finance | 56 | 3.33 | 3.4 | 7 | 1 | |||
57 | 1 | Finance | 39 | 2.81 | 3.05 | 2 | 0 | |||
58 | 1 | Finance | 51 | 3.64 | 3.8 | 8 | 1 | |||
59 | 1 | Finance | 55 | 3.05 | 3.4 | 7 | 0 | |||
60 | 1 | Finance | 38 | 2.85 | 3.05 | 3 | 1 | |||
61 | 1 | Marketing | 33 | 3.56 | 3.6 | 7 | 1 | |||
62 | 1 | Marketing | 34 | 2.92 | 3.1 | 5 | 0 | |||
63 | 1 | Marketing | 31 | 3.35 | 3.5 | 7 | 1 | |||
64 | 1 | Marketing | 37 | 3.46 | 3.35 | 6 | 1 | |||
65 | 1 | Marketing | 46 | 3.59 | 3.75 | 8 | 1 | |||
66 | 1 | Marketing | 31 | 3.11 | 3.2 | 6 | 0 | |||
67 | 1 | Marketing | 47 | 3.65 | 3.7 | 8 | 1 | |||
68 | 1 | Marketing | 54 | 3.17 | 3.5 | 7 | 0 | |||
69 | 1 | Marketing | 52 | 2.97 | 3.1 | 5 | 1 | |||
70 | 1 | Marketing | 43 | 3.77 | 3.9 | 8 | 1 | |||
71 | 1 | Leadership | 44 | 3.21 | 3.2 | 6 | 1 | |||
72 | 1 | Leadership | 34 | 3.17 | 3.15 | 6 | 0 | |||
73 | 1 | Leadership | 59 | 3.65 | 3.65 | 7 | 0 | |||
74 | 1 | Leadership | 45 | 2.94 | 3.1 | 5 | 0 | |||
75 | 1 | Leadership | 30 | 3.53 | 3.7 | 8 | 1 | |||
76 | 1 | Leadership | 32 | 3.65 | 3.6 | 7 | 1 | |||
77 | 1 | Leadership | 32 | 3.61 | 3.7 | 8 | 1 | |||
78 | 1 | Leadership | 40 | 3.7 | 3.9 | 8 | 1 | |||
79 | 1 | Leadership | 48 | 2.91 | 3.1 | 5 | 1 | |||
80 | 1 | Leadership | 51 | 3.09 | 3.25 | 6 | 0 | |||
81 | 1 | Leadership | 30 | 3.77 | 3.95 | 9 | 1 | |||
82 | 1 | Leadership | 31 | 3.79 | 3.8 | 8 | 1 | |||
83 | 1 | Leadership | 35 | 3.59 | 3.6 | 7 | 1 | |||
84 | 1 | Leadership | 33 | 3.38 | 3.5 | 7 | 1 | |||
85 | 1 | Leadership | 35 | 3.57 | 3.5 | 7 | 1 | |||
86 | 1 | Leadership | 31 | 2.97 | 3.1 | 5 | 0 | |||
87 | 1 | Leadership | 38 | 3.44 | 3.65 | 7 | 1 | |||
88 | 1 | Leadership | 46 | 3.64 | 3.55 | 7 | 1 | |||
89 | 1 | Leadership | 45 | 3.48 | 3.4 | 7 | 1 | |||
90 | 1 | Leadership | 59 | 2.99 | 3.1 | 5 | 1 | |||
91 | 1 | Leadership | 58 | 3.73 | 3.8 | 8 | 0 | |||
92 | 1 | Leadership | 46 | 2.91 | 3.05 | 4 | 0 | |||
93 | 1 | Leadership | 35 | 3.78 | 3.95 | 9 | 1 | |||
94 | 1 | Leadership | 53 | 3.4 | 3.4 | 7 | 0 | |||
95 | 1 | Leadership | 31 | 3.13 | 3.15 | 6 | 0 | |||
96 | 1 | Leadership | 50 | 3.14 | 3.25 | 6 | 1 | |||
97 | 1 | Leadership | 38 | 3.24 | 3.3 | 6 | 0 | |||
98 | 1 | Leadership | 50 | 3.56 | 3.5 | 7 | 1 | |||
99 | 1 | Leadership | 48 | 3.16 | 3.25 | 6 | 0 | |||
100 | 1 | Leadership | 53 | 3.53 | 3.55 | 7 | 1 | |||
101 | 0 | No Major | 53 | 3.01 | 3.15 | 6 | 0 | |||
102 | 0 | Leadership | 30 | 3.3 | 3.35 | 6 | 1 | |||
103 | 0 | No Major | 32 | 3.62 | 3.6 | 7 | 0 | |||
104 | 0 | Leadership | 42 | 3.21 | 3.4 | 7 | 0 | |||
105 | 0 | Leadership | 56 | 3.39 | 3.4 | 7 | 1 | |||
106 | 0 | No Major | 46 | 3.65 | 3.8 | 8 | 1 | |||
107 | 0 | Leadership | 49 | 3.47 | 3.7 | 8 | 1 | |||
108 | 0 | No Major | 32 | 3.44 | 3.6 | 7 | 0 | |||
109 | 0 | No Major | 36 | 3.88 | 3.95 | 9 | 1 | |||
110 | 0 | Leadership | 42 | 3.83 | 3.95 | 9 | 1 | |||
111 | 0 | No Major | 37 | 3.53 | 3.6 | 7 | 1 | |||
112 | 0 | No Major | 31 | 3.22 | 3.3 | 6 | 0 | |||
113 | 0 | No Major | 31 | 3.56 | 3.8 | 8 | 1 | |||
114 | 0 | No Major | 42 | 3.2 | 3.25 | 6 | 1 | |||
115 | 0 | No Major | 39 | 3.17 | 3.3 | 6 | 1 | |||
116 | 0 | No Major | 47 | 3.41 | 3.6 | 7 | 1 | |||
117 | 0 | No Major | 28 | 3.56 | 3.7 | 8 | 1 | |||
118 | 0 | No Major | 28 | 3.34 | 3.6 | 7 | 0 | |||
119 | 0 | No Major | 52 | 3.44 | 3.6 | 7 | 1 | |||
120 | 0 | No Major | 35 | 3.76 | 3.8 | 8 | 1 | |||
121 | 0 | Finance | 38 | 3.55 | 3.45 | 7 | 1 | |||
122 | 0 | Finance | 44 | 3.88 | 3.9 | 8 | 1 | |||
123 | 0 | Finance | 38 | 3.31 | 3.45 | 7 | 1 | |||
124 | 0 | Finance | 52 | 3.09 | 3.15 | 6 | 1 | |||
125 | 0 | Finance | 53 | 3.82 | 4 | 9 | 0 | |||
126 | 0 | Finance | 53 | 3.01 | 3.2 | 6 | 1 | |||
127 | 0 | Finance | 31 | 3.66 | 3.85 | 8 | 1 | |||
128 | 0 | Finance | 47 | 3.64 | 3.7 | 8 | 1 | |||
129 | 0 | Finance | 51 | 3.59 | 3.65 | 7 | 1 | |||
130 | 0 | Finance | 37 | 3.49 | 3.55 | 7 | 1 | |||
131 | 0 | Finance | 46 | 3.13 | 3.2 | 6 | 1 | |||
132 | 0 | Finance | 48 | 3.83 | 3.9 | 8 | 1 | |||
133 | 0 | Finance | 54 | 3.04 | 3.15 | 6 | 1 | |||
134 | 0 | Finance | 48 | 3.91 | 4 | 10 | 1 | |||
135 | 0 | Finance | 36 | 3.56 | 3.7 | 8 | 1 | |||
136 | 0 | Finance | 39 | 3.96 | 4 | 9 | 1 | |||
137 | 0 | Finance | 28 | 3.46 | 3.4 | 7 | 1 | |||
138 | 0 | Finance | 45 | 3.22 | 3.15 | 6 | 0 | |||
139 | 0 | Finance | 31 | 3.27 | 3.2 | 6 | 0 | |||
140 | 0 | Finance | 47 | 3.43 | 3.45 | 7 | 1 | |||
141 | 0 | Finance | 35 | 3.85 | 3.95 | 9 | 1 | |||
142 | 0 | Finance | 52 | 3.89 | 3.9 | 8 | 1 | |||
143 | 0 | Finance | 52 | 3.37 | 3.45 | 7 | 1 | |||
144 | 0 | Finance | 55 | 3.32 | 3.3 | 6 | 0 | |||
145 | 0 | Finance | 52 | 3.54 | 3.55 | 7 | 1 | |||
146 | 0 | Finance | 46 | 3.8 | 3.9 | 8 | 1 | |||
147 | 0 | Finance | 31 | 3.74 | 3.85 | 8 | 1 | |||
148 | 0 | Finance | 33 | 3.17 | 3.45 | 7 | 1 | |||
149 | 0 | Finance | 45 | 3.27 | 3.55 | 7 | 1 | |||
150 | 0 | Finance | 50 | 3.32 | 3.3 | 6 | 1 | |||
151 | 0 | Marketing | 33 | 3.56 | 3.45 | 7 | 1 | |||
152 | 0 | Marketing | 37 | 3.95 | 4 | 9 | 1 | |||
153 | 0 | Marketing | 33 | 3.56 | 3.75 | 8 | 0 | |||
154 | 0 | Marketing | 46 | 3.79 | 3.75 | 8 | 1 | |||
155 | 0 | Marketing | 55 | 3.93 | 4 | 9 | 1 | |||
156 | 0 | Marketing | 30 | 3.79 | 3.85 | 8 | 1 | |||
157 | 0 | Marketing | 51 | 3.71 | 3.85 | 8 | 1 | |||
158 | 0 | Marketing | 35 | 3.05 | 3.35 | 6 | 1 | |||
159 | 0 | Marketing | 40 | 3.22 | 3.2 | 6 | 1 | |||
160 | 0 | Marketing | 29 | 3.85 | 3.95 | 9 | 1 | |||
161 | 0 | Marketing | 52 | 3.82 | 3.95 | 9 | 1 | |||
162 | 0 | Marketing | 27 | 3.23 | 3.95 | 9 | 1 | |||
163 | 0 | Marketing | 51 | 3.56 | 3.65 | 7 | 1 | |||
164 | 0 | Marketing | 56 | 3.53 | 3.65 | 7 | 1 | |||
165 | 0 | Marketing | 35 | 3.62 | 4 | 9 | 1 | |||
166 | 0 | Leadership | 46 | 3.8 | 3.95 | 9 | 1 | |||
167 | 0 | Leadership | 39 | 3.47 | 3.35 | 6 | 0 | |||
168 | 0 | Leadership | 31 | 3.64 | 3.65 | 7 | 1 | |||
169 | 0 | Leadership | 52 | 3.03 | 3.15 | 5 | 1 | |||
170 | 0 | Leadership | 32 | 3.17 | 3.25 | 6 | 1 | |||
171 | 0 | Leadership | 32 | 3.22 | 3.2 | 6 | 1 | |||
172 | 0 | Leadership | 44 | 3.92 | 4 | 10 | 1 | |||
173 | 0 | Leadership | 43 | 3.82 | 3.95 | 9 | 1 | |||
174 | 0 | Leadership | 38 | 3.26 | 3.55 | 7 | 1 | |||
175 | 0 | Leadership | 54 | 3.8 | 3.85 | 8 | 1 | |||
176 | 0 | Leadership | 27 | 3.2 | 3.2 | 6 | 0 | |||
177 | 0 | Leadership | 38 | 3.46 | 3.35 | 6 | 1 | |||
178 | 0 | Leadership | 45 | 3.67 | 3.75 | 8 | 1 | |||
179 | 0 | Leadership | 48 | 3.06 | 3.4 | 7 | 0 | |||
180 | 0 | Leadership | 43 | 3.66 | 3.85 | 8 | 0 | |||
181 | 0 | Leadership | 34 | 3.96 | 4 | 10 | 1 | |||
182 | 0 | Leadership | 54 | 3.75 | 3.85 | 8 | 1 | |||
183 | 0 | Leadership | 36 | 3.83 | 3.85 | 8 | 1 | |||
184 | 0 | Leadership | 45 | 3.22 | 3.2 | 6 | 1 | |||
185 | 0 | Leadership | 28 | 3.36 | 3.35 | 6 | 1 | |||
186 | 0 | Leadership | 37 | 3.21 | 3.25 | 6 | 1 | |||
187 | 0 | Leadership | 27 | 3.02 | 3.15 | 5 | 1 | |||
188 | 0 | Leadership | 31 | 3.99 | 4 | 10 | 1 | |||
189 | 0 | Leadership | 45 | 3.07 | 3.15 | 6 | 1 | |||
190 | 0 | Leadership | 48 | 3.65 | 3.65 | 7 | 1 | |||
191 | 0 | Leadership | 50 | 3.67 | 3.85 | 8 | 1 | |||
192 | 0 | Leadership | 32 | 3.06 | 3.35 | 6 | 0 | |||
193 | 0 | Leadership | 33 | 3.98 | 3.7 | 8 | 1 | |||
194 | 0 | Leadership | 49 | 3.93 | 4 | 10 | 1 | |||
195 | 0 | Leadership | 27 | 3.41 | 3.3 | 6 | 0 | |||
196 | 0 | Leadership | 28 | 3.43 | 3.5 | 7 | 1 | |||
197 | 0 | Leadership | 36 | 3.7 | 3.65 | 7 | 0 | |||
198 | 0 | Leadership | 35 | 3.76 | 3.75 | 8 | 1 | |||
199 | 0 | Leadership | 47 | 3.9 | 3.9 | 8 | 0 | |||
200 | 0 | Leadership | 33 | 3.23 | 3.3 | 6 | 1 |