• Round final answers to 2 decimal places,unless otherwise specified.
• Exponents can be displayed with the use of the "^" symbol (shift 6)...(Ex: "4 to the exponent 2" = 4^2)
• Expressalternate hypotheses withthe following symbols "/=" for two-tailed, ">=" for left-tailed, and "<=" for right-tailed
• Belowis an Excel data set linkfor questions 5, 6, 7 and 8...no work is submitted in Excel...

*** TO BE DONE WITH THE USE OF EXCEL***

***FOR MATCHED PAIR DO: BEFORE - AFTER***

***FOR INDEPENDENT SAMPLES DO:BEFORE AS SAMPLE 1 AND AFTER AS SAMPLE 2***

A large college would like to determine whether their college educator development training has had an effect on students' opinions on their professor's teaching.A sample of student feedback scores before and after the training is provided below (also available for download here Feedback.xlsx).At a 1% level of significance, can you conclude that there has been an improvement since the training?YOU CAN ASSUME THE POPULATION TO BE NORMALLY DISTRIBUTED.

Average Professor Feedback Score (5 points max)

Random Sample Before Training (Points) Random Sample After Training (Points)

3.64 3.85

4.16 4.25

3.38 3.42

3.49 3.83

4.2 4.31

3.82 3.93

3.39 3.4

4.2 4.28

3.89 3.99

3.49 3.82

4.03 4.43

3.92 4.22

4.28 4.29

4.35 4.85

4.45 4.83

3.38 3.81

3.27 3.59

4.07 4.24

4.4 4.68

4.46 4.84

4.12 4.59

4.41 4.59

4 4.45

4.22 4.72

3.4 3.66

3.27 3.54

4.22 4.56

4.33 4.68

4.38 4.63

3.42 3.36

3.32 3.54

a) Properly state the mathematical hypotheses:

b) p-value:

c) Conclusion:(YOU MUST EXPLAIN YOUR ANSWER MATHEMATICALLY)

Answer

a)

b)

PLEASE SHOW YOUR WORK BY COMPLETING THIS TABLE

FUNCTION:

FIELD 1:

FIELD 2:

FIELD 3:

FIELD 4:

ANY ADDITIONAL CALCULATIONS CAN BE SHOWN HERE

FINAL ANSWER: ANSWER TO 4 DECIMALS

c)