MINITAB Basic Statistics Guide
MINITAB Basic Statistics Guide
Basic Statistics
■ Basic Statistics Overview, 1-2
■ Descriptive Statistics Available for Display or Storage, 1-4
■ Display Descriptive Statistics, 1-6
■ Store Descriptive Statistics, 1-9
■ One-Sample Z-Confidence Interval and Test, 1-10
■ One-Sample t-Confidence Interval and Test, 1-14
■ Two-Sample t-Confidence Interval and Test, 1-17
■ Paired t-Confidence Interval and Test, 1-21
■ Confidence Interval and Test of a Proportion, 1-24
■ Confidence Interval and Test of Two Proportions, 1-28
■ Correlation, 1-32
■ Covariance, 1-36
■ Normality Test, 1-37
Measures of association
■ Correlation calculates the Pearson product moment coefficient of correlation (also
called the correlation coefficient or correlation) for pairs of variables. The
correlation coefficient is a measure of the degree of linear relationship between two
variables. You can obtain a p-value for testing if there is sufficient evidence that the
correlation coefficient is not zero.
By using a combination of MINITAB commands, you can also compute a partial
correlation coefficient which is a case of correlation. A partial correlation coefficient
is the correlation coefficient between two variables while adjusting for the effects of
other variables.
Distribution test
■ Normality Test generates a normal probability plot and performs a hypothesis test
to examine whether or not the observations follow a normal distribution. Some
statistical procedures, such as a z- or t-test, assume that the sample was drawn from a
normal distribution. Use this procedure to test the normality assumption.
Session Graphical
Statistic window summary Store
Number of nonmissing values ✗ ✗ ✗
Total number ✗
Cumulative number ✗
Percent ✗
Cumulative percent ✗
Mean ✗ ✗ ✗
Trimmed mean ✗
Standard deviation ✗ ✗ ✗
Session Graphical
Statistic window summary Store
Confidence interval for σ ✗
Variance ✗ ✗
Sum ✗
Minimum ✗ ✗ ✗
Maximum ✗ ✗ ✗
Range ✗
Median ✗ ✗ ✗
Interquartile range ✗
Sums of squares ✗
Skewness ✗ ✗
Kurtosis ✗ ✗
MSSD ✗
Calculations
Trimmed Mean. To calculate the trimmed mean, MINITAB removes the smallest 5%
and the largest 5% of the values (rounded to the nearest integer), and then averages the
remaining data.
Standard Error of Mean. Calculated by StDev ⁄ N .
Standard Deviation. If the column contains x1, x2, …, xn, with mean x , then
2
standard deviation = Σ( x – x ) ⁄ (n – 1 )
Confidence Interval for σ. The confidence interval for σ is
2 2
( n – 1 )s ( n – 1 )s
------------------------------- to ------------------------
2 2
χ n – 1, 1 – α ⁄ 2 χ n – 1, α ⁄ 2
2
Variance. The standard deviation squared or Σ ( x – x ) ⁄ ( n – 1 ) .
Median. If sample size is odd, the median is the (n+1) / 2th ordered value. If sample
size is even, the median is the mean of the two middle ordered values.
Confidence Interval for Median. Uses one-sample sign confidence interval described
on page 5-3.
Quartiles. To calculate quartiles, MINITAB orders the data from smallest to largest. The
first quartile (Q1) is the observation at position (n + 1) / 4, and the third quartile (Q3) is
the observation at position 3(n + 1) / 4, where n is the number of observations. If the
position is not an integer, interpolation is used.
Sums of Squares. This is the uncorrected sum of squares, or the sum of squared data
values.
Skewness. This is a measure of distribution asymmetry or the tendency of one tail to be
heavier than the other. A negative value indicates skewness to the left and a positive
values indicates skewness to the right, though a value of zero does not necessarily
indicate symmetry. Skewness is calculated as
3 3
n ⁄ ( n – 1 ) ( n–2 ) Σ ( x – x ) ⁄ n
[Link] is a measure of how different a distribution is from the normal
distribution. A negative value typically indicates a distribution with heavier tails than
the normal. A positive value typically indicates a distribution with less heavy tails than
the normal. Kurtosis is calculated as
4 4 2
n ( n + 1 ) ⁄ ( n – 1 ) ( n – 2 ) ( n – 3 )Σ ( x – x ) ⁄ s – 3 ( n – 1 ) ⁄ ( n – 2 ) ( n – 3 )
MSSD. This is half the Mean of Successive Squared Differences. For example, if the
data are 1, 2, 4, 10, successive differences are 1, 2, 6, and the MSSD is
(mean of 12, 22, 62) / 2, or 6.833
Data
The data columns must be numeric. The optional grouping column (also called a By
column) can be numeric, text, or date/time and must be the same length as the data
columns. If you wish to change the order in which text categories are processed from
their default alphabetical order, you can define your own order. See Ordering Text
Categories in the Manipulating Data chapter in MINITAB User’s Guide 1.
MINITAB automatically omits missing data from the calculations.
2 In Variables, enter the column(s) containing the data you want to describe.
3 If you like, use one or more of the options listed below, then click OK.
Options
Tip If you exceed the maximum number of graphs because of the number of levels of your By
variable, you can decrease the number of graphs by unstacking your data and displaying
descriptive statistics for data subsets (see the Manipulating Data chapter in MINITAB User’s
Guide 1).
3 In Variables, enter Height. Check By variable and enter Sex in the text box.
Graph
window
output
Data
The data columns must be numeric. The optional grouping column (also called a By
column) can be numeric, text, or date/time and must be the same length as the data
columns. If you wish to change the order in which text categories are processed from
their default alphabetical order, you can define your own order. See Ordering Text
Categories in the Manipulating Data chapter in MINITAB User’s Guide 1.
MINITAB automatically omits missing data from the calculations.
2 In Variables, enter the column(s) containing the data you want to describe.
3 If you like, use one or more of the options listed below, then click OK.
Options
Data
Enter each sample in a single numeric column. You can generate a hypothesis test or
confidence interval for more than one column at a time.
MINITAB automatically omits missing data from the calculations for that column in
which it is missing.
5 If you like, use one or more of the options listed below, then click OK.
Options
Method
Confidence interval
The confidence interval is calculated as
x – z α ⁄ 2 ( σ ⁄ n ) to x + z α ⁄ 2 ( σ ⁄ n )
where x is the mean of the data, σ is the population standard deviation, n is the sample
size, and zα/2 is the value from the normal table where α is 1 − confidence level / 100.
You can specify a confidence level by entering any number between 1 and 100 in
Level. The confidence level is 95% by default.
Hypothesis test
MINITAB calculates the test statistic by
x–µ
Z = --------------
σ⁄ n
where x is the mean of the data, µ is the hypothesized population mean, σ is the
population standard deviation, and n is the sample size.
When µ is not specified in Test mean, µ = 0 is used. MINITAB performs a two-tailed test
unless you specify a one-tailed test.
4 Click Graphs.
5 If Dotplot of data is checked, uncheck it. Check Histogram of the data. Click OK
twice.
Session Z-Test
window
output Test of mu = 5.0000 vs mu not = 5.0000
The assumed sigma = 0.200
Graph
window
output
Graph
window
output
Data
Enter each sample in a single numeric column. You can generate a hypothesis test or
confidence interval for more than one column at a time.
MINITAB automatically omits missing data from the calculations.
Options
Method
Confidence interval
The confidence interval is calculated as
x – t α ⁄ 2 ( s ⁄ n ) to x + t α ⁄ 2 ( s ⁄ n )
where x is the mean of the data, s is the sample standard deviation, n is the sample
size, and tα/2 is the value from a t-distribution table where α is 1 − confidence level /
100 and degrees of freedom are (n − 1).
You can specify a confidence level by entering any number between 1 and 100 in
Level. The confidence level is 95% by default.
Hypothesis test
MINITAB calculates the test statistic by
x–µ
t = -------------
s⁄ n
where x is the mean of the data, µ is the estimated population mean, s is the sample
standard deviation, and n is the sample size.
When µ is not specified in Test mean, µ = 0 is used. MINITAB performs a two-tailed test
unless you specify a one-tailed test.
Data
Data can be entered in one of two ways:
■ both samples in a single numeric column with another grouping column (called
subscripts) to identify the population. The grouping column may be numeric, text,
or date/time.
■ each sample in a separate numeric column.
The sample sizes do not need to be equal. MINITAB automatically omits missing data
from the calculations.
Options
Method
Confidence interval
The confidence interval is calculated as
( x 1 – x 2 ) – t α ⁄ 2 s to ( x 1 – x 2 ) + t α ⁄ 2 s
where tα/2 is the value from a t-distribution table where α is 1 - confidence level/100.
The sample standard deviation, s, of x 1 − x 2 and the degrees of freedom depend upon
the variance assumption.
You can specify a confidence level of any number between 1 and 100 in Confidence
level. The confidence level is 95% by default.
Hypothesis test
MINITAB calculates the test statistic, t, by
t = ( x 1 − x 2 )/s
The sample standard deviation, s, of x 1 − x 2 depends upon the variance assumption.
Standard deviations
When you assume unequal variances, the sample standard deviation of x 1 − x 2 is
2 2
s1 s2
s = ------
- + ------
-
n 1 n2
where VAR1 = s12/n1, and VAR2 = s22/n2. MINITAB truncates the degrees of freedom to
an integer, if necessary. This is a more conservative approach than rounding.
When you assume equal variances, the pooled sample standard deviation of x 1 − x 2 is
2 2
( n 1 – 1 )s 1 + ( n 2 – 1 )s 2
sp = ------------------------------------------------------------
-
n1 + n2 – 2
Since we previously found no evidence for variances being unequal, we chose to use
the pooled standard deviation by choosing Assume equal variances. The pooled
standard deviation, 2.88, is used to calculate the test statistic and the confidence
intervals.
A second table gives a confidence interval for the difference in population means. For
this example, a 95% confidence interval is (−1.45, 0.98). Next is the hypothesis test
result. The test statistic is −0.38, with p-value of 0.70, and degrees of freedom 88.
Since the p-value is greater than any likely α levels, there is no evidence for a difference
in energy use when using an electric vent damper versus a thermally activated vent
damper.
Data
The data from each sample must be in separate numeric columns of equal length.
Each row contains the paired measurements for an observation. If either measurement
of a row is missing, MINITAB automatically omits that row from the calculations.
4 If you like, use one or more of the options listed below, and click OK.
Options
Method
Confidence interval
For a two-tailed test, the confidence interval is calculated as
d – t α ⁄ 2 ( s d ⁄ n ) to d + t α ⁄ 2 ( s d ⁄ n )
where:
2
sd = ∑ (d – d) -
-------------------------
(n – 1)
You can specify a confidence level of any number between 1 and 100. The confidence
level is 95% by default.
Hypothesis test
MINITAB calculates the test statistic, t, by:
d – µd
t = --------------------
- where µd is the hypothesized difference.
( sd ⁄ n )
3 In First Sample, enter Mat-A. In Second Sample, enter Mat-B. Click OK.
Data
You can have data in two forms: raw or summarized.
Raw data
Enter each sample in a numeric, text, or date/time column in your worksheet.
Columns must be all of the same type. Each column contains both the success and
failure data for that sample. Successes and failures are determined by numeric or
alphabetical order. MINITAB defines the lowest value as the failure; the highest value as
the success. For example:
■ for the numeric column entries of “20” and “40,” observations of 20 are considered
failures; observations of 40 are considered successes.
■ for the text column entries of “alpha” and “omega,” observations of alpha are
considered failures; observations of omega are considered successes. If the data
entries are “red” and “yellow,” observations of red are considered failures;
observations of yellow are considered successes.
You can reverse the definition of success and failure in a text column by applying a
value order—see Ordering Text Categories in the Manipulating Data chapter of
MINITAB User’s Guide 1.
With raw data, you can generate a hypothesis test or confidence interval for more than
one column at a time. When you enter more than one column, MINITAB performs a
separate analysis for each column.
MINITAB omits missing data from the calculations.
Summarized data
Enter the number of trials and one or more values for the number of successes directly
in the 1 Proportion dialog box. When you enter more than one success value, MINITAB
performs a separate analysis for each one.
4 If you like, use one or more of the options listed below, and click OK.
Options
Method
Confidence interval
By default, MINITAB uses an exact method [4] to calculate the confidence interval
limits (pL, pU):
where: where:
ν1 = 2x ν1 = 2(x + 1)
ν2 = 2(n − x +1) ν2 = 2(n − x)
x = number of successes x = number of successes
n = number of trials n = number of trials
F = lower α/2 point of F with ν1 F = upper α/2 point of F with ν1
and ν2 degrees of freedom and ν2 degrees of freedom
where:
p̂ ( 1 – p̂ )
p̂ ± z α ⁄ 2 -------------------- p̂ is the observed probability, p̂ = x / n, where x is the
n observed number of successes in n trials
zα/2 is the value from the z-distribution where α is
1 − confidence level / 100
n is the number of trials
You can specify a confidence level of any number between 1 and 100 in Confidence
level. The confidence level is 95% by default.
Hypothesis test
By default, MINITAB uses an exact method to calculate the test probability. If you
choose to use a normal approximation, MINITAB calculates the test statistic (Z) as:
where:
p̂ – p o
Z = ----------------------------- p̂ is the observed probability, p̂ = x / n, where x is the
po ( 1 – p o ) observed number of successes in n trials
-------------------------
n po is the hypothesized probability
n is the number of trials
4 Click Options.
Data
Data can be in two forms: raw or summarized.
Raw data
Raw data can be entered in two ways: stacked and unstacked.
■ enter both samples in a single column (stacked) with a group column to identify the
population. Columns may be numeric, text, or date/time. Successes and failures are
Summarized data
Enter the number of trials and the number of successes for each sample directly in the
2 Proportions dialog box.
■ If your raw data are unstacked, that is, each sample is in a separate column:
1 Choose Samples in different columns.
2 In First, enter the column containing the first sample.
3 In Second, enter the column containing the other sample.
4 If you like, use one or more of the options listed below, and click OK.
Options
Method
Confidence interval
The confidence interval is calculated as
p̂ 1 ( 1 – p̂ 1 ) p̂ 2 ( 1 – p̂ 2 )
p̂ 1 – p̂ 2 ± z α ⁄ 2 ------------------------
- + -------------------------
n1 n2
where:
p̂ 1 and p̂ 2 are the observed probabilities of sample one and sample two
respectively, p̂ = x / n, where x is the observed success in n trials
zα/2 is the value from a Z-distribution where α is 1 − confidence level / 100
You can specify a confidence level of any number between 1 and 100 in Confidence
level. The confidence level is 95% by default.
Hypothesis test
The calculation of the test statistic, Z, depends on the method used to estimate of p. By
default, MINITAB uses separate estimates of p for each population and calculates Z by:
( p̂ 1 – p̂ 2 ) – d o
Z = -------------------------------------------------------------
-
p̂ 1 ( 1 – p̂ 1 ) p̂ 2 ( 1 – p̂ 2 )
------------------------- + -------------------------
n1 n2
p̂ 1 – p̂ 2
Z = ---------------------------------------------------
-
1
p̂ c ( 1 – p̂ c ) ----- + -----
1
n
1 n2
MINITAB performs a two-tailed test unless you specify a one-tailed test. You can only
use this option when the hypothesized difference is zero (d0 = 0).
3 In First sample, under Trials, enter 50. Under Successes, enter 44.
4 In Second sample, under Trials, enter 50. Under Successes, enter 42. Click OK.
Correlation
You can use the Pearson product moment correlation coefficient to measure the degree
of linear relationship between two variables. The correlation coefficient assumes a
value between −1 and +1. If one variable tends to increase as the other decreases, the
correlation coefficient is negative. Conversely, if the two variables tend to increase
together the correlation coefficient is positive. For a two-tailed test of the correlation:
H0: ρ = 0 versus H1: ρ ≠ 0 where ρ is the correlation between a pair of variables.
Data
Data must be in numeric columns of equal length.
MINITAB omits missing data from calculations using a method that is often called
pairwise deletion. MINITAB omits from the calculations for each column pair only those
rows that contain a missing value for that pair.
If you are calculating correlations between multiple columns at the same time,
pairwise deletion may result in different observations being included in the various
correlations. Although this method is the best for each individual correlation, the
correlation matrix as a whole may not be well behaved (for example, it may not be
positive definite).
3 If you like, use either of the options listed below, then click OK.
Options
■ display the p-value for individual hypothesis tests. This is the default.
■ store the correlation matrix. MINITAB does not display the correlation matrix when
you store the matrix. To display the matrix, choose File ➤ Display Data.
Method
For the two variables x and y,
r = ∑
(x – x)(y – y)
----------------------------------------
( n – 1 )s x s y
where x and sx are the sample mean and standard deviation for the first sample, and y
and sy are the sample mean and standard deviation for the second sample.
Spearman’s ρ
You can obtain Spearman’s ρ (rank correlation coefficient) by ranking both columns
and then calculating the correlation for the columns of ranks. See the Manipulating
Data chapter in MINITAB User’s Guide 1.
Before ranking the data, delete any rows that contain missing values.
1 Regress the first variable on the other variables and store the residuals. See
Regression on page 2-3.
2 Regress the second variable on the other variables and store the residuals.
Covariance
You can calculate the covariance for all pairs of columns. Like the Pearson correlation
coefficient, the covariance is a measure of the relationship between two variables.
However, the covariance has not been standardized, as is done with the correlation
coefficient. The correlation coefficient is standardized by dividing by the standard
deviation of both variables.
Data
Data must be in numeric columns of equal length.
MINITAB omits missing data from calculations using a method that is often called
pairwise deletion. MINITAB omits from the calculations for each column pair only those
rows that contain a missing value for that pair.
If you are calculating covariances between multiple columns at the same time,
pairwise deletion may result in different observations being included in the various
covariances. Although this method is the best for each individual covariance, the
covariance matrix as a whole may not be well behaved (for example, it may not be
positive definite).
3 If you like, use the option listed below, then click OK.
Options
You can store the covariance matrix. MINITAB does not display the covariance matrix
when you store the matrix. To display the matrix, choose File ➤ Display Data.
Method
The covariance between each pair of columns is calculated, using the formula
∑ ( x – x ) ( y – y )-
S xy = ---------------------------------------
n–1
where x is the sample mean for the first sample and y is the sample mean for the
second sample.
Normality Test
Normality test generates a normal probability plot and performs a hypothesis test to
examine whether or not the observations follow a normal distribution. For the
normality test,
H0: data follow a normal distribution vs. H1: data do not follow a normal distribution
Data
You need one numeric column. MINITAB automatically omits missing data from the
calculations.
3 If you like, use one or more of the options listed below, and click OK.
Options
■ mark reference probabilities and corresponding data values on the plot—see
Method on page 1-39
■ perform an Anderson-Darling, Ryan-Joiner, or Kolmogorov-Smirnov test for
normality—see Choosing a normality test below
■ replace the default graph title with your own title
Method
The input data are plotted as the x-values. MINITAB calculates the probability of
occurrence, assuming a normal distribution, and plots the calculated probabilities as
y-values. The grid on the graph resembles the grids found on normal probability paper,
with a log scale for the probabilities. A least-squares line is fit to the plotted points and
drawn on the plot for reference. The line forms an estimate of the cumulative
distribution function for the population from which data are drawn. MINITAB also
displays the sample mean, standard deviation, and sample size on the plot.
When you enter the optional reference probabilities, they are marked with horizontal
references lines. At the point where the reference line intersects the least-squares fit, a
vertical reference line is drawn and labeled with the corresponding data value. To
include reference probabilities on the plot:
In Reference probabilities, enter a column containing the reference probabilities,
which must be values between 0 and 1.
Graph
window
output
References
[1] S.F. Arnold (1990). Mathematical Statistics, Prentice-Hall, pp.383-384.
[2] R.B. D’Augostino and M.A. Stevens, Eds. (1986). Goodness-of-Fit Techniques,
Marcel Dekker.
[3] J.J. Filliben (1975). “The Probability Plot Correlation Coefficient Test for
Normality,” Technometrics, Vol 17, p.111.
[4] N.L. Johnson and S. Kotz (1969). Discrete Distributions, John Wiley & Sons,
pp.58-61.
[5] T.A. Ryan, Jr. and B.L. Joiner (1976). “Normal Probability Plots and Tests for
Normality,” Technical Report, Statistics Department, The Pennsylvania State
University. (Available from Minitab Inc.)
[6] S.S. Shapiro and R.S. Francia (1972). “An Approximate Analysis of Variance Test
for Normality,” Journal of the American Statistical Association, Vol 67, p.215.
[7] S.S. Shapiro and M.B. Wilk. “An Analysis of Variance Test for Normality
(Complete Samples),” Biometrika, Vol 52, p. 591.