Imagine you work in the HR department of a large company. Your supervisor is interested in the mean annual performance review scores for all the employees in the sales department. The performance review scores range from 1 to 5, with 5 being exceptional and 1 being unacceptable. They have been asked by the CEO to examine the performance review scores to determine if the mean is above 3.5, because limited funds are available for raises. Your supervisor wants to determine if this is correct and has asked you to investigate.

You randomly sample 30 annual performance reviews and record the scores.

Use the results from the hypothesis test in the Excel worksheet provided to fill in the table below. Clearly state the logic of your test, the calculations, and the conclusion of your test. \"1 a. Null Hypothesis (H0) b. Alternative Hypothesis (H 1) c. What type of Test Statistic did you use and why? d. Value of Test Statistic e. P-value f. Critical Value u p 9. Conclusion: Is the claim supported? Why or why not? h. Since (enter \"P-Value\") (Select: \"=\" \"") (enter \"significant value") we (select \"fail\" or \"fail to reject") the null (answer \"a\"). Sample Performance Number Review Score Minimum 2.71 3.86 Maximum 4.25 3.22 Q1 3.435 W N 3.87 Q2 3.59 4.25 Q3 3.84 3.48 VOUA 3.62 3.78 3.21 9 3.28 10 3.88 11 2.71 12 3.7 13 3.51 14 3.54 Student should Use t-test 15 3.29 Mean 3.58 16 3.45 Median 3.5900 17 3.18 Standard Deviation 0.310135 18 3.48 n= 30 19 3.95 df = 29 20 3.93 Confidence Level= 0.95 21 3.59 t= 2.045 22 3.92 E = 0.115806 23 3.94 Confidence Interval Lower Limit 3.46653 24 3.59 Confidence Interval Upper Limit 3.6981 25 3.48 Null Hypothesis H=20 26 3.33 Alternative Hypothesis H