To download the software packages of
statistics and non linear modelling

Free Statisticswith Excel 4.0 -- Excel XP






Updated on July 7, 2003 - © AstroResearch
thanks to Alain Mauranne for the transcription


I give readers:

1) - a whole kit for non parametric tests. The tests are included in a macro sheet which installs automatically a calculation sheet from which tests can be carry out.



To see non parametric tests didactic file- Download the non parametric test file.pdf -

-Updated on July 3, 2003: the Macro was transformed in the international size. A bug can occur if program needs function ALEA.ENTRE.BORNES (). Please contact me if necessary. Another bug was corrected concerning the test of Fisher-Yates-Terry. The exact test of Fisher was added to the calculation of the 4 compartments (table of contingency [bug corrected version for a table other than 2 x 2].  Numerous improvments : Mann Whitney Wilcoxon, Kruskal Wallis, T Signed Wilcoxon and Fisher Yates Terry with exact significance levels for small numbers.  Addition of the Spearman rank correlation and Friedman's test for treatment differences in randomized complete blocks design. Addition of a kit which completes the Analysis Tool Pack utility [supplied by Microsoft] on the linear regression [It will be gradually completed and updated] with the Durbin Watson test. Utilities with exact tables. Addition of the Kolmogorov Smirnov for one and two samples with tables. Exact tables for the Kruskal Wallis test with m = 3 [that is, 3 columns when ni < 5]. Addition, the 5/25/03, of the Fisher's exact test [see contingency table and file non parametric tests]. Addition, the 31/5/03 of the Kendall's Tau correlation coefficient. Addition, the 08/06/03 of the Test sign and improvment to the Wald-Wolfowitz - alias run test. Addition, the 06/12/03 of the Moses Test of Extreme Reaction. Addition of the Mood test [extension of median test]. Addition, the 06/15/03 of the McNemar test. Addition, the 06/21/03 of the Jonckheere - Terpstra test [in order to test the null hypothesis that the groups are not ranked in a predicted order]. Addition of the Page's Test, the 06/22/03 [with table, cf. http://www.dsa.unipr.it/soliani/]. Correction of bugs in Friedman's Test - Addition of the Kendall's W coefficient of concordance, the 06/26/03. Addition of the G-Test or Log-Likelihood Ratio Test, the 03/07/03.

 download the program of non parametric tests [103 Kb in the file size Zip]


2) - a software of non-linear modelling allowing the realization of  numerous analyses on scalar and vectorial functions with independent variable in vectorial or matrix form ; having bookshops integrated by functions used in pharmacokinetics as well as numerous statistical options [residual tests, run-test, Durbin-Watson, Akaike, etc.]-



To see non-linear optimization - Demo file - quasi Newton [1, 2, 3]

Numerous improvements were brought to Min!F since March 1st, 2003. Dialog boxes were reviewed and procedure for the  functions implementation was simplified. A lot of bugs were corrected. Thank you to show me some others. All system files have to be placed in the same directory. A brief tutorial  was set up. A lot of improvements concerning statistical tests were added. Some bugs have been corrected on the simulation module in the field of the pharmacokinetics :

- Study of automated bioavailability [global optimization of models with extra vascular and vascular administration]. Studies of modelling concerning multiple observations taking into account a matrix model from which one generates the estimations of the parameters by quasi-Newton methods. In a second time, one refines by groups of observations [i.e. for every subject] for opened compartmental models. [April 3, 2003]

download Min!f 4.0 package program -  [244 Kb in the file size Zip ]

These software packages were thought up under Microsoft Excel 4.0 and were " upgraded "in order to be used under the following versions of Microsoft Excel. It looks likes so with software packages " freeware ". I do insist on the fact that such kind of similar software packages cost sometimes more than 27,000 $... Obviously, the reader must have a version of Excel , an application winzip, and also an utility for data compression but it is not indispensable if you have Windows Millenium or if you have the very practical utility Windows commander. Here is the address of the site where you can find it: Winzip.

-File Min!f 4.0: updated on April 3, 2003.