A few days ago
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
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
- Academic Writing
- Accounting
- Anthropology
- Article
- Blog
- Business
- Career
- Case Study
- Critical Thinking
- Culture
- Dissertation
- Education
- Education Questions
- Essay Tips
- Essay Writing
- Finance
- Free Essay Samples
- Free Essay Templates
- Free Essay Topics
- Health
- History
- Human Resources
- Law
- Literature
- Management
- Marketing
- Nursing
- other
- Politics
- Problem Solving
- Psychology
- Report
- Research Paper
- Review Writing
- Social Issues
- Speech Writing
- Term Paper
- Thesis Writing
- Writing Styles