Question

Open the Excel program In our last computer assignment we learned how to find the standard...

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<a. We would like to find the score a. In cell B7 type =NORM.INV(0.042716,B1,B2). That gives you the score a. We went backwards to -1.72. There is a way to find this score a using the standard normal distribution table, but our result will not be as precise as the one obtained with Excel today.

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<a)=36% evaluate a using Excel. Put your result in cell A15.

Homework Answers

Answer #1

From the given information, we get

------------@----------

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Open the Excel program Suppose we want to know the standard normal distribution up to the...
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...
Problem #1 Confidence Interval for Means using the t and z Distribution.    Psychologists studied the percent...
Problem #1 Confidence Interval for Means using the t and z Distribution.    Psychologists studied the percent tip at a restaurant when a message indicating that the next day’s weather would be nice was written on the bill. Here are tips from a random sample of patrons who received such a bill, measured in percent of the total bill: 20.8     18.7     19.9     20.6     21.9     23.4     22.8     24.9     22.2     20.3   24.9     22.3     27.0     20.4     22.2     24.0     21.1     22.1     22.0     22.7 Open an...
1. Find the area under the standard normal curve (round to four decimal places) a. To...
1. Find the area under the standard normal curve (round to four decimal places) a. To the left of  z=1.65 b. To the right of z = 0.54 c. Between z = -2.05 and z = 1.05 2. Find the z-score that has an area of 0.23 to its right. 3. The average height of a certain group of children is 49 inches with a standard deviation of 3 inches. If the heights are normally distributed, find the probability that a...
1. For a pair of sample x- and y-values, what is the difference between the observed...
1. For a pair of sample x- and y-values, what is the difference between the observed value of y and the predicted value of y? a) An outlier b) The explanatory variable c) A residual d) The response variable 2. Which of the following statements is false: a) The correlation coefficient is unitless. b) A correlation coefficient of 0.62 suggests a stronger correlation than a correlation coefficient of -0.82. c) The correlation coefficient, r, is always between -1 and 1....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT