5. W To study the effect of temperature on yield in a chemical process, five batches were produced at each of three temperature levels. The results follow. Co A-Z Temperature 50C 60C 70C 37 31 27 27 32 32 39 35 32 42 24 34 35 28 35 Construct an analysis of variance table (to 2 decimals but p-value to 4 decimals, if necessary). Source of Variation Sum of Squares Degrees of Freedom Mean Square F p-value Treatments 79.733 2 39.866 21.584 0.0002 Error Total 48.4 128.13 12 4.0333 14 Use a 0.05 level of significance to test whether the temperature level has an effect on the mean yield of the process. Calculate the value of the test statistic (to 2 decimals). 27.57 L 0 D A+ 11:30 AM 4/3/2023 19 + hapter 13 Assignment Error Total 48.4 12 4.0333 128.13 14 Use a 0.05 level of significance to test whether the temperature level has an effect on the mean yield of the process. Calculate the value of the test statistic (to 2 decimals). 27.57 The p-value is less than 0.01 What is your conclusion? Do not reject the assumption that the mean yields for the three temperatures are equal v Hide Feedback Partially Correct 0-Icon Key Hint(s) Check My Work (4 remaining) Exercise 13.09 Algo (Analysis of Variance and the Completely Randomized Design) Question 3 of 6 Save Submit Assignment for Grading 11:31 AM A-Z ort L Lenovo McAfee CENGAGE MINDTAP 13.2 Excel Activity 2 - ANOVA and Fisher's LSD Procedure (Structured) Question 1 6/12 Submit Other favorites Q Search this course 0 X The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The data showing the average attendance for the 14 teams in the International League are contained in the Excel Online file below. Also shown are the teams' records; W denotes the number of games won, L denotes the number of games lost, and PCT is the proportion of games played that were won. Construct a spreadsheet to answer the following questions. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak A-Z X Open spreadsheet a. Use a = .05 to test for any difference in the mean attendance for the three divisions. Calculate the value of the F-statistic (to 2 decimals). 7.06 The p-value is 0.0111 What is your conclusion? V (to 4 decimals). evidence to conclude that the mean attendance values are not the same across the three divisions There is sufficient of the International League of Triple-A minor league baseball. Back Autosaved at 10:00 AM Search LOLCO 4 ha about:blank Import favorites L Lenovo Support L Lenovo McAfee Excel template Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Revie Arial Paste 10 A A ab Wrap Text BIU Dab Merge & Center Undu Clipboard H1 Font Alignment Part a. Rearrange the Attendance values for the Anova: Sing A B Team Name Division 2 Buffalo Bisons North 3 Lehigh Valley IronPigs North Pawtucket Red Sox North 85 Rochester Red Wings North LAGAMO D E F G W L PCT Attendance Part a. Re 66 77 0.462 8785 55 89 0.382 8505 58 0.594 9092 76 70 0.521 6915 Scranton-Wilkes Barre Yankees North 88 56 0.611 7173 7 Syracuse Chiefs North 69 75 0.479 5770 8 Charlotte Knights South 64 78 0.451 4550 Durham Bulls South 74 70 0.514 6983 10 Norfolk Tides South 64 78 0.451 6281 11 Richmond Braves South 63 85 0.426 4445 12 Columbus Clippers West 69 73 0.486 7816 13 Indianapolis Indians West 68 76 0.472 8531 14 15 45 Louisville Bats West 83 56 0.597 9178 Toledo Mud Hens West 75 69 0.521 8238 16 17 18 Data + Waiting for excel-telemetry.officeapps.live.com... 45 F Tab Esc FnLock i 1 A+ F1 F2 F3 F4 F5 72 @ %5 $ s4 #3 W E Your Anova ana O Search L 0+ F6 F7 & 6 T R T Y el Activity 2-ANOVA and Fisher's LSD Procedure (Structured) 7.06 The p-value is 0.0111 (to 4 decimals). What is your conclusion? There is sufficient Search this course evidence to conclude that the mean attendance values are not the same across the three divisions of the International League of Triple-A minor league baseball. b. Use Fisher's LSD procedure to test whether there is a significant difference between the means for North (1), South (2), and West (3). Use a = .05. Absolute Value LSD Difference 12 (to 2 decimals) (to 2 decimals) 2150.42 72-73 Check My Work Reset Problem Back Conclusion Significant difference No significant difference Significant difference Autosaved at 10:00 AM Search LOLCOL A-Z