In: Statistics and Probability
X : the annual cost per employee per year
X ~ N (1280 , 420)
a).the probability that the employees’ dental expenses will be more than $1500 per year is:-
[ in any blank cell of excel type =NORMSDIST(0.5238)]
b). the probability that the employees’ dental expenses will be between $1500 and $2000 per year is:-
[ in any blank cell of excel type =NORMSDIST(1.7143) and the another is already obtained in the previous part ]
c).let the minimum cost be $ a.
according to the problem,
[ in any blank cell of excel type =NORMSINV(0.9)]
the minimum cost for the 10 percent of employees that incurred the highest dental expenses was $ 1818.25
*** if you have any doubt regarding the problem ,please write it in the comment box...if satisfied,please UPVOTE.