Chi-Squared, Komogorov-Smirnov, Anderson-Darling tests
 

Hi, i have two columns of data: expected values and actual values. Does
anyone know of any functions or add-ins in Excel to run Chi-Squared,
Kolmogorov-Smirnov and Anderson-Darling tests on the data? Thank you for any
help you can provide.

yo -

Excel has worksheet functions CHIDIST (to compute a prob-value) and CHIINV
(to determine a critical value) after you use worksheet formulas to
calculate the chi-square statistic.

For other tests, try a Google search.

- Mike
www.mikemiddleton.com

+++++++++++++++++++++++

"yo" wrote in message
...
Hi, i have two columns of data: expected values and actual values. Does
anyone know of any functions or add-ins in Excel to run Chi-Squared,
Kolmogorov-Smirnov and Anderson-Darling tests on the data? Thank you for
any help you can provide.