The following data was reported on total Fe for four types of iron formation (1
ID: 3054977 • Letter: T
Question
The following data was reported on total Fe for four types of iron formation (1 = carbonate, 2 = silicate, 3 = magnetite, 4 = hematite). 1 20.9 28.1 27.8 27.0 28.2 25.2 25.3 27.1 20.5 31.5 2: 26.1 24.0 26.2 20.2 23.5 34.0 17.1 26.8 23.7 24.9 3: 30.434.0 27.5 29.4 27.9 26.2 29.9 29.5 30.0 36.4 4: 36.4 44.2 34.1 30.3 31.9 33.1 34.1 32.9 36.3 25.7 Carry out an analysis of variance F test at significance level 0.01. State the appropriate hypotheses Hai at least two ?'s are equal Hai all four H's are unequal Ha: al four us are equal Ha: at least two ui's are unequal Summarise the result in an ANOVA table(nserstwo decimal lces ) Sum of Mean Squares Squares Source df 10.99X 36 Error Total 39 Give the test statistic. (Round your answer to two decimal places.)Explanation / Answer
By using excel we can solve this question easily.
First, enter all data into excel.
Click on Data -------> Data Analysis--------> Anova: Two-Factor Without Replication-----> Input Data -------> Select all data -------> Output Range : Select any empty cell --------> ok
We get
f = 11.03
P-value < 0.01 we reject null hypothesis.
Conclusion: At least one of the means are not equal.
ANOVA Source of Variation SS df MS F P-value F crit Between Groups 519.10 3.00 173.03 11.03 0.00 2.87 Within Groups 564.87 36.00 15.69 Total 1083.97 39.00Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.