Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
Excel Reference 569

Univariate Statistics


The StatPlus>Descriptive Statistics>Univariate Statistics command cre-
ates a table of univariate statistics. The user can choose from a selection of
33 different statistics, either by selecting the statistics individually, or se-
lecting entire groups of statistics. Statistics can be displayed in different
columns or in different rows. The table can be broken down using a By
variable.

One Sample Tests

One Sample t-test


The StatPlus>One Sample Tests>1 Sample t-test command performs a
one-sample t-test and calculates a confi dence interval. The data values can
be arranged either as a single column or as two columns (in which case
the command will analyze the paired difference between the columns). If
two columns are used, the columns must have the same number of rows.
Users can specify the null and alternative hypotheses as well as the size of
the confi dence interval. The output can be broken down by the levels of a
By variable.
Free download pdf