Good attempt. The mean and standard deviation calculated on the right side are incorrect. You need to use the AVERAGE and STDEVS functions to get these. I encourage you to make corrections and resubmit for regrading.

12/19/21 UPDATE. What am I doing wrong?

Auto Save (O Off ) W/S4Practice.xls - Compatibility Mode - Excel Search (Alt+0) vernitta V X File Home Insert Drawy Page Layout Formulas Data Review View Help Share Comments Insert LO Arial v 10 AA ab Wrap Text Number AY O Delete * Paste BIU ~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table ~ Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity H11 X V A R C D E F G H Voltage. Test the claim that the mean voltage is 123.5 volts. Use 2 t Test for the Hypothesis of the Mean 01 level of significance. 123.8 How many readings are in this sample? Data 123.9 4 Null Hypothesis LL= 123.5 Enter the hypothesis test amount. (2 points) 123.9 5 Level of Significance 0.01 Enter alpha value. 2 points) 123.3 6 Sample Size Enter the sample size. (2 points) 123.4 What is the mean? (2 decimals) Sample Mean Enter the sample mean. (2 points) 123.3 5 points) 8 Sample Standard Deviation Enter the sample standard deviation. (2 points) 123.3 C 123.6 What is the standard deviation? (3 10 Intermediate Calculations 123.5 decimals) 11 Standard Error of the Mean #DIV/O! Access this helpful video: Video 123.5 5 points) 12 Degrees of Freedom -1 123.5 13 t Test Statistic #DIV/O! Correct answers are: 120.0 14 Number of readings = 20 120.0 15 Two-Tail Test Mean = 123.06 120.0 16 Lower Critical Value #NUM! Standard deviation = 1.354 123.9 17 Upper Critical Value #NUM! Alpha = 01 124.0 18 p-Value #DIV/O! Hypothesis test amount = 123.5 124.2 19 #DIV/O! p-value = . 1625 123.9 20 t test statistic = -1.4533 123.1 21 Calculations Area Do not reject the null hypothesis 123.0 22 For one-tailed tests: Hypothesis Testing + Ready + 100% W O G X 38'F Cloudy ENG 2:39 PM 12/20/2021