ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   chi squares (https://www.excelbanter.com/excel-discussion-misc-queries/96823-chi-squares.html)

Rozie

chi squares
 
does anyone know if excel does chi squared? If it does, do u know the code
for it or how to get it to work. thanks!!!

Mike Middleton

chi squares
 
Rozie -

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.

- Mike
www.mikemiddleton.com

"Rozie" wrote in message
...
does anyone know if excel does chi squared? If it does, do u know the code
for it or how to get it to work. thanks!!!





All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com