As an elementary school principal, you are concerned about students’ reading comprehension. You brought in a reading consultant to help design an experimental study to compare the current teaching method (the control group), a stand-alone computer-based training (CBT) program, and a combination of the traditional teaching method and CBT (hybrid). The consultant randomly assigned 72 third-grade students into three groups of 24 each. During the two-week study, students were taught reading comprehension skills based on the respective methodology. At the end of the two-week period, students completed a standardized reading comprehension test. The consultant prepared a worksheet listing the test scores for each group. No student names or IDs were reported to you. Now you want to calculate some general statistics and conduct a one-way analysis of variance (ANOVA). Doing so will enable you to compare the three sample group means and evaluate the variances within each group compared to the variances among the three groups.

a. Open e08m2Stats and save it as e08m2Stats_LastFirst.

b. Calculate the descriptive statistics in the range F2:H8. For the variance and standard devia-tion, use the functions that include the .S descriptor. Format the values with Comma Style with three decimal places.

c. Check the Data tab to see if it contains the Data Analysis command. If not, load the Analysis ToolPak add-in program as directed in the chapter

d. Use the Analysis ToolPak and select the Anova: Single Factor. Use the following specifications: • Select the range A1:C25 as the Input Range. • Select the Labels in first row check box. • Confirm the alpha value is 0.05. • Place the Output Range starting in cell E11.

e. Apply Comma Style with three decimal places to the averages and variances in the ANOVA table. Verify that the averages and variances in the ANOVA table match those you calculated in the General Stats section. If they do not match, correct the functions in the General Stats sec-tion. If needed, format the P-value (cell J22) with Comma Style and six decimal places.

f. Answer the questions on the Q&A worksheet.

g. Apply Landscape orientation to the Reading Performance Scores worksheet.

h. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.

i. Save and close the workbook. Based on your instructor’s directions, submit e08m2Stats_LastFirst.

As an elementary school principal, you are concerned about students’ reading comprehension. You brought in a reading consultant to help design an experimental study to compare the current teaching method (the control group), a stand-alone computer-based training (CBT) program, and a combination of the traditional teaching method and CBT (hybrid). The consultant randomly assigned 72 third-grade students into three groups of 24 each. During the two-week study, students were taught reading comprehension skills based on the respective methodology. At the end of the two-week period, students completed a standardized reading comprehension test. The consultant prepared a worksheet listing the test scores for each group. No student names or IDs were reported to you. Now you want to calculate some general statistics and conduct a one-way analysis of variance (ANOVA). Doing so will enable you to compare the three sample group means and evaluate the variances within each group compared to the variances among the three groups.

a. Open e08m2Stats and save it as e08m2Stats_LastFirst.

b. Calculate the descriptive statistics in the range F2:H8. For the variance and standard devia-tion, use the functions that include the .S descriptor. Format the values with Comma Style with three decimal places.

c. Check the Data tab to see if it contains the Data Analysis command. If not, load the Analysis ToolPak add-in program as directed in the chapter

d. Use the Analysis ToolPak and select the Anova: Single Factor. Use the following specifications: • Select the range A1:C25 as the Input Range. • Select the Labels in first row check box. • Confirm the alpha value is 0.05. • Place the Output Range starting in cell E11.

e. Apply Comma Style with three decimal places to the averages and variances in the ANOVA table. Verify that the averages and variances in the ANOVA table match those you calculated in the General Stats section. If they do not match, correct the functions in the General Stats sec-tion. If needed, format the P-value (cell J22) with Comma Style and six decimal places.

f. Answer the questions on the Q&A worksheet.

g. Apply Landscape orientation to the Reading Performance Scores worksheet.

h. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.

i. Save and close the workbook. Based on your instructor’s directions, submit e08m2Stats_LastFirst.

As an elementary school principal, you are concerned about students’ reading comprehension. You brought in a reading consultant to help design an experimental study to compare the current teaching method (the control group), a stand-alone computer-based training (CBT) program, and a combination of the traditional teaching method and CBT (hybrid). The consultant randomly assigned 72 third-grade students into three groups of 24 each. During the two-week study, students were taught reading comprehension skills based on the respective methodology. At the end of the two-week period, students completed a standardized reading comprehension test. The consultant prepared a worksheet listing the test scores for each group. No student names or IDs were reported to you. Now you want to calculate some general statistics and conduct a one-way analysis of variance (ANOVA). Doing so will enable you to compare the three sample group means and evaluate the variances within each group compared to the variances among the three groups.

a. Open e08m2Stats and save it as e08m2Stats_LastFirst.

b. Calculate the descriptive statistics in the range F2:H8. For the variance and standard devia-tion, use the functions that include the .S descriptor. Format the values with Comma Style with three decimal places.

c. Check the Data tab to see if it contains the Data Analysis command. If not, load the Analysis ToolPak add-in program as directed in the chapter

d. Use the Analysis ToolPak and select the Anova: Single Factor. Use the following specifications: • Select the range A1:C25 as the Input Range. • Select the Labels in first row check box. • Confirm the alpha value is 0.05. • Place the Output Range starting in cell E11.

e. Apply Comma Style with three decimal places to the averages and variances in the ANOVA table. Verify that the averages and variances in the ANOVA table match those you calculated in the General Stats section. If they do not match, correct the functions in the General Stats sec-tion. If needed, format the P-value (cell J22) with Comma Style and six decimal places.

f. Answer the questions on the Q&A worksheet.

g. Apply Landscape orientation to the Reading Performance Scores worksheet.

h. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.

i. Save and close the workbook. Based on your instructor’s directions, submit e08m2Stats_LastFirst.

a. Open e08m2Stats and save it as e08m2Stats_LastFirst.

a. Open e08m2Stats and save it as e08m2Stats_LastFirst.

f. Answer the questions on the Q&A worksheet.

f. Answer the questions on the Q&A worksheet.

g. Apply Landscape orientation to the Reading Performance Scores worksheet.

g. Apply Landscape orientation to the Reading Performance Scores worksheet.

i. Save and close the workbook. Based on your instructor’s directions, submit e08m2Stats_LastFirst.

i. Save and close the workbook. Based on your instructor’s directions, submit e08m2Stats_LastFirst.