Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered 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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

9781119563099

Students also viewed these Mathematics questions