Question

Calculate the statistics in the green ANOVA table.

​​​​​​​

Excel File Edit View Insert Format Tools Data Window $ Help M 4% D Sat 8:25 PM mac Q Workbook Exercise 5 ANOVA (2).xlsx Search in Sheet Home | Layout Tables SmartArt Data Font Number Format 母| Fill : Calibri (Body) , | 1 1 |▼ abc ▼ wrap Text▼ General ▼ ClearBIU Merge 0 00 Conditional Forma Insert Delete FormatThemeS C15 One way ANOVA for H0: μ1-p2 .。.pK MeanStd Dev 33.00 26.00 .70 4.20 Number of Groups (k Level of Significance 0.05 Cakulate the statistics in the green ANOVA table. 15 16 17 18 Error 20 21 23 24 26 27 28 29 31 32 Instructions ANOVA2-ANOVA-Summary Data Normal View Ready Sum-0 23

Answer 1

The R codes are attached. On running the program the output can be found out

R RGui (32-bit) File Edit Packages Windows Help R R Console > sse-sum (s^2) #error sum of squares F(ssb/ (k-1))/(sse/(sum (n) -k)) F critical-qf (0.95, k-1,sum (n)-k) tss-sse+ssb > df sse=sum (n)-k # degrees of freedom of sse > df ssb-k-1 #degrees of freedom of ssb 1 40.71818 F critical [11 3.885294 [11 62.38 ssb [11 423.3333 df sse 1) 12 df ssb > ms sse-sse/df sse #ms for sse > ms ssb-ssb/df ssb #ms for ssb >ms sse [11 5.198333 ms ssb [1] 211.6667

R RGui (32-bit) - [Untitled - R Editor] R File Edit Packages Windows Help n-c (5, 5,5) ybar-c(33,26,20) ybar00-mean (ybar) ssb-5 * sum ((ybar-ybar00)^2) #between sum of squares s-c (5.7,4.2,3.5) sse-sum (s^2) #error sum of squares F (ssb/ (k-1))/ (sse/ (sum (n)-k)) F critical-qf (0.95, k-1, sum (n) -k) tss-sse+ssb df sse-sum (n)-k # degrees of freedom of sse df ssb-k-1 #degrees of freedom of ssb F critical sse ssb df sse df ssh ms sse-sse/df sse #ms for sse ms ssb=ssb/df ssb #ms for ssb ms sse ms ssb