Random sampling from four normally distributed populations produced the following data: (You may find it useful to reference the Etable.)A-7-13-16TreatmentsB-8-9-15-4Grand meanSSTRMSTRC-8-11-5-9-4Click here for the Excel Data Filea. Calculate the grand mean. (Negative value should be indicated by a minus sign. Round your answer to 2 decimal places.)D-9-16-17b. Calculate SSTR and MSTR. (Round Intermediate calculations to at least 4 decimal places and final answers to 4 decimal places.) c. Calculate SSE and MSE. (Round Intermediate calculations to at least 4 decimal places and final answers to 4 decimal places.)SSEMSEd. Specify the competing hypotheses in order to determine whether some differences exist between the population means.Hg: HA= B = HCHg: HAS HB SHCHo: MAZ HB 2 HCe-1. Calculate the value of the F(df1, df2) test statistic. (Round Intermediate calculations to at least 4 decimal places and finalanswer to 3 decimal places.)Test statisticHA: Not all population means are equal.HA: Not all population means are equal.HA: Not all population means are equal.e-2. Find the p-value.p-value 20.10O 0.05 p-value < 0.100.025 s p-value < 0.05p-value < 0.01O 0.01 s p-value < 0.025f. At the 5% significance level, what is the conclusion to the test?Do not reject He since the p-value is not less than significance levelRelect H₂ since the p-value is less than significance level

Given data: A B C D -7 -8 -8 -9 -13 -9 -11 -16 -16 -15 -5 -17 -4 -9 -4

Random sampling from four normally distributed populations produced the following data: (You may find it useful to reference the E table.) A -7 -13 -16 Treatments B -8 -9 -15 -4 SSTR MSTR Grand mean C -11 -5 D -9 Click here for the Excel Data File a. Calculate the grand mean. (Negative value should be indicated by a minus sign. Round your answer to 2 decimal places.) -16 -17 b. Calculate SSTR and MSTR. (Round Intermediate calculations to at least 4 decimal places and final answers to 4 decimal places.)