Today Mr.M is showing how to use invNORM. The whole point of this lesson is to give us the percentage of peolple the police academy will reject applications from. It turns out that anyone shorter than 65.44" can't be a police officer. The formula Mr.M used to get this answer is invNORM (0.15, mean, standard deviation) the 0.15 is the percentage of people who are excluded from the police department(100-85=15) Mr.M also wanted us to assume the mean in 67' and the standard deviation is 1.5', find the "cut-off" height? It is lower than 65.5 that is where the bottom 15 percent is on the chart.
No comments:
Post a Comment