Question: What formula and step do I need to answer this in excel? 1. What is the level of stress (if any) that cows undergo at
What formula and step do I need to answer this in excel?

1. What is the level of stress (if any) that cows undergo at different pre-slaughter phases? To answer this question, a biostatistician randomly selected eight cows from Burdekin, Townsville, and the heart rate of a cow was measured at four different pre-slaughter phases: 1) first phase of visual contact with pen mates; (2) initial isolation from pen mates for prepping; (3) restoration of visual contact with pen mates; and (4) first contact with human prior to slaughter. The data are as follows. Cow breed type (1) Pre-slaughter phase UI AWN- (2) 124 (3) (4) 124 109 100 107 98 98 99 103 98 100 106 94 91 98 95 122 109 6 114 103 115 92 100 106 98 80 99 103 120 84 107 110 Based on the above information, answer the following questions. (a) At the 5% level of significance, was blocking effective? Follow all the necessary steps and verify your results using Excel/PHStat. (b) Using a 5% level of significance, is there a significance difference in the mean heart rate of the four pre-slaughter phases? Follow all the necessary steps to perform the test. (c) If your results in (b) indicates that it is appropriate, use the Tukey procedure to determine which groups differ in the mean heart rate. Use 5% level of significance. Follow all the necessary procedure to perform the test
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
