Question: can i get help with this and please show the excel functions for it. insert results of the anova test here. 3 A nutritionist wishes

can i get help with this and please show the excel functions for it.
insert results of the anova test here.
can i get help with this and please show the excel functions

3 A nutritionist wishes to compare three well-known weight loss treatments. Using data on girth (i.e., a function of height 4 and weight), age, and metabolism, he matches 24 of his female clients into eight groups of three each and randomly 5 assigns one member of each group to one of the weight loss treatments. The following data represent the amount 6 of weight (in pounds) lost by the 18 clients atter six weeks of treatment. 7 8 Perform a randomized block ANOVA at =0.05. 9 10 a. State the null and alternative hypothesis H0 : u1=2=3 11 b. Perform a randomized block ANOVA H1: not all means are equal 12 c. State your conclusion 13d. Determine if the blocking factor is effective and state conclusion Reject or Retain \begin{tabular}{|r|l|r|r|r|} \hline 14 & & & & \\ \hline 15 & Block & A & B & C \\ \hline 16 & Group 1 & 10.4 & 12.1 & 9 \\ \hline 17 & Group 2 & 9.8 & 14.5 & 9.6 \\ \hline 18 & Group 3 & 7.3 & 10 & 9.8 \\ \hline 19 & Group 4 & 7.5 & 9.9 & 10.7 \\ \hline 20 & Group 5 & 8.6 & 14.2 & 11.1 \\ \hline 21 & Group 6 & 10.7 & 10.5 & 10.5 \\ \hline 22 & Group 7 & 9.9 & 10.4 & 10.2 \\ \hline 23 & Group 8 & 8.3 & 13 & 11.5 \\ \hline 24 & & & & \\ \hline \end{tabular} Conclusion: Identify Fat: Conclusion

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!