Quantcast XP Math - Forums - View Single Post - Probability in Excel?
View Single Post
Old 07-31-2007   #1
Posts: n/a
Default Probability in Excel?

I've been trying to do problems like this in Excel. I use the "NORMSDIST" function, but the answers I insert into my online homework program don't register them as correct. Just wondering if I'm using the right function or what I'm doing wrong. I just plug in the value that they want in the problem and use the answer as I get as the probability. I thought maybe I was supposed to use z-score, but that didn't work either.Assume that the readings on the thermometers are normally distributed with a mean of 0(degrees) and a standard deviation of 1.00(degrees). A thermometer is randomly selected and tested. Find the probability of each reading in degrees. (a) Between 0 and 1.57: (I got 0.941792444)(b) Between -2.61 and 0: (c) Between -0.98 and 2.66: (b) Less than -1.71: (c) Greater than -1.45: