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.