= Menu v Home Insert Page Layout Formulas Q Click to find commands Data Review View Tools 3 X Cut - A A Σ Calibri 11 General e J Copy BIU- H- 9- Q· A -Q- EE Merge and Wrap O - % 000 i 80 AutoFilter...

Anova exercise . Show the step and output using Excel.

Extracted text: = Menu v Home Insert Page Layout Formulas Q Click to find commands Data Review View Tools 3 X Cut - A A Σ Calibri 11 General e J Copy BIU- H- 9- Q· A -Q- EE Merge and Wrap O - % 000 i 80 AutoFilter Sort Format Fill Rows and Worksheet Freeze Panes Format Conditional Format as AutoSum Painter Center Тext Formatting Table Columns A1 ® fx A B E G H J K L (Eaxij)? E;ni 2 C = Stomach (mg/kg) Gill (mg/kg) Muscle (mg/kg) 3 TSS = -all Eal (*ij – x)? = Ealij - 4 20 32 26 SSB = E n;(X; – x)² = E;- (E,xij²) 18 36 30 - C ni 18 34 14 SSW = TSS – SSB 7 df within df total – df between 8 Where 10 X: Overall mean 11 12 X;: Mean of group/treatment i data for treatment i and replicate j 13 Xij: 14 15 n¡: no of replicates in treatment i 16 In this eg., i=4 and j=n 17 18 19 20


Extracted text: • Concentrations of Zinc in the different tissues of a crustacean are shown below. Which means are significantly different? Stomach (mg/kg) Gill (mg/kg) Muscle (mg/kg) 20 32 26 18 36 30 18 34 14 (Courtesy of Dr. Harwant Singh, Modified)