Data Analysis with Microsoft Excel: Updated for Office 2007

596 Index

Vertical scroll bar, 7
View tab, 9

W
Whiskers, 169
Wilcoxon Signed Rank test,
250–253
command, 571–572
Windows
starting, 2–3
versions of, 2
Winters’ method, 473
Within-groups sum of squares, 400
Workbooks
opening, 10–11
scrolling through, 11–14
Worksheets, 7, 10

cells, 6, 14–17

hidden, 31

X

x axis, 87

adding titles, 95–96

change scale of, 97–99

x charts (x-bar charts), 493

calculating, when standard

deviation is known, 494–495

calculating, when standard

deviation is not

known, 498–500

command, 565

examples of, 495–498, 500–502

false-alarm rate, 494

X^2 distribution, 296

XBAR charts, 565

XY(Scatter) chart, 84

Y

y axis, 87

adding titles, 95–96

change scale of, 99–100

Z

Zoom controls, 7

z test commands, 542–543, 570,

573

z test statistic, 225–228

defi ned, 226

z values, 225–228

defi ned, 226