This dataset contains scores in the first and fourth rounds for a sample of 20 golfers

profiletutor4helpyou
data.xlsx
Home>Mathematics homework help>Numerical analysis homework help>This dataset contains scores in the first and fourth rounds for a sample of 20 golfers

Data

Player Round 1 Round 4
Michael Letzig 70 72
Scott Verplank 71 72
D.A. Points 70 75
Jerry Kelly 72 71
Soren Hansen 70 69
D.J. Trahan 67 67
Bubba Watson 71 67
Reteif Goosen 68 75
Jeff Klauk 67 73
Kenny Perry 70 69
Aron Price 72 72
Charles Howell 72 70
Jason Dufner 70 73
Mike Weir 70 77
Carl Pettersson 68 70
Bo Van Pelt 68 65
Ernie Els 71 70
Cameron Beckman 70 68
Nick Watney 69 68
Tommy Armour III 67 71

Excel Project 5 This Excel Project contains 6 questions. Work out the answers to the questions and then click on "Excel Project 5" to submit your answers. Directions for performing a hypothesis test for matched samples in Excel are in the Excel Demo posted in the Week 13 folder on K-State online. **Give your answers to 2 decimal places!** This dataset contains scores in the first and fourth rounds for a sample of 20 golfers who competed in PGA tournaments in 2009. A sports fan suspects that scores in the first round are lower due to less pressure. You are to test whether this is true. 1. State the null and alternative hypotheses (take round 1 scores - round 4 scores). 2. Is this a lower tail, upper tail or two-tailed test? 3. Use Excel to carry out the test. Use  = 0.05. What is the value of the test statistic? 4. What is the p-value? 5. What is your conclusion using  = 0.05? 6. State your conclusion in words a non-statistician could understand.

Sheet3