589
Index
A
About StatPlus command, 33
Absolute reference, 50
Acceptance region, 234–235
ACF. See Autocorrelation function
Active cell, 6
Add-ins, 24–28. See also Analysis
ToolPak add-ins
tab, 9
unloading, 30
Additive seasonality, 464
Advanced Filter, 56, 59–61
Alternative hypothesis [Ha], 233
Analysis of variance (ANOVA)
Bonferroni correction factor,
403–404
cells in, 411
comparing means, 402–404
computing, 397–399
effects model, 406, 408–409, 411
examples of, 393–401, 413
Excel used to perform two-way,
419–422
graphing data to verify, 395–397,
414–417
indicator variables, 406–407
interaction plot, 417–419
interpreting, 326–327, 399–401,
422–424
means model, 393, 406, 409
one-way, 393, 406–409
overparametrized model, 406
regression analysis and, 325,
326–327, 406–409
replicates, 410
single-factor, 523
two-factor with replication, 524
two-factor without replication, 525
two-way, 410–413
Analysis ToolPak/Data Analysis
ToolPak, 24
ANOVA two-way and, 419–422
checking availability of, 522
correlation matrix and, 343
descriptive statistics and, 154
effects model and, 406
exponential smoothing, one-
parameter command, 457
frequency tables and, 134
histograms and, 138
loading, 28–29
moving average command, 448
percentiles and, 154
random normal data and, 199
regression analysis and, 323–325,
357
t test and, 248
unloading, 30
Analysis ToolPak add-ins
ANOVA, single-factor command,
523
ANOVA, two-factor with
replication command, 524
ANOVA, two-factor without
replication command, 525
correlation command, 526
covariance command, 527
descriptive statistics command,
527–529
exponential smoothing command,
457, 529–530
F test command, 530–531
histogram command, 531–532
moving average command,
532–533
output options, 522–523
random number generation
command, 533–534
rank and percentile command,
535
regression command, 535–537
sampling command, 537–538
t test command, 539–542
z test command, 542–543
ANOVA. See Analysis of variance
Area chart, 83
Arguments, 47
Attribute charts, 493
Autocorrelation function (ACF)
applications of, 441–443,
444–445
computing, 441–445constant variance and, 441
formulas, 440–441
patterns of, 443–444
plot command, 575
random walk model, 444
role of, 440–441
seasonality and use of, 470–471
Autofi ll, entering data with, 37–39
AutoFilter, 56–59
Average. See Mean
Axes, editing, 97–100
Axis titles
working with, 94–97B
Balanced data, 419
Bar charts, 84. See also Histograms
displaying categorical data in,
283–285
Bartlett’s test, 258
Bernoulli distribution, 218
Between-groups sum of squares,
400
Big Ten workbook example, 86
Bin(s)
counting with, 134–135
in frequency tables, 134–136
values, defi ning, 136–138
Binomial distribution, 218
Bivariate density function, 192
Bivariate Normal command, 552
Bonferroni
correction factor, 403–404
p values with, 342–343
Boxplots
command, 557–558
comparing means with, 405–406
creating, 171–174
defi ned, 166
fences, 167–168
interquartile, 167
outliers, 168
seasonality and use of, 467–468
whiskers, 169
working with, 165–174