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!!! |
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