8 In the range F8: H8, insert functions that will calculate
12 the standard deviation for each of the groups. Use the function that includes the. S descriptor.
9 Format the values in the range F2: H8 with the Comma 3
Style with three decimal places.
10 Use the Data Analysis tools to perform an analysis of
10 variance using the range A2: C25 as the input range and E11 as the output range.
11 Format the averages and variances in the ANOVA table 3 with the Comma Style with three decimal places.
12 Save the workbook. Close the workbook and exit Excel. 0
Submit the workbook as directed.
Total Points 100