A- Calculate the grand mean, SSTR and MSTR using data in excel sheet

B.Calculate SSE and MSE

C. Specify the competing hypothesis

D. Calculate the F test statistic and p-value

E. At the 1% significance level, what is the conclusion?

E.Interpret results at a=0.01

Ch13_Q01_V14_Data_File Q . Search Sheet Home Insert Page Layout Formulas Data Review View Cut Calibri (Body) 11 . A- A Wrap Text General AutoSum Copy Fill Paste E Merge & Center $ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter E13 X V fx A B C D E F G H I J K L M N O P Q R S Treatments A B C 22 24 26 30 30 23 UT 29 16 18 21 20 22 26 25 16 10 11 12 13 16 17 18 19 20 24 28 29 30 31 32 33 Sheet1 Sheet2 Sheet3 + 136% Ready +Students Home x Topic: Week 6 Discussion Boar X Connect X Course Hero New Tab X + C D A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activit.. * K Error ii: Apps ye Swimsuit Sale: Sw.. @ > How To Hold Th... b New In | The hotte. Chiffon Ruched St... Clothing - Dresse... LookBookStore -.. Women's Maxi Dr.. f Clothing New Arri.. Week 7 Homework - Chapter 13 @ Saved Help Save & Exit Submit Check my work A random sample of five observations from three normally distributed populations produced the following data: (You may find it useful to reference the F table.) Treatments 20 A B C points 22 24 26 30 30 23 29 16 18 21 20 22 eBook 26 25 16 Print 4 = 25.6 XB = 23.0 XC = 21.0 SA = 16.3 SB = 28.0 SC = 16.0 References Click here for the Excel Data File a. Calculate the grand mean. (Round intermediate calculations to at least 4 decimal places and final answer to 4 decimal places.) Grand mean b. Calculate SSTR and MSTR. (Round intermediate calculations to at least 4 decimal places and final answers to 4 decimal places.) SSTR MSTR Mc Graw Students Home x Topic: Week 6 Discussion Boar X Connect X Course Hero New Tab X + C D A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activit... * K Error ii: Apps ye Swimsuit Sale: Sw.. @ > How To Hold Th... b New In | The hotte.. Chiffon Ruched St... Clothing - Dresse.. LookBookStore -.. Women's Maxi Dr.. f Clothing New Arri... Week 7 Homework - Chapter 13 @ Saved Help Save & Exit Submit Check my work c. Calculate SSE and MSE. (Round intermediate calculations to at least 4 decimal places and final answers to 4 decimal places.) 20 SSE points MSE eBook Print References d. Specify the competing hypotheses in order to determine whether some differences exist between the population means. OHO: MA = MB = Mci HA: Not all population means are equal. OH0: MA EMB = Mci HA: Not all population means are equal. OHO: MA 2 MB 2 Mci HA: Not all population means are equal. e-1. Calculate the value of the F( df1, of2) test statistic. (Round intermediate calculations to at least 4 decimal places and final answer to 3 decimal places.) Test statistic e-2. Find the p-value. Mc Graw Students Home x Topic: Week 6 Discussion Boar X Connect X Course Hero New Tab X + > C D A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activit... * K Error ii: Apps ye Swimsuit Sale: Sw.. @ >> How To Hold Th... b New In | The hotte.. Chiffon Ruched St... Clothing - Dresse... LookBookStore -.. Women's Maxi Dr. f Clothing New Arri.. Week 7 Homework - Chapter 13 Saved Help Save & Exit Submit Check my work e-2. Find the p-value. Op-value 2 0.10 20 O 0.05 s p-value