A few days ago
Hopper52

Anyone who uses spreadsheets for statistics. I need help!?

I’m trying to do my homework for my stats. class. My professor has given me a formula to calculate the “cumulative p” from the z score. It is not working. I’ve already asked him about it, and he told me what I did wrong with my assignment, but I still can’t get the formula to work. The formula is =NORMSDIST(). I know that I’m suppose to put the cell address in the parenthesis. Please help!

Top 1 Answers
A few days ago
Merlyn

Favorite Answer

In Excel…..

in column A start listing the different z scores, e.g. start a -3.00 in A1 and put =A1 + 0.01 in A2 and fill in all the other cells up to 3.00

in the B column, in cell B1 put in =NormDist(A1,0,1,true)

this will return the cummulative value for the z score, i.e.

P(Z < Ai) = NormDist(Ai,0,1,true)

0