I am seeking assistance on question #4 & 4.a.

4.

4. Use the results from the hypothesis test in the Excel worksheet provided to ll in the table below. Clearly state the logic of your test, the calculations, and the conclusion of your test. Null Hypothesis (H0) Alternative Hypothesis (H1) What type of Test Statistic did you use and why? Value of Test Statistic 289.948 P-value Critical Value Conclusion: Is the claim supported? Why or why not? 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