Create a free website, blog, or online store with WebStarts.com
Is this your website? If so, you can prevent this footer from being displayed by upgrading your account. Click here to upgrade now.
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 Add-on for Excel
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
I found it easy to import an Access table or query via copy-n-paste and retain the column headings.
Very easy to use.
StatistiXL - $75 - Excel add-on - Free 30 day trial
AnalyzeIT - $100 Excel add-in - 30 day free trial
Per vendor, received high rating from ZDnet (couldn't access the review)
JMP Software from a SAS subsidiary $995 - Student version approx $80
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
StatGraphics - $695
More Free Software
MicrOsiris Free
It is derived from OSIRIS IV, a statistical and data management package developed and used at the University of Michigan
Free Statistical Software
List of Free Statistics Software
Excel's Analysis Toolpak
Excel comes with a free set of tools called the Excel Analysis Toolpak
Excel Analysis Toolpak
This link also tells how to install it if not already installed.
This professor's web page tells how to use it
How to Use it
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!