Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
Index 595

scatter plots and, 118
seasonality and, 471
setup options, 32–33
Sign test and, 253–255
table statistics, 297–299
t test and, 245–249
Wilcoxon Signed Rank test and,
250–253
Status bar, 7
Stem and leaf plots, 146–150
Command, 559
Stock chart, 84
Straight-line assumption, testing,
329–331
Stuart’s tau-c, 299, 306
Subgroups, 493
Sum of squared errors. See Error
sum of squares
Sum of square for treatment (SST),
400–401, 422
Surface chart, 84
Symbols, bubble, 113
Symmetric distributions, 141


T
Tab group, 7
Tables, 68
commands, 554
computing expected counts,
291–293
frequency, 131–138, 567–568
ordinal variables and, 302–309
other statistics used with,
297–299
Pearson chi-square statistic,
293–297, 299–302
pivot, 276–286
statistics command, 567–569
two-way, 288–291
with ordinal variables, 303–307
X^2 distribution, 296
Tails, distribution, 143
heavy, 143
Tampering, 489
Task bar, 5
t confi dence interval, 243
t distribution
defi ned, 240
for coeffi cients, 362–363
commands, 539–542
construction t confi dence
interval, 243
difference between standard
normal and, 240, 241
robustness 243–244
working with, 242–243
Test statistic, 233


Text fi les, importing data from, 63–68
Text Import Wizard, 63–68
Theoretical probability, 183
Three-parameter exponential
smoothing, 473–478
Time series
analysis commands, 575–577
analyzing change, 436–438
autocorrelation function,
440–445
defi ned, 432
example, 432–440
exponential smoothing,
one-parameter, 448–457
exponential smoothing,
two-parameter, 457–462
exponential smoothing,
three-parameter, 473–478
lagged values, 438–440
moving averages, 445–448
plotting percent change,
437–438
seasonality, 462–473
Title, axis, 94–97
Title bar, 6, 7
Toolbars, 7
Total sum of squares, 400, 422
Treatment sum of squares, 400–401
Trend autocorrelation, 443
Trend parameter, 458
Trigonometric formulas, list of, 551
Trimmed mean, 156, 157
t statistic, working with, 242–243
t test
applied to paired data, 244–250
applied to two-sample data,
259–264
commands, 539–542, 569–570, 572
for coeffi cients, 362–363
Two-Factor with Replication
command, 524
Two-Factor without Replication
command, 525
Two-parameter exponential
smoothing, 457–462
Two-sample tests, commands,
539–542, 572–574
Two-sample t test
applying, to two-sample data,
259–264
commands, 539–542, 572
defi ned, 255
pooled vs. unpooled, 256
working with, 256–257
Two-tailed test, 235
Two-way ANOVA, 410–413
Two-way tables, 288–291
Create command, 554

Type I error, 233
Type II error, 233

U
UCLs. See Upper control limits
Uncontrolled variation, 489–490
Uniform distribution, 215–216
Univariate statistics, 129, 162,
163, 164
command, 569
Unloading
add-ins, 30
modules command, 579
Unpooled two-sample t statistic,
256
Unstack Column command, 555
Upper control limits (UCLs), 490
Utilities, 578–579

V
Values
using calculated, 62–63
observed vs. predicted,
363–366
plotting residuals, vs. predicted,
366–368
Variability, 159
measures of, 159–161
Variable charts, 493
Variables
continuous, 130, 131
correlation matrix, 374–375
defi ned, 129
dependent, 314
descriptive statistics functions,
544–546, 581–582
discrete, 129, 130, 131
independent, 314
indicator, 406–407
nominal, 130, 131
ordinal, 130, 131, 302–309
plotting, 120–123
predictor, 314, 368–369
qualitative or categorical, 130,
131
quantitative, 129, 130, 131
random variables and samples,
189–193
regression equation and, 314–315
tables with ordinal, 302–309
Variance, 161. See also analysis of
variance
equality of, 258–259
homogeneity of, 258
one-way analysis of, 393
Variation, controlled and
uncontrolled, 489–490
Free download pdf