Short: Statistical Analysis using TurboCalc 5 (update 3) Author: (Rudy Kohut and Nick Bergquist) Uploader: kohutr@connexus.net.au (Rudy Kohut) Type: misc/math Replaces: TCalcStats2b.lha Requires: OS2.04+, RexxMast rexxmathlib.library (included) rexxreqtools.library (included) TurboCalc 5+ (it may work on ver. 4) Latest version of Installer (included) Version: 2c (Almost ready for Release) Distribution: Aminet Date of this release: Sometime during August 1999 *************** Changes in version 2c: * Addition of one new script: - Durbin.rexx (Durbin Test - Incomplete Block Design) * Changes to the HELP files and Stats_Macros.TCD macrosheet to reflect the new script. I have also cleaned up the html code. *************** *************** Changes in version 2b: * Addition of three new scripts: - Chi-Sq_GO_Fit.rexx (Goodness of Fit test) - this complements the included "Normality" test which is also based on the Chi-Sq Test - Shapiro.rexx (Shapiro-Wilk Test for Normality) - Deviates.rexx (Random Normal Deviates Generator) * Changes to the HELP files and STATS_Macros.TCD macrosheet to reflect the new scripts. I have also added material in the HELP files related to the "Normality" test, linking it with the new "Goodness of Fit" test material. I would appreciate feedback/assistance on this as my ability to interpret the Chi-Sq tests is limited and text books are very confusing! (Rudy) *************** *************** Changes in version 2a: * Corrections to two scripts: - T-test_IndSamples_UneqVar.rexx (silly editing error corrected) - Fisher_Exact.rexx (programming error corrected) * Addition of two new scripts: - Cochran.rexx (Cochran's test for related observations) - Smirnov_2W.rexx (Smirnov test on two independent samples) * Changes to the HELP files and STATS_Macros.TCD macrosheet to reflect the new scripts ************** What is it? This archive contains a number of Arexx script files (32!) that are called by TurboCalc macros to produce statistical analysis on data contained in a spreadsheet. Here are the files: Wilcoxon_Sign_Rank.rexx 8630 ----rw-d 02-Aug-98 14:23:22 T-test_IndSamples_UneqVar.rexx 11281 ----rwed 24-Jun-99 13:32:12 T-test_IndSamples.rexx 10647 ----rwed 15-Aug-98 09:14:59 T-test_Corr_Sample.rexx 10444 ----rwed 15-Aug-98 09:14:09 Spearmans_Rho.rexx 14629 ----rwed 12-Sep-98 20:06:25 shannon-weiner.rexx 10448 ----rw-d 02-Aug-98 15:01:17 Regression.rexx 14935 ----rwed 07-Oct-98 12:18:59 Rank&Percentile.rexx 6215 ----rwed 02-Aug-98 14:33:01 Normality.rexx 13164 ----rw-d 03-Jul-99 11:53:50 Moving_Average.rexx 7003 ----rwed 02-Aug-98 14:34:55 Mann-Whitney.rexx 12687 ----rwed 11-Oct-98 15:00:20 Kruskal-Wallis.rexx 10401 ----rwed 02-Aug-98 14:37:07 Kendalls_Tau.rexx 7305 ----rwed 18-Aug-98 16:13:11 Histogram.rexx 7878 ----rwed 02-Aug-98 14:38:02 F_Ratio.rexx 10239 ----rwed 03-Oct-98 10:17:49 Friedman_Rank.rexx 11678 ----rwed 09-Aug-98 11:07:53 Fisher_Exact.rexx 9089 ----rw-d 24-Jun-99 13:31:52 Exponential_Smooth.rexx 7839 ----rwed 07-Feb-99 15:23:06 Descriptive_Stats.rexx 12739 ----rwed 02-Aug-98 14:41:33 Deviates.rexx 3961 ----rwed 03-Jul-99 11:54:20 Covariance.rexx 7224 ----rwed 02-Aug-98 14:42:19 Correlation.rexx 14765 ----rwed 18-Oct-98 13:58:19 Chi-Sq_Indep.rexx 11379 ----rw-d 09-Oct-98 07:48:51 ANOVA_TWOWAY_NO_REP.rexx 13115 ----rwed 21-Sep-98 20:41:54 ANOVA_TwoWay.rexx 16160 ----rwed 21-Sep-98 20:43:16 anova_oneway.rexx 11339 ----rwed 21-Sep-98 20:42:21 STATS_Macros.TCD 7011 ----rwed Today 14:13:24 STATS_Macros.TCD.info 468 ----rwed 02-Apr-99 13:28:55 Cochran.rexx 8825 ----rwed 29-Jun-99 17:56:55 Smirnov_2W.rexx 9173 ----rw-d 02-Aug-98 14:29:46 Chi-Sq_GO_Fit.rexx 9445 ----rw-d 03-Jul-99 11:53:37 Shapiro.rexx 28973 ----rw-d 02-Jul-99 15:21:50 Chi-Sq_2_Ind_Sam.rexx 9898 ----rwed 04-Jul-99 11:35:04 Durbin.rexx 10140 ----rw-d Today 14:13:32 Want to know more? Read the included help files! NOTE: We have not been able to finish the help files and some of the scripts for this release. However, it is about 98% complete and still usable. Changes? This is the second version of TcalcStats. It replaces the first version developed for use with TurboCalc 3.5. This version uses Turbocalc 5+ but may also work with TurboCalc version 4 (untested). Please note: there were some changes made to the Arexx command set in TurboCalc between 3.5 and 4/5. Also, TurboCalc's public screen name changed. These changes, along with many, many, others are reflected in the scripts. What is included? There are basically four categories of files in this distribution: 1. The Arexx script files that do the work and which MUST be put in the TurboCalc/Arexx drawer. 2. The spreadsheet file that contains the macros that call the scripts (called "STATS_Macros.TCD", and which can be put anywhere but will be installed in the TurboCalc/arexx drawer. 3. The help files that tell you how to use the macros and interpret the results! These files would normally be put in the Turbocalc/Help/Stats_Help drawer but you can install them anywhere. We have tried to produce two types of help files - Amigaguide and HTML. They are identical (we hope!) so choose which one you prefer. 4. Special arexx library files that must go in "Libs:". These are: >rexxreqtools.library< copyright 1992-94 by Rafael D'Hallewyn >rexxmathlib.library< copyright 1995 by Thomas Richter Installation? Use the supplied "Install_Tcalcstats2c" program to put things in their proper places. It is also vital that you have an "Assign" for Turbocalc. If the installer doesn't find one, it will prompt you to create the assign and add it to your "user-startup" file. The assign must be active or the scripts will not work!! Who did it? Rudy Kohut did the first version by himself (and it shows!). Rudy and Nick Bergquist teamed up to improve and expand the scripts and to create vastly improved help files in both amigaguide and HTML formats. Rudy lives in Melbourne, Australia. Nick lives in Greenwich, U.K. Any queries? Please give us your feedback! Contact Rudy by email: kohutr@connexus.net.au Contact Nick by email: N.A.Bergquist@greenwich.ac.uk ============================= Archive contents ============================= Original Packed Ratio Date Time Name -------- ------- ----- --------- -------- ------------- 628 271 56.8% 02-Apr-99 14:00:30 TCalcStats2c.info 628 259 58.7% 02-Apr-99 13:12:54 +AREXX.info 11339 4286 62.2% 21-Sep-98 20:42:20 +anova_oneway.rexx 16160 5305 67.1% 21-Sep-98 20:43:16 +ANOVA_TwoWay.rexx 13115 4633 64.6% 21-Sep-98 20:41:54 +ANOVA_TWOWAY_NO_REP.rexx 9898 3880 60.8% 04-Jul-99 11:35:04 +Chi-Sq_2_Ind_Sam.rexx 9445 3869 59.0% 03-Jul-99 11:53:36 +Chi-Sq_GO_Fit.rexx 11379 4251 62.6% 09-Oct-98 07:48:50 +Chi-Sq_Indep.rexx 8825 3558 59.6% 29-Jun-99 17:56:54 +Cochran.rexx 14765 5380 63.5% 18-Oct-98 13:58:18 +Correlation.rexx 7224 2705 62.5% 02-Aug-98 14:42:18 +Covariance.rexx 12739 4274 66.4% 02-Aug-98 14:41:32 +Descriptive_Stats.rexx 3961 1787 54.8% 03-Jul-99 11:54:20 +Deviates.rexx 10148 4031 60.2% 22-Aug-99 07:41:30 +Durbin.rexx 7839 2881 63.2% 07-Feb-99 15:23:06 +Exponential_Smooth.rexx 9089 3288 63.8% 24-Jun-99 13:31:52 +Fisher_Exact.rexx 11678 4640 60.2% 09-Aug-98 11:07:52 +Friedman_Rank.rexx 10239 4022 60.7% 03-Oct-98 10:17:48 +F_Ratio.rexx 7878 2913 63.0% 02-Aug-98 14:38:02 +Histogram.rexx 7305 2765 62.1% 18-Aug-98 16:13:10 +Kendalls_Tau.rexx 10401 3962 61.9% 02-Aug-98 14:37:06 +Kruskal-Wallis.rexx 12687 4544 64.1% 11-Oct-98 15:00:20 +Mann-Whitney.rexx 7003 2584 63.1% 02-Aug-98 14:34:54 +Moving_Average.rexx 13164 4910 62.7% 03-Jul-99 11:53:50 +Normality.rexx 6215 2282 63.2% 02-Aug-98 14:33:00 +Rank&Percentile.rexx 14935 5382 63.9% 07-Oct-98 12:18:58 +Regression.rexx 10448 3884 62.8% 02-Aug-98 15:01:16 +shannon-weiner.rexx 28973 8354 71.1% 02-Jul-99 15:21:50 +Shapiro.rexx 9173 3104 66.1% 02-Aug-98 14:29:46 +Smirnov_2W.rexx 14629 5762 60.6% 12-Sep-98 20:06:24 +Spearmans_Rho.rexx 7011 2010 71.3% 31-Jul-99 14:13:24 +STATS_Macros.TCD 468 264 43.5% 02-Apr-99 13:28:54 +STATS_Macros.TCD.info 10444 3951 62.1% 15-Aug-98 09:14:08 +T-test_Corr_Sample.rexx 10647 3995 62.4% 15-Aug-98 09:14:58 +T-test_IndSamples.rexx 11281 4248 62.3% 24-Jun-99 13:32:12 +T-test_IndSamples_UneqVar.rexx 8630 3245 62.3% 02-Aug-98 14:23:22 +Wilcoxon_Sign_Rank.rexx 109956 60618 44.8% 27-Jun-98 15:53:48 +installer 6828 1779 73.9% 03-Jul-99 12:13:58 +Install_Tcalcstats2c 2285 395 82.7% 31-Jul-99 14:20:44 +Install_Tcalcstats2c.info 628 261 58.4% 02-Apr-99 11:14:08 +Libs.info 5448 3376 38.0% 27-Jun-98 16:00:56 +rexxmathlib.library 11664 6534 43.9% 27-Jun-98 16:01:08 +rexxreqtools.library 6347 2766 56.4% 22-Aug-99 07:56:38 +Readme 1320 827 37.3% 03-Jul-99 12:15:12 +Readme.info 7011 2010 71.3% 31-Jul-99 14:12:02 +rexx 628 270 57.0% 02-Apr-99 11:14:08 +Stats_Help.info 628 272 56.6% 02-Apr-99 13:14:20 +AmigaGuide.info 178696 57366 67.8% 22-Aug-99 07:39:16 +TCalcStats2c.Guide 1576 931 40.9% 31-Jul-99 14:17:20 +TCalcStats2c.Guide.info 628 269 57.1% 02-Apr-99 11:15:00 +html.info 6848 2824 58.7% 31-Jul-99 14:24:22 +anova1.html 7639 2965 61.1% 31-Jul-99 14:24:22 +anova2.html 2734 1204 55.9% 31-Jul-99 14:24:22 +anova3.html 2426 1113 54.1% 31-Jul-99 14:24:22 +chisquare.html 2739 1271 53.5% 31-Jul-99 14:24:24 +chisq_gof.html 2599 1266 51.2% 31-Jul-99 14:24:24 +cochran.html 5758 2333 59.4% 31-Jul-99 14:24:22 +correlation.html 1209 632 47.7% 31-Jul-99 14:24:22 +covariance.html 7222 2902 59.8% 31-Jul-99 14:24:22 +descstats.html 1585 939 40.7% 31-Jul-99 14:24:24 +deviates.html 2156 1083 49.7% 22-Aug-99 07:39:48 +durbin.html 3253 1524 53.1% 31-Jul-99 14:24:22 +expsmooth.html 5016 2088 58.3% 31-Jul-99 14:24:22 +fisherexact.html 3606 1653 54.1% 31-Jul-99 14:24:22 +fratio.html 1355 741 45.3% 31-Jul-99 14:24:24 +friedman.html 697 408 41.4% 31-Jul-99 14:24:22 +goodfit.html 4473 1927 56.9% 31-Jul-99 14:24:22 +heterogeneity.html 4747 2000 57.8% 31-Jul-99 14:24:22 +histogram.html 2270 2270 0.0% 18-Jul-99 14:28:14 +cumfreqgraph.gif 2212 2212 0.0% 18-Jul-99 14:28:14 +cumpercgraph.gif 3882 3882 0.0% 18-Jul-99 14:28:14 +fisher.gif 1649 1649 0.0% 18-Jul-99 14:28:14 +inputreq.gif 3131 3131 0.0% 18-Jul-99 14:28:14 +leptokurtic.gif 3455 3455 0.0% 18-Jul-99 14:28:16 +negativeskew.gif 3072 3072 0.0% 18-Jul-99 14:28:16 +normaldist.gif 1713 1713 0.0% 18-Jul-99 14:28:16 +outputreq.gif 3163 3163 0.0% 18-Jul-99 14:28:16 +platykurticdist.gif 3458 3458 0.0% 18-Jul-99 14:28:16 +positiveskew.gif 2267 2267 0.0% 18-Jul-99 14:28:16 +sigmoidgraph.gif 5126 5126 0.0% 18-Jul-99 14:28:16 +startmacro.gif 1636 1636 0.0% 18-Jul-99 14:28:16 +t-test1.gif 4370 4370 0.0% 18-Jul-99 14:28:16 +tdist.gif 2799 1266 54.7% 31-Jul-99 14:24:22 +kendall.html 4452 1940 56.4% 31-Jul-99 14:24:22 +kruswall.html 50336 17601 65.0% 31-Jul-99 14:24:22 +main.html 1214 458 62.2% 31-Jul-99 14:24:22 +main.html.info 5856 2265 61.3% 31-Jul-99 14:24:22 +mannwhitney.html 2739 1383 49.5% 31-Jul-99 14:24:22 +movingaverage.html 3319 1627 50.9% 31-Jul-99 14:24:22 +normality.html 3131 1332 57.4% 31-Jul-99 14:24:22 +rankper.html 8825 3504 60.2% 31-Jul-99 14:24:24 +regress.html 3786 1769 53.2% 31-Jul-99 14:24:24 +shannon.html 2228 1128 49.3% 31-Jul-99 14:24:24 +shapiro.html 3093 1402 54.6% 31-Jul-99 14:24:24 +smirnov.html 5429 2141 60.5% 31-Jul-99 14:24:24 +spearman.html 3426 1575 54.0% 31-Jul-99 14:24:24 +ttest1.html 4242 1906 55.0% 31-Jul-99 14:24:24 +ttest2.html 4062 1834 54.8% 31-Jul-99 14:24:24 +ttest3.html 5402 2213 59.0% 31-Jul-99 14:24:24 +wilcoxon.html -------- ------- ----- --------- -------- 915839 384774 57.9% 02-Sep-99 00:01:40 99 files