1. T-test: 2 Independent Samples Assuming Unequal Variances

From the Class Survey Data File, using the data from the Female, Male Data sheet —

1. If your section has < 100 students: Test Major Fits Me for females versus males

— OR —

1. 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

20201020050730c_10_2_samples_directions