3.

Read textbook problem 11.13 (pg. 413) and use the CatFood textbook data file to answer the

questions below.

a.

(In Excel)

Complete the ANOVA test in Excel and report your conclusion here.

b.

(In Excel)

Complete the pairwise comparisons in Excel using the Bonferroni

Correction. Be sure to specify what corrected level of significance you use and how

you determined it.

In addition, summarize below which comparisons significantly

differed (at your corrected level of significance).

c.

(In Excel)

Ignore part c in the textbook and instead provide visual/graphical evidence

in Excel supporting the assumptions necessary for your ANOVA test in part a to be

valid. Explain your takeaways here.

d.

Complete part d of the textbook here.

e.

(Not in the textbook) In the context of part b, explain what is meant by the problem of

multiple comparisons.

f.

(Not in the textbook) Calculate the probability of making

at least one

Type I error

among all of the pairwise comparisons in part b using a 0.05 level of significance.

g.

Recalculate the probability from part f but instead using the

Bonferroni-corrected

level of significance that you used in part b. How does your answer compare to the

probability in part f?

Kidney | Shrimp Chicken Liver Salmon Beef 2.37 2.26 2.29 1.79 2.09 2.62 2.69 2.23 2.33 1.87 2.31 2.25 2.41 1.96 1.67 2.47 2.45 2.68 2.05 1.64 2.59 2.34 2.25 2.26 2.16 2.62 2.37 2.17 2.24 1.75 2.34 2.22 2.37 1.96 1.18 2.47 2.56 2.26 1.58 1.92 2.45 2.36 2.45 2.18 1.32 2.32 2.59 2.57 1.93 1.94