Question: Hey, could you please do the excel t test (two-sample asumming equal variances) for Test, at the 5% level of significance, whether the average GPA
Hey, could you please do the excel t test (two-sample asumming equal variances) for "Test, at the 5% level of significance, whether the average GPA is different for females compared to males." and please send me the table.
| (Male = 0) (Female = 1) | |
| GPA | Gender |
| 4.1 | 1 |
| 6.2 | 0 |
| 4.3 | 0 |
| 5.9 | 0 |
| 4.4 | 1 |
| 5.4 | 1 |
| 4.9 | 1 |
| 2.7 | 1 |
| 3.5 | 1 |
| 2.1 | 0 |
| 6.3 | 0 |
| 6.4 | 0 |
| 3.1 | 1 |
| 1.6 | 1 |
| 6.7 | 0 |
| 3.4 | 1 |
| 5.2 | 0 |
| 1.1 | 1 |
| 4.8 | 0 |
| 4.5 | 0 |
| 5.6 | 1 |
| 5.9 | 1 |
| 3.5 | 0 |
| 1.9 | 0 |
| 5.7 | 1 |
| 2.5 | 1 |
| 4.8 | 0 |
| 1.6 | 0 |
| 1.5 | 1 |
| 2.8 | 1 |
| 4.8 | 0 |
| 2.8 | 1 |
| 1.3 | 1 |
| 4.7 | 1 |
| 4.3 | 1 |
| 5.3 | 0 |
| 4.5 | 1 |
| 2.2 | 0 |
| 2.6 | 0 |
| 6.5 | 0 |
| 6.0 | 1 |
| 6.8 | 0 |
| 4.0 | 0 |
| 4.7 | 1 |
| 2.6 | 0 |
| 2.8 | 1 |
| 4.9 | 0 |
| 4.6 | 1 |
| 1.3 | 1 |
| 3.7 | 1 |
| 2.1 | 0 |
| 1.3 | 1 |
| 3.4 | 0 |
| 1.5 | 0 |
| 2.1 | 0 |
| 2.7 | 1 |
| 2.7 | 0 |
| 2.1 | 1 |
| 5.3 | 1 |
| 4.6 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
