Chi squared statistic function

Hi!

First post so I hope this is okay.

I'm trying to write a VBA function which performs the chi squared test (a simple statistical test to compare proportions).

It works (roughly) by comparing the difference between observed values for cells in (say) a two-by-two grid, and the expected values for those cells (calculated by multiplying the row total by the column total and dividing by the overall total).

I hope to get it to work without having to calculate the expected values as set out in the CHITEST Excel function.

I’m trying to convert over code which works in ASP, but I don’t think I’m calling it correctly, as I keep getting #VALUE! or #NUM!

Here's the code...

Please Login or Register  to view this content.

...and an example's attached.

Thanks!

Iain

Using Integer you get overflow. Use Doubles.

Please Login or Register  to view this content.

Also, in this declaration,

Please Login or Register  to view this content.

... everything but chival is declared as a Variant.

You can do this,

Please Login or Register  to view this content.