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 zscore, 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:
