CHITEST

S

Shammy

When using the CHITEST function is there a way to get the Chi-squared value? The result that is given in the cell indicated is the p-value.
 
J

Jerry W. Lewis

=SUMPRODUCT((A2:B4-A6:B8)^2/A6:B8)

for the Example in Help (A2:B4 is actual, A6:B8 is expected)

Jerry
When using the CHITEST function is there a way to get the
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use Excel to do likelihood ratio chi-squared test? 1
CHITEST worksheet function - bug? 3
chitest and interpretation of the result 1
Index/Match Functions to Return Concatenated Response 4
Chi-Square 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
allowing each value to be used once 9
Count Data in Series 2

Top