Done < CENGAGE | MINDTAP 13.2 Practice AA ng.cengage.com Q Search this course |l. ? Treatment A B C 163 147 125 141 156 122 169 128 131 144 147 146 149 133 151 170 147 129 156 143 134 166.4 108.4 138.4 Sample mean Sample variance a. Compute the sum of squares between treatments (t the nearest whole number A-Z Office Done < AA ng.cengage.com CENGAGE | MINDTAP Q Search this course |l. ? 13.2 Practice Sample variance 166.4 108.4 138.4 a. Compute the sum of squares between treatments (t the nearest whole number). 1468 b. Compute the mean square between treatments (to decimal). 734 c. Compute the sum of squares due to error (to the nearest whole number). A-Z Office >1 Done < AA ng.cengage.com CENGAGE | MINDTAP Q Search this course |l. ? 13.2 Practice c. Compute the sum of squares due to error (to the nearest whole number). 2166 d. Compute the mean square due to error (to 1 decima 128.4 e. Set up the ANOVA table for this problem. Round all Sum of Squares to nearest whole numbers. Round all Mean Squares to one decimal place. Round F to two decimal places. Round your p-value to four decimal A-Z Office >1 Done < AA ng.cengage.com Q Search this course |l. ? CENGAGE | MINDTAP 13.2 Practice e. Set up the ANOVA table for this problem. Round all Sum of Squares to nearest whole numbers. Round all Mean Squares to one decimal place. Round F to two decimal places. Round your p-value to four decimal places. Source of Variation Sum of Squares Degrees of Freedom Mean Square A-Z F p-valu Treatments 1468 2 734 4.92 .0206 Office Error 2166 15 144 4 Excel File Edit View Insert Format Tools Data Window Help Home AutoSave OFF Insert Draw Page Layout 5 Formulas PS#2Data(FIN3582)-1 Data Review View Calibri (Body) 12 A A Paste BI U L10 fx Conditional Formatting General Format as Table $ % 9 00 Cell Styles 98% Sat 9:40 PM Tony Laaksonen Q A Update Later Microsoft AutoUpdate Update is ready to be installed. Restart App Delete Editing Ideas Format A B t Date 2 0 15-Mar C Sinopec (CNY) 483.8609 D Sinopec (PEN) 232.2222 E Beijing Mkt F Boisa de Valores G USD/CNY H J K L M N USD/PEN SDRs 144.96 16855.81 0.1506 0.3138 1.3955 3 1 22-Mar 482.1381 231.3894 146.8 15980.55 0.1502 0.3003 1.3353 4 2 29-Mar 477.2908 229.0631 145.91 15642.24 0.1519 0.2793 1.5869 5 3 6-Apr 476.5604 228.7126 143.93 15902.87 0.1575 0.2985 1.3578 6 4 13-Apr 486.0558 233.2696 142.5 16476.77 0.1524 0.3205 1.5363 7 5 20-Apr 493.8247 236.9981 139.73 16660.15 0.1558 0.3079 1.1238 8 6 27-Apr 478.8181 229.796 137.61 16110.41 0.1558 0.2626 1.3812 6 7 3-May 470.6507 225.8764 139.99 15961.09 0.1376 0.3299 1.2515 10 8 10-May 448.1408 215.0733 11 Chinese Co. price denominated 12 13 in yuan Holding Period Chinese Co. price denominated in sol 131.67 Chinese 15444.44 0.1468 0.3011 1.8312 Stock Market Index Peruian Stock Market Index CNY = China's yuan PEN = Peru's New Currency Index sol 0 14 Positions Established Positions 15-Mar 8 10-May 15 Liquidated 16 Descriptions Data MAR 3 7 + 100% 1 PAGES 3 Done < AA ng.cengage.com Q Search this course |l. ? CENGAGE | MINDTAP 13.2 Practice Total 3634 17 f. At the = 0.05 level of significance, test whether the means for the three treatments are equal. Calculate the value of the test statistic (to 2 decimals). 5.26 The p-value is between 0.01 and 0.025 What is your conclusion? Conclude that not all treatment means are equal A-Z Office >1