In: Statistics and Probability
a).the probability that a randomly chosen student completes the activity in less than 26.7 seconds be:-
[ in any blank cell of excel type =NORMSDIST(-1.2278) ]
b).the probability that a randomly chosen student completes the activity in more than 42.6 seconds be:-
[ in any blank cell of excel type =NORMSDIST(0.7848) ]
c).the proportion of students take between 30 and 40 seconds to complete the activity is:-
[ in any blank cell of excel type =NORMSDIST(0.6757) ]
[ in any blank cell of excel type =NORMSDIST(-0.8101) ]
d).let, a be the time.
according to the problem,
[ in any blank cell of excel type =NORMSINV(0.85) ]
85% of all students finish the activity in less than 45.59 seconds.
*** if you have any doubts about the problem please mention it in the comment box... if satisfied please LIKE.