SECTION 4.1Complete the organizer for one-way analysis of variance. SSdfMSF-test Factors[A][B][C][D] Error[E][F][G]XXXXXXX Total[H][I]XXXXXXXXXXXXXX Although the context is unknown, the sum of squares for the factors or treatments is 196. The degrees of freedom for error is 11, the total sum of squares is 273, total degrees of freedom is 19, and the mean square error is 7. Test so to achieve 97% confidence with the results. **QUESTION 5**Based on the prescribed confidence level, what is the corresponding level of significance? **[COMMENTS & HINTS: Report as a percentage with percent symbol. Consider the confidence and significance level as strictly complementary, without any workarounds in this case.]**[Text Box]---**QUESTION 6**Which spreadsheet function generates the corresponding critical value for this hypothesis test?- a. `=F.INV(alpha, df factors, df error)`- b. `=F.INV.RT(alpha, df factors, df error)`- c. `=F.DIST(alpha, df treatments, df error)`- d. `=F.DIST.RT(alpha, df treatments, df error)`---**QUESTION 7**Compute the critical value for this hypothesis test. Report the answer rounded to the nearest hundredth.[Text Box]---**QUESTION 8**Did the F test statistic exceed the F critical value?- No, the test statistic is **much, much less** than the critical value.- No, the test statistic is **less** than the critical value.- No, the test statistic is **slightly or marginally less** than the critical value.- Yes, the test statistic is **slightly or marginally greater** than the critical value.- Yes, the test statistic is **greater** than the critical value.- Yes, the test statistic is **much, much greater** than the critical value.

Obtain the missing values in the ANOVA table. The missing values in the ANOVA table are obtained below as follows: From the information, given that SST=196,df error=11, TSS=273, df total=19,MSSE=7 That is, (5) Determine the level of significance The level of significance is determined below as follows: From the information, given that the confidence level is 97%. Here, confidence level is 0.97. Therefore, the level of significance is 3%.(=0.03).(6) Determine the function that is used to generate the critical value. The function that is used to generate the critical value is determined below as follows: The function that is used to generate the critical value in the spreadsheet is F,INV(alpha, df factors, df error). Correct option: Option a (7) Use EXCEL Procedure for finding the critical value of F at the 0.03 significance level. Follow the instruction to obtain the critical value of F: Open EXCEL Go to Formula bar. In formula bar enter the function as“=FINV” Enter the probability as 0.03 Enter the numerator degrees of freedom as 8 .Enter the Denominator degrees of freedom as 11 Click enter EXCEL output: From the EXCEL output, the critical value of F at the 0.03 significance level is 3.47 Thus, the critical value of F at the 0.03 significance level is 3.47. (8) Determine whether the F test statistic exceeds the critical value or not. It is clear that the value of test statistic is 3.50 and the critical value is 3.47. Therefore, it can be concluded that the test statistic is greater than the critical value. Correct option: Option 5