6. What percentage of data would you predict would be between 41 and 58 and what
ID: 3312709 • Letter: 6
Question
6. What percentage of data would you predict would be between 41 and 58 and what percentage would you predict would be more than 58 miles? Subtract the probabilities found through =NORM.DIST(58, mean, stdev, TRUE) and =NORM.DIST(41, mean, stdev, TRUE) for the “between” probability. To get the probability of over 58, use the same =NORM.DIST(58, mean, stdev, TRUE) and then subtract the result from 1 to get “more than”. Now determine the percentage of data points in the dataset that fall within this range, using same strategy as above for counting data points in the data set. How do each of these compare with your prediction and why is there a difference?
DRIVE 52 57 55 49 57 47 53 42 59 50 51 56 54 49 53 51 62 56 54 49 45 53 36 47 39 52 51 43 42 54 52 52 52 50 36 48 54 48 52 61Explanation / Answer
From the given data we have
P(41 < X < 58) = NORM.DIST(58,50.575 ,5.8944,TRUE)-NORM.DIST(41,50.575,5.8944,TRUE)
= 0.844 i.e. 84.4%
P(X > 58) = 1 - NORM.DIST(41,50.575,5.8944,TRUE)
= 0.1039 i.e. 10.39%
Values are different because the first one is calculated with an assumption of normal distribution and the second one is calculated using actual data counting
Mean 50.575 std.dev. 5.894435936Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.