Question

Assume that the readings at freezing on a batch of thermometers are normally distributed with a...

Assume that the readings at freezing on a batch of thermometers are normally distributed with a mean of 0°C and a standard deviation of 1.00°C. A single thermometer is randomly selected and tested. Let Z represent the reading of this thermometer at freezing. What reading separates the highest 3.01% from the rest? That is, if P ( z > c ) = 0.0301 , find c. c= __°C I need to know how to solve this in Excel. My calculator broke and I am now having to learn how to do everything in excel for my exam on Friday. I appreciate the help!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Here we have to calculate the inverse of the Cumulative Normal Distribution Function using excel.

Below is the syntax to do the same in Excel.

=NORM.INV( probability, mean, standard_dev )

Here mean=0 and standard deviation=1, Probability = 0.0301

=NORM.INV( probability, mean, standard_dev\

= -1.879

Add a comment
Know the answer?
Add Answer to:
Assume that the readings at freezing on a batch of thermometers are normally distributed with a...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT