Using Excel, evaluate the score that corresponds to 65 percentile in standard normal distribution. Put your result in cell A11.
Open the Excel program In our last computer assignment we learned how to find the standard normal distribution up to the given score value a, that is we found P(Z < a). We used Excel instead of the standard normal distribution table and evaluated P(Z<-1.72) with the command =NORMDIST(1.72,B1,B2,TRUE) and we obtained 0.042716 approximately. Here … Read more