This table shows the distribution of winning times in the Kentucky Derby (a horse race) over...

  

Transcribed Image Text:

This table shows the distribution of winning times in the Kentucky Derby (a horse race) over 87 years. Kentucky Derby Winning Times, 1930-2016 (seconds) From To 119 120 1 120 121 121 122 20 122 123 27 123 124 14 124 く 125 10 125 126 5 126 127 128 Total 127 く 2 87 Click here for the Excel Data File (a) Fill in the highlighted cells in the table below. (Round your answers to 2 decimal places.) Frequency (f) Midpoint (m) f(m- I From To fxm 119 120 120 121 120.5 602.5 121 122 20 121.5 2,430.0 122 123 27 122.5 3,307.5 123 124 14 1,729.0 124 125 10 124.5 1,245.0 125 126 125.5 627.5 126 127 3. 126.5 127 128 2 127.5 255.0 Total 87 Average = Standard Deviation = CV = 2. (b) State whether the following statement is True or False? The raw data would show us the years when the winning times were much longer than the average. True False (c-1) Do you think it likely that the distribution of times within each interval might not be uniform? Yes No (c-2) This distribution appears to be: Symmetric Skewed right Skewed left This table shows the distribution of winning times in the Kentucky Derby (a horse race) over 87 years. Kentucky Derby Winning Times, 1930-2016 (seconds) From To 119 120 1 120 121 121 122 20 122 123 27 123 124 14 124 く 125 10 125 126 5 126 127 128 Total 127 く 2 87 Click here for the Excel Data File (a) Fill in the highlighted cells in the table below. (Round your answers to 2 decimal places.) Frequency (f) Midpoint (m) f(m- I From To fxm 119 120 120 121 120.5 602.5 121 122 20 121.5 2,430.0 122 123 27 122.5 3,307.5 123 124 14 1,729.0 124 125 10 124.5 1,245.0 125 126 125.5 627.5 126 127 3. 126.5 127 128 2 127.5 255.0 Total 87 Average = Standard Deviation = CV = 2. (b) State whether the following statement is True or False? The raw data would show us the years when the winning times were much longer than the average. True False (c-1) Do you think it likely that the distribution of times within each interval might not be uniform? Yes No (c-2) This distribution appears to be: Symmetric Skewed right Skewed left

Answer rating: 100% (QA)

a Answers are in bold First type the given data in MSEXCEL columns as column1C1From C2To C3Frequency fC4Midpoint m C5fm C6fmxbar 2 Calculations for fi... View the full answer