Anova exercise . Show the step and output using Excel. = Menu vHomeInsertPage LayoutFormulasReviewViewToolsQ Click to find commandsData- A ABIU- B- 9- Q- A - Q- EE3X Cut- 11ΣCalibriGeneralPaste U Copy - FormatPainterMerge and WrapCenterConditionalFormat asAutoSum AutoFilterТextFormattingTableA1® fxAH.MP2Grayson's PondBeaver LakeAngler's CoveAppletree LakeRock River(Ea*ij)²C =328.239.646.34156.34.33.240.842.144.154.1• TSS = E (Xij – x)² = Eax3j – C36.437.943.546.459.4Lall6.34.637.148.840.262.7• SSB = E"n;(X; – x)? = E,(E,xij?)- C29.143.643.738.66083142.440.136.357.3niSSW = TSS - SSB910- df between11df within = dftotal1213Where14X: Overall mean1516X;: Mean of group/treatment i1718Xij: data for treatment i and replicate j1920n¡: no of replicates in treatment i2122In this eg., i=4 and j=n232425262728 • Household wastewater quality at Tabuan Jaya was compared duringlow, medium and high flow. Is there any significant difference indissolved oxygen concentration (mg/L) between different flow rates?Which means are significantly different?Replicate Low Medium High17.339.138.8127.069.338.9936.799.28.97(Siew, 2002)

H0:μLow=μMedium=μHigh Vs H1: At least one of them is significantly different from others.

Household wastewater quality at Tabuan Jaya was compared during low, medium and high flow. Is there any significant difference in dissolved oxygen concentration (mg/L) between different flow rates? Which means are significantly different? Replicate Low Medium High 1 7.33 9.13 8.81 7.06 9.33 8.99 3 6.79 9.2 8.97