Question

make sure is done in excell

Open the Excel program Suppose we want to know the standard normal distribution up to the given value. That is P(Z <a). Lets use Excel instead of the standard normal distribution table In cell A1 type mean. In cell B1 type 0. That means that we are letting mean be zero. click on cell A2 and type SD. In cell B2 type 1. That means that we are letting standard deviation be one. That is, the normal distribution is standard. Suppose that a=-1.72 Click on cell B6 and type =NORMDIST(-1.72.B1,B2,TRUE). We obtained in B6 the probability of Z<-1.72. Compare this result with what you would find in the standard normal distribution table. Now we do it for any normal distribution. That is, not only that we do not need the table, but we also do not have to do the algebra to go from standard normal distribution to the given normal distribution. We will illustrate that on an example. Suppose that SAT scores have normal distribution with mean 840 and standard deviation 200. If you score 970 on the SAT, what is your percentile? To do this we first go to cell D1and type 840. That means that we are letting mean be 840. Click on cell D2 and type 200. That means that we are letting standard deviation be 200. That is, the normal distribution is not standard. Now click on cell D6 and type =NORMDIST(970,D1, D2, TRUE). Did you obtain approximately 74 as your percentile? Exercises

Answer 1

SAT Scores Pilestrate that on an have normal olfstribution we go to the perceuttle? To do this solution from the given information, we have Now we do it for any normal distribution. That is, not only that we do not need the table, but we also do not have to do the algebra to go from standard normal distribution to the given normal distribution, we will an example. Suppose that with mean 84o and standa on the SAT, what is derpatron 200 - If you scove 970 first cell D, and type 840. That meaus that we are letting be suo. By using the command in excel, ENORMOIST (970, Der P2, True] the value 0.74 using Excel, evaluate P(744.34.236) 7/747.34.236)=0.9103 en fand the talde value TC. 34.226) by looking at the tabe The table value for 1- 34 23 695 /0.9099) G@ compare your result in cei 412 with your cell to put your explanation en cell App. The result is excel as larger than result in table ① Ifx is normal dastributed with mean 890 and standard deviation iso evaluate plx cloud using Put your result in cell Ary است get resulter Си ene

Now we Zescore for x= 10u8 is, 7=(x-meaulsd-Clou8-290)/150-1.05 have to find Przeros) same syntan as, ENORMODIST() No we will use . wherezalos PCZCH-05)=0-8531 & please Rate & O