Aczel−Sounderpandian:
Complete Business
Statistics, Seventh Edition
Back Matter Index
875
© The McGraw−Hill Companies, 2009
Excel;see also Solver Macro—Cont.
regression, 458–459, 462–463
Sampling analysis tool, 210
sampling distributions and, 209–213
standard distributions and, 133–134
t-test, 340
Excel Analysis Toolpack, 35
Expected net gain from sampling, 730
Expected payoff, 707, 711–712
Expected value of a discrete random
variable, 102–103
Expected value of a function of a random
variable, 103–104
Expected value of a linear composite, 107
Expected value of a linear function of a
random variable, 104
Expected value of perfect information
(EVPI), 728
Expected value of sample mean, 192
Expected value of the sum of random
variables, 107
Experiment, 54
Experimental design, 379, 602
Experimental units, 308, 380
Explained deviation, 439–440
Explained variation, 361, 440
Exploratory data analysis (EDA), 29–33
box plots, 31–33
stem-and-leaf displays, 30–31
EXPONDIST function, 134
Exponential distribution, 130–133
common examples of, 130–131
remarkable property of, 131
template for, 131–132, 134
Exponential model, 524
Exponential smoothing methods, 577–582
model for, 579
template for, 581–582
weighting factor (w), 578–580
Extended Bayes’ Theorem, 77
Extra sum of squares, 543
Extrapolation, 498
F
Fdistribution, 330–333, 351, 444
degrees of freedom of the denominator,
330, 351
degrees of freedom of the numerator,
330, 351
equality of two population variances,
333–334
templates for, 336–337
Fratio, two-way ANOVA, 384
Fstatistic, 363–364
Ftest, 314, 340
multiple regression model, 473–476
partialFtests, 542–544
of regression model, 443–444, 448
Factor, 378
Factorial, 70, 81
Fair games, 103
Fairley, W., 257n
Farley, Amy, 99n
Farzad, R., 43n
Fass, Allison, 234n, 288n
Feller, W., 70, 198, 626
Ferry, John, 29n, 69n
Fialka, John J., 251n
50th percentile, 9
Final outcomes, 704
Firm Leverage and Shareholder Rights
(case
First quartile, 9
Fisher, Anne, 252n
Fisher, Sir Ronald A., 330, 349
Fixed-effects vs. random-effects models, 379
Flight simulators, 30
Fong, Eric A., 465n
Forbes, Malcolm, 3
Forbes, Steve, 701n
Forecasting
Excel/MINITAB in, 588–591
exponential smoothing methods, 577–582
index numbers, 582–587
multiplicative series, 576–577
ratio-to-moving-average method, 569–576
seasonality and cyclical behavior, 566–569
trend analysis, 561–564
Forward selection, 545
Frame, 8, 186
Frequency, 20
Frequency distribution, 183
Frequency polygon, 25–27
Frequentist approach, 687
Friedman test, 396, 645
data layout for, 653
null and alternative hypotheses of, 653
template, 655–656
test statistic, 654
Fulcrum, 11
Full model (F test), 542–543
G
Gagnepain, Philippe, 582n
Galilei, Galileo, 52
Galton, Sir Francis, 409
Gambling models, 52
Ganguly, Ananda, 393n
Garbaix, Xavier, 481n
Gauss, Carl Friedrich, 148
Gauss-Markov theorem, 415
Gaussian distribution, 148
Generalized least squares (GLS), 541
Geometric distribution, 120–121
formulas for, 120
template for, 121
Geometric progression, 120
Gleason, Kimberly C., 466n, 491n
GLS (Generalized least squares), 541
Goal seek command, 116, 123, 166
Goldstein, Matthew, 639n
Gomez, Paulo, 565n
Good, I. J., 51
Goodness-of-fit test, 662
for multinomial distribution, 663–664
Goodstein, Laurie, 6n
Gossett, W. D., 229
Grand mean, 355, 359, 378, 383, 599
Graphs;seeMethods of displaying data
Gray, Patricia B., 253n
Green, Heather, 239n
Grouped data, 20–22
Grover, Ronald, 225n
Gruley, Bryan, 144n
H
Hall, Kenji, 238n
Hammand, S., 26
Hansell, Saul, 288n
Hardesty, David M., 377n
Harris, Elizabeth, 201n, 280n
Harris, Marlys, 280n, 285n
HDP (highest-posterior-density
Hellmich, Nancy, 69n
Helm, Burt, 87n, 189n, 679n
Herbold, Joshua, 393n
Heteroscedasticity, 446, 494, 502, 527
Highest-posterior-density (HPD), 698
Hinges (of box plot
Histogram, 20–22, 25, 36–37, 126–127, 449
Holson, Laura M., 309n
Homogeneity, tests of, 675
Hovanesian, Marader, 44n
HSD (honestly significant differences) test, 373
Huddleston, Patricia, 465n
Hui, Jerome Kueh Swee, 403n
Hypergeometric distribution, 121–124
formulas for, 122–123
problem solving with template,
123–124, 134
schematic for, 122
HYPGEOMDIST function, 134
Hypothesis, 257
Hypothesis testing, 257–300, 303
alternative hypothesis, 257–258, 353–354
ANOVA, 350–354
association between two variables, 658
Band power of test, 264
common types of, 272
computingB,269
concepts of, 260–265
confidence level, 263–264
evidence gathering, 260
Excel/MINITAB for, 298–300
for independence, 670
individual regression slope parameters, 484
Kruskal-Wallis test, 646
796 Index