WhatStat was designed to assist the user in
the selection of an appropriate statistical
analysis. This is accomnplished via a series
of questions regarding the focus of the
analysis, the number of samples and variables
involved, and how well the data conform to
Responses to these questions will lead the
user to one or more recommendations for
analysis. For most recommendations, a link to
the relevant StatSheet is provided. It is of
course possible, in many cases, to apply
these procedures to data sets for which they
are not appropriate. It is incumbent upon the
user to understand the assumptions and
limitations of any statistical analysis.
WhatStat is not intended as an exhaustive
compilation of statistical procedures.
WhatStat does, however, provide the user
with a broad spectrum of potential approaches
to question pertaining to central tendency,
distribution, variance, and correlation.
StatSheets are Excel templates for completing
various statistical analyses. Each sheet
provides a brief description of the analysis,
instructions for its use, and any limitations
regarding the number of samples or sample size
that may apply.
Computations for these analyses are drawn
heavily from Biometry (Sokal & Rohlf, 1995),
Introduction to Linear Regression Analyses
(Montgomery & Peck, 1982), Applied
Nonparametric Statistics (Daniel, 1978), and
Biostatistical Analyses (Zar, 1974).
In most cases, all that is required is to enter data
into the worksheet and review the results of the
analysis. It is, of course, the responsibility of the
user to properly interpret these results in terms
of the original hypotheses.
StatSheets were created without macros to
minimize security concerns. I recommend that
you save any downloaded StatSheets as
templates for future use. If you wish to save a
specific analysis you should re-name the file.
(StatsSheets were created with Excel 2007 and may
not work properly with earlier versions.)