Data Analysis with Microsoft Excel: Updated for Office 2007

Index 591

Database query, 68
Database Query Wizard, 68–71
Databases, importing data from,
68–75
Data format buttons, 42
Data points
identifying, 105–106
labeling, 107–109
selecting data row, 106–107
Data tab, commands, 74
Degrees of freedom, 161, 240
ANOVA and, 401, 422–424
F distribution and, 354
Delimited text, 63
Delimiter, 63
Deming, W. Edwards, 488
Dependent variable, 314
Descriptive statistics
command, 527–529
defi ned, 129
functions, list of, 544–551,
567–569
Develop tab, 9
Diagnostics, 329
Discrete probability distributions,
185–186
Discrete random variables, 189
Discrete variables, 129, 130, 131
Distribution(s). See also Probability
distributions; Sampling
distributions
defi ned, 132
frequency tables and, 131–138
functions, list of, 546–548,
582
normal, 193–196, 331–332
shapes, 141–143
stem and leaf plots, 146–150
Distribution statistics
boxplots, 165–174
means, medians, and mode,
154–158
outliers, 164–165
percentiles and quartiles,
151–154
skewness and kurtosis, measures
of shape, 162–164
variability, measures of,
159–161
Doughnut chart, 84
Durbin-Watson test statistic, 334

E
Editing charts, 91–105
Effects model
defi ned, 406
fi tting, 408–409

Embedded chart objects, 84

Embedding, 11

chart objects, 84, 91

Equality of variance. See variance,

equality of

Error sum of squares (SSE), 400,

401

Estimators, 205–206

Excel, 4

add-ins, 24

charts, 82–85

commands and toolbars, 7–9

elements, 6–7

exiting, 34

launching, 5–6

printing from, 18–22

ribbon, 7

saving, 22–24

Solver, 479–482

starting, 5–6

viewing, 6–7

window, 6–7

Workbooks and Worksheets, 10–17

worksheet functions, 196–205

Exiting, 34

Explore workbooks, 2

Exponential smoothing

calculating smoothed values, 458

choosing parameter values,

455–457

commands, 457, 529–530, 576

forecasting with, 450–451,

455–457, 474–478

Holt’s method, 458

location parameter, 457

one-parameter, 448–457

optimizing, 479–482

recursive equations, 473–474

seasonality, 462–473

smoothing factor/constant, 449,

479–482

three-parameter, 473–478

trend parameter, 458

two-parameter, 457–462

Winters’ method, 473–478

Extreme outlier, 165

F

Faculty, underpaid example,

380–385

False-alarm rate, 494

Fast bubble plot, 560

Fast Scatter plot command, 558

F distribution, 353–355

Fences, 167–168

Fields, 68

Files, installing, 2–3

Fill handle, 38

Filtering/fi lters

adding, 58

Advanced Filter, 56, 59–61

AutoFilter, 56–59

removing, 58

Fitted regression line, 314, 315–316

Fixed-width fi le, 63

Fonts, changing, 41–45

Formats, 41–45

Formatting labels, 109

Formula bar, 7

Formulas

inserting, 46–47

linked, 32

mathematical, list of, 548–549,

583–584

statistical analysis, 550–551,

584–586

tab, 9

trigonometric, 551

F ratio, 327

Frequency tables

bins in, 134–138

command, 567–568

creating, 132–134

defi ned, 132

validity of chi-square test with,

299–302

F test, 258

command, 530–531

Function(s)

arguments, 47

descriptive statistics, 544–546,

567–569

distributions, 546–548, 582

inserting, 47–50

Library, 48

mathematical, 548–549,

583–584

name, 47

statistical analysis, 550–551,

584–586

trigonometric, 551

worksheet, 196–197

G

Generic QC chart, 566

Geometric mean, 156, 157

Goodman-Kruskal Gamma, 299,

306

Gossett, William, 240

Gridlines, 100–102

H

Harmonic mean, 156, 157

Heavy-tailed distribution, 143

Hidden Data sheet, 33