Question
Emma Jennifer Lisa Eloise Nadya Emma Jennifer Lisa Eloise 113 90 95 129 111 118.1 121.6 125.1 128.6 155 174 105 167 169 160.3 162.4
Emma | Jennifer | Lisa | Eloise | Nadya | Emma | Jennifer | Lisa | Eloise |
113 | 90 | 95 | 129 | 111 | 118.1 | 121.6 | 125.1 | 128.6 |
155 | 174 | 105 | 167 | 169 | 160.3 | 162.4 | 164.5 | 166.6 |
124 | 159 | 176 | 120 | 66 | 82.5 | 67 | 51.5 | 36 |
89 | 135 | 171 | 139 | 146 | 171.4 | 183.2 | 195 | 206.8 |
110 | 150 | 69 | 175 | 86 | 111.1 | 108.8 | 106.5 | 104.2 |
90 | 102 | 85 | 77 | 155 | 133.3 | 143.8 | 154.3 | 164.8 |
129 | 84 | 80 | 133 | 144 | 137.7 | 145.6 | 153.5 | 161.4 |
65 | 133 | 82 | 97 | 115 | 117.6 | 124 | 130.4 | 136.8 |
129 | 161 | 169 | 124 | 90 | 100.1 | 88.6 | 77.1 | 65.6 |
132 | 98 | 162 | 111 | 111 | 114.1 | 111.2 | 108.3 | 105.4 |
133 | 169 | 177 | 102 | 120 | 112.3 | 103 | 93.7 | 84.4 |
73 | 81 | 156 | 106 | 63 | 97.3 | 97.8 | 98.3 | 98.8 |
101 | 73 | 134 | 96 | 179 | 170.3 | 188.2 | 206.1 | 224 |
178 | 127 | 175 | 83 | 65 | 44.6 | 17.6 | -9.4 | -36.4 |
114 | 180 | 143 | 175 | 133 | 158.9 | 162.2 | 165.5 | 168.8 |
175 | 163 | 124 | 140 | 67 | 62.1 | 38.2 | 14.3 | -9.6 |
77 | 171 | 134 | 82 | 149 | 139.1 | 144.6 | 150.1 | 155.6 |
179 | 86 | 170 | 151 | 122 | 126.9 | 122 | 117.1 | 112.2 |
131 | 75 | 136 | 87 | 106 | 95.6 | 91.8 | 88 | 84.2 |
140 | 166 | 121 | 99 | 167 | 134.7 | 133.4 | 132.1 | 130.8 |
To find you elite athlete, you decide to look at the run data over the last 20 runs for 10 runners.You've been able to collect run times (in mins) for each of the 10 runners. Is there a statistically significant difference between the runners so you can identify which one of them could be your elite athlete?
Please review the problem and the data provided in each tab. Identify the type of hypotheis test needed to be done to solve the problem and go through the key steps for each hypothesis test.
Could you please give me the step by step approach in excel worksheet?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started