Hi,
I am developing a website (asp2 / c# / sql server 2000) where a whole lot of stats needs to be produced. I don't have much time remaining before the deadline, and I have to produce the following statistics:
-Normality Testing (Shapiro Wilk, P-P and Q-Q tests)
-Parametric (pre test) Grubb test to remove outliers
-Students T-Test on non-outliers
-Non-Parametric Testing - ChebyChev Theorem
I do have all of these statistics models in one excel spreadsheet (with a flurry of VBA as well!), and it would be easy(?) for me to link an ODBC link from SQL Server 2000 to Excel, to get the data in and out, but is this a pratical solution? The chances are that only one person will use the system at a time... But is it possible to open an excel spreadsheet on the server and run the stats? If anyone has any code for this, in C# to open up excel, I'd be eternally grateful!
I know that I can buy a stats package like the Go to the complete details ...