A pet food company has a business objective of expanding itsproduct line beyond its current kidney- and shrimp-based cat foots.The company developed two new products, one based on chicken liverand the other based on salmon. The company conducted an experimentto compare the two new products with its two existing ones, as wellas a generic beef-based product sold in supermarket chains.
For the experiment, a sample of 50 cats from the population at alocal animal shelter was selected. Ten cats were randomly assignedto each of the five products being tested. Each of the cats wasthen presented with 3 ounces of the selected food in a dish atfeeding time. The researchers defined the variable to be measuredas the number of ounces of food that the cat consumed within a10-minute period that began when the filled dish was presented tothe cat. The results for this experiment are summarized inCatFood.
a. At the 0.05 level of significance, is there evidence of adifferences in the mean amount of food eaten among the variousproducts?
b. Does the result in (a) give you statistical permission toprobe for individual differences between the food products?
Please show me how to do this in excel using the data analysistab
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 |