subject
Mathematics, 29.08.2019 23:30 juliopejfuhrf5447

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 z is standard normal distribution. in this exercise we will learn how to go backwards, that is from the probability p(z < a) to the score a.
in cell a1 type mean and in cell b1 type 0. that way we are letting mean be zero.
next click on cell a2 and type sd and in cell b2 type 1. that means that we let standard deviation be one. that is, our normal distribution is standard.
suppose we know that the percentile of the score is 4.2716%. we would like to find the corresponding score.
type 0.042716 in b6. that is the given probability of z
now we do this process for any normal distribution. that is, not only that we do not need the table, but we also do not have to apply the formula to go from standard normal distribution to the given normal distribution. we illustrate that on an example. suppose that cholesterol has normal distribution with mean 189 and standard deviation 28. suppose your cholesterol percentile is 60%. that is your cholesterol is higher than approximately 60% of all people in the world. we would like to evaluate your cholesterol level using excel. to do this we first click on cell d1and type 189. that means that we let mean be 189.
next click on cell d2 and type 28. that means that we let standard deviation be 28. this means cholesterol normal distribution is not standard. next, click on cell a6 and type probability. then click on cell a7 and type score.
now click on cell d6 and type .6
finally click on cell d7 and type =norm. inv(d6,d1,d2). did you obtain approximately 196 as your cholesterol?
exercises
exercise 1 using excel, evaluate the score that corresponds to 65 percentile in standard normal distribution. put your result in cell a11.
exercise 2. let x be normally distributed with mean 89 and standard deviation 15. given p(x

ansver
Answers: 1

Another question on Mathematics

question
Mathematics, 20.06.2019 18:04
The triangles are similar. what is the value of x? enter your answer in the box. x = two right triangles. the larger right triangle is labeled x on the longer leg, 12 on the shorter leg and 20 on the hypotenuse. the smaller triangle is labeled 4 on the longer leg, 3 on the shorter leg, and 5 on the hypotenuse.
Answers: 2
question
Mathematics, 21.06.2019 16:20
Under normal conditions, 1.5 feet of snow will melt into 2 inches of water. during a winter season high in the mountains, 301 feet of snow fell. how many inches of water will there be when the snow melts?
Answers: 1
question
Mathematics, 21.06.2019 18:00
Solve the equation -9p - 17 =10 a -3 b. 16 c. 18 d -16
Answers: 2
question
Mathematics, 21.06.2019 23:30
It takes an ant farm 3 days to consume 1/2 of an apple. at that rate, in how many days will the ant farm consume 3 apples
Answers: 1
You know the right answer?
Open the excel program
in our last computer assignment we learned how to find the standard nor...
Questions
question
Mathematics, 16.10.2020 22:01
question
English, 16.10.2020 22:01
question
English, 16.10.2020 22:01
question
Spanish, 16.10.2020 22:01
question
Mathematics, 16.10.2020 22:01