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