Question

PLEASE SHOW IN EXCEL

You need to decide if two teachers teach the same or differently. You have randomly assigned students to the different teachers. Then, the students take a standard exam at the end of the class. The scores for the teachers are:

Teacher 1	Teacher 2
35	52
51	87
66	76
42	62
37	81
46	71
60	55
55	67
53

Did one teacher do better or worse than another teacher?

State your hypothesis and your null hypothesis:

Decide which t-test you will use (Dependent, Independent – equal variance, Independent – unequal variance):

Test your null hypothesis at the .05 level (decide if this is one-tailed or two-tailed). Which tailed test did you use and what is your observed t value?

What is the critical value for this test?

Do you accept or reject your null hypothesis?

State your conclusion:

Answer 1

Claim: Two teachers teach the same or different.

The null and alternative hypothesis is:

H0 : μι = μ2

G + : H

The t-test we have to use Independent – equal variance.

By using excel we have to test the hypothesis.

Enter data into excel.

Click on Data ---------> Data Analysis ----------> t-Test: Two-Sample Assuming Equal Variances --------->

Variable 1 Range: Select teacher 1 data

Variable 2 Range: Select teacher 2 data

Hypothesized Mean Difference: 0

Output Range: Select any empty cell.

Ok

We get

- x New Microsoft Office Excel Worksheet - Microsoft Excel View Team Wrap Text General - E D EF Merge & Center - $ % , 8:09 Conditional Format Formatting as Table Alignment Number Styles HEEG2 21 21 3 = Home Insert Page Layout Formulas Data Review Cut Calibri - 11 - A À = = = Format Painter BI U B A E E Clipboard Font J43 A B AutoSum" AT 3 Insert Delete Format La Copy Paste Cell Styles 2 Clear Sort & Filter Editing Find & Select Cells F G Н к M N | р QR о Teacher 1 Teacher 2 t-Test: Two-Sample Assuming Equal Variances Teacher 1 Teacher 2 Mean 49.44444 68.875 Variance 107.7778 151.2679 Observations Pooled Variance 128.0731 Hypothesized Mean Differenc 15 t Stat -3.5334 P(T<=t) one-tail 0.0015 t Critical one-tail 1.7531 P(T<=t) two-tail 0.0030 t Critical two-tail 2.1314 df Activate Windows Go to PC settings to activate Windows. Sheet1 Sheet2 Sheet30 Ke Ready BOU 100% 0 + 2:43 AM 11/11/2019 QDOlga W

Test statistic = t = - 3.53

Critical value = 2.131

Test statistic | t | > Critical value we reject null hypothesis.

Conclusion:

Two teachers teach differently.