Statistics Software

Version 3 – October 20, 2005

 

Almost anyone knows statistical software knows that the Cadillac software of this type is SPSS and SAS.  However they have commensurate pricing.  SPSS is $1500 for one seat!

 

There are also alternative software available, depending on exactly what capabilities you may need.

 

 

Free software

 

Excel comes with some statistical capabilities built in.  It also has a not well know FREE add-in called the Analysis Tookpak.  See at bottom of this list for more on this add-in.

 

 

 

 

 

 

Commercial Software

 

StatCalc  - $29 – Standalone windows software – Free trial

http://www.acastat.com/prod01.htm

I found it easy to import an Access table or query via copy-n-paste and retain the column headings.

Very easy to use. 

 

 

AcaStat   - $39 - Standalone windows software – Free trial

http://www.acastat.com/prod07.htm

Very similar to StatCalc

See this link for comparison to StatCalc:  http://www.acastat.com/Compare.htm

I found it easy to import an Access table or query via copy-n-paste and retain the column headings.

Very easy to use. 

 

 

StatPlus    - $50    - Standalone software  - Free 30 day trial

You can also buy a book with the software for about the same price.

http://www.daolnwod.net/soft_6078.html

 

 

 

StatistiXL   -  $75  - Excel add-on    - Free 30 day trial

http://www.statistixl.com/downloads/trybuy.aspx

 

 

AnalyzeIT - $100 – Excel add-in -  30 day free trial

http://www.analyse-it.com/

Per vendor, received high rating from ZDnet (couldn’t access the review)

 

 

 

JMP – Software from a SAS subsidiary –  $995 – Student version approx $80

www.jmp.com

Has student and educational discounts.  Student version is JMP IN.  It is supposed to have all features.

http://www.duxbury.com/statistics_d/special_features/ext/sas/jmpin.com/index.html

 

 

 

Analyze-IT  -   $150   -  Excel Add-on – Free 30 day trial

http://www.analyse-it.com/

Has an impressive customer list.

Received a very good rating from ZDNet (evaluation text no longer available)

 

 

 

Unistat    - $300   - for LITE version; $more for unlimited version - Both Excel add-on and standalone capabilities – Trial uses demo data only

http://www.unistat.com/1541.html

Great testimonials on the vendor site.

 

 

 

StatTools    - $325   - Excel Add-on

http://www.palisade-europe.com/html/stattools.html

 

 

 

XLStatPro   - $395

http://www.xlstat.com/tools.htm

 

 

 

 

StatGraphics    -  $695

http://www.statgraphics.com/

 

 

 

MiniTab  -  $1195

http://www.minitab.com/products/minitab/14/

 

 

 

SPSS - $1500

http://www.spss.com/

One of the class-acts of statistics software.

 

 

 

 

SAS –  Call for pricing 1-800-727-0025 – Expensive!

http://www.sas.com/

Another one of the class-acts of statistics software

 

 

 

Statistics.com  full list of statistics software

http://www.statistics.com/content/commsoft/fulllist.php3

 

 

 

 

 

 

 

 

More Free Software

 

OpenStat4 – FREE

http://www.statpages.org/miller/openstat/

 

 

 

WinIDAMS – FREE – Developed by UNESCO – United Nations Educational, Scientific and Cultural Organization

http://portal.unesco.org/ci/en/ev.php-URL_ID=2070&URL_DO=DO_TOPIC&URL_SECTION=201.html

 

R    - Free

http://www.r-project.org/

R is a language and environment for statistical computing and graphics, similar to the award-winning S system.

 

 

 

MicrOsiris – Free

http://www.microsiris.com/

 

It is derived from OSIRIS IV, a statistical and data management package developed and used at the University of Michigan

 

 

 

 

Statistics.com   List of completely FREE software

http://www.statistics.com/content/freesoft/AZlisting.html

 

 

Free Statistical Software

http://members.aol.com/johnp71/javasta2.html

 

http://freestatistics.altervista.org/stat.php

 

 

 

Another List of Statistical Software

 

The Impoverished Social Scientist's Guide to Free Statistical Software and Resources

 

 

Excel’s Analysis Toolpak

 

Excel comes with a free set of tools called the Excel Analysis Toolpak
    http://www.add-ins.com/Analysis_ToolPak.htm

 

This link also tells how to install it if not already installed.

This professor's web page tells how to use it
    http://www.cba.nau.edu/pinto-j/Commands/GraphsExEq.html#WebMail

You can easily do "descriptive statistics" - mean, median, mode, min, max among others. 

You can also produce "frequency distributions" with or without a graph.  The output shows the counts, and cumulative percentage of the total.  The graph shows both as well.  If you want the groupings of the data to be in specific ranges, you enter those ranges into a column of the spreadsheet and then designate that column as the "bins".

I found it quite easy to use, once it was installed.  Also installation was straightforward and quick.

Descriptive Statistics
Select "Tools", then "Data Analysis". 
Select "Descriptive Statistics".
Simply select the data in the column you want. 
     Click on the first data item (not the label) and drag to the bottom of the data.

Click "OK" and again "OK".  You are done!

By default the result shows in a new "sheet" but you can change that if you wish.


Frequency Distribution

Select "Tools", then "Data Analysis".
Select "Histogram".
Now select "OK"
Simply select the data in the column you want. 
     Click on the first data item (not the label) and drag to the bottom of the data.

If you want a specific set of groupings, called "bins", you need to create them in a column on the spreadsheet.
        This is optional.  If you do want this, create them ahead of time,
        Click in the blank "Bins" field. 
        Highlight the set of groupings you created.
Click on "Chart Output" if you want the chart. 
Click on "OK".  You are done!