Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transportation A Global Supply Chain Perspective

Authors: John J. Coyle, Robert A. Novak, Brian Gibson, Edward J. Bard

8th edition

9781305445352, 1133592961, 130544535X, 978-1133592969

More Books

Students also viewed these Mathematics questions