The chi square probability distribution is used for a variety of statistical
hypothesis tests, e.g., goodness of fit, equality of proportions, and
contingency table tests of independence.
Excel doesn't do the setup for you. You must develop the actual frequencies
and expected frequencies in worksheet cells. Then you can use Excel's
CHITEST worksheet function or the associated CHIDIST and CHIINV functions.
See Help for information about these functions.
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.
