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.
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" <yo@discussions.microsoft.com> wrote in message
news:BDBCA140-E5F6-4CAA-BAD1-6795A13D64F2@microsoft.com...
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks