Tell me more ×
Cross Validated is a question and answer site for statisticians, data analysts, data miners and data visualization experts. It's 100% free, no registration required.
up vote -1 down vote favorite

When I insert the p-value 3.2531E-129 into excel's CHIINV function I get #NOMBRE as a result.
How do I find or report the chi-square value if this doesn't work?
Someone suggested I wrote out the 0 when the value was 6.1203E-05 to 0,0000061203.
So, how can I change 3.2531E-129 to 0.000000......32531?
Thank you for your help.

share|improve this question
1  
You need to input the degrees of freedom as well: – Peter Flom Jun 26 '11 at 12:10

1 Answer

up vote 3 down vote

You need to input degrees of freedom as well. I tried =CHISQ.INV.RT(3.253E-139,2) and got 637.76

share|improve this answer
Thanks for your prompt reply. My degrees of freedom is 1. I tried it again and got the same error message. So opened a new sheet and did the entire calculation again and it doesn't even give me an E response for the P value. Could my work sheet have got corrupt somehow? – alis Jun 26 '11 at 12:28
My question still remains about the E value at the end. What to do when an p-value e.g. comes out as 1.28441E-12. Do I write out all of the zeros? – alis Jun 26 '11 at 12:33
@alis Maybe you should look at stats.stackexchange.com/q/11812. – whuber♦ Jun 26 '11 at 17:50
You do not need to write out the zeros. But the result from the inverse chisquare distribution with that probability is either too big or too small for Excel to write, depending on whether you use chisq.inv (left tail) or chisq.inv.rt (right tail) – Peter Flom Jun 26 '11 at 21:56
Thank you so much this answers many of my questions about reporting results! – alis Jun 27 '11 at 16:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.