What percentage of data would you predict would be between 40
and 70 and what percentage would you predict would be more than 70
miles? Subtract the probabilities found through
=NORM.DIST(70, mean, stdev, TRUE) and
=NORM.DIST(40, mean, stdev, TRUE) for the
“between” probability. To get the probability of over 70, use the
same =NORM.DIST(70, 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...