Question
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
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 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?
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