Question 758566
Question:
The average high-school teacher annual salary is $43,000. Let teacher salary be normally distributed with a standard deviation of $18,000.
a. What percent of high school teachers make between $40,000 and $50,000? Round to 3 decimals and keep '0' before the decimal point.
b. What percent of high school teachers make more than $80,000? Round to 3 decimals and keep '0' before the decimal point.
---------------------------------------------------------------------------
Answer:
a. Enter 
=ROUNDUP(normdist(50000,43000,18000,TRUE) - normdist(40000,43000,18000,TRUE),3)
on EXCEL, the result is {{{highlight(0.218)}}}
b. Enter 
=ROUNDUP(1 - normdist(80000,43000,18000,TRUE),3)
on EXCEL, the result is {{{highlight(0.02)}}}