B D E F G H M Q R S V W X Y Z Problem Analysis Preparation Business Engineering Arts and Sciences Place your Excel Data Analysis results here W N 3-hour review 500 540 480 Hypothesis 3-hour review 580 460 400 Null Hypothesis 1-day program 460 420 Anova: Two-Factor With Replication ? X Ho: 560 Alternative Hypothesis Ha: 1-day program 540 620 480 10-week course 560 600 480 Input OK Test Parameters 10-week course 600 580 410 Input Range: T Null Hypothesis Value o Level of Significance 0.05 Cancel 11 Rows per sample: Degrees of Freedom 12 Help Test Results Sample Column Interaction Alpha: 0.05 14 Type of Test 15 Test Statistic 16 Critical Value Output options 18 The Piedmont University graduate admissions office is conducting a study of recent graduate p-Value O Output Range: program candidate GMAT scores to advise prospective students about the choices for available 19 a Value exam preparation alternatives. Available preparation programs are offered in three formats: 3- 20 New Worksheet Ply: hour review, 1-day intensive review, and a 10-week course. The data represents three groups of 21 Decision applicants based on their undergraduate degrees: business, engineering, and arts and sciences. 22 O New Workbook Sample Use the Excel Data Analysis functions to conduct an ANOVA two-factor with replication test to 23 Column determine whether there are any differences among formats, undergraduate degree, or any 24 Interction interaction between the format and undergraduate degree. 25 26 Interpretation: What does this mean to the graduate admissions staff? 27 28 29 30