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

G

Guest

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.
 
M

Michael R Middleton

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

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

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.
 

Ask a Question

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.

Ask a Question

Similar Threads

CHIDIST parameter bug? 1
Statistical tests with 2-factor data 1
VBA - retrieve data on last create named range from previous inserted named range 0
Search for matches in two columns 11
Looking for an alternate solution 3
Receiving #VALUE! when using examples from Microsoft Excel, why? 2
formula finds values in apparently blank cells 1
Can these look ups be done using Worksheets functions 6

Top