Using excel with data 1. T-test: 2 Independent Samples Assuming Unequal Variances
1. T-test: 2 Independent Samples Assuming Unequal Variances
From the Class Survey Data File, using the data from the Female, Male Data sheet —
-
If your section has < 100 students: Test Major Fits Me for females versus males
— OR —
-
If your section > 100 students: Test Goals W/in Reach for females versus males
1) Click on the DATA TAB and then select DATA ANAYLSIS
2) Select t-test: 2 Samples Assuming Unequal Variances
3) Inputs:
-
Variable 1 Range: 1st Column of Data, including heading
● Variable 2 Range: 2d Column of Data, including heading
-
Hypothesized Mean Difference: 0
● click on Labels
-
Alpha : see “*” below
-
Output Range: click on New Worksheet ply
*Alpha: If your class size is < 100 → Alpha = .05, and if your class size is > 100 → Alpha = .01
2. T-Test: 2 Dependent Samples (Paired)Test
All Sections: From the Class Survey Data File, Copy & Paste the Last Semester Rating and This Semester Rating data** (Columns Q & U) to a new sheet –
1) Click on the DATA TAB and then select DATA ANAYLSIS
2) Select: t-Test: Paired Two Sample for Means
3) Inputs: Same as for above Test
**Semester Rating statements from the survey: Scale: 1 = Strongly Disagree, 7 Strongly Agree
Column Q: I did well in school last semester.
Column U: I expect to do well in school this semester.
DETAILED ASSIGNMENT