Schmuller J. Statistical Analysis with Excel For Dummies
Подождите немного. Документ загружается.
479479
Index
unplanned comparisons. See also planned
comparisons
ANCOVA and, 430
carrying out, 232
de ned, 227
Scheffé’s test, 227–228
• V •
#VALUE! error, 47
values
absolute, 108
critical, 173
Descriptive Statistics tool, 138
displaying on Status bar, 139
Excel guessing, 33
expected, 324
ve-number summary, 439
smoothed, 447
types of, 32
typing in, 32
VAR function, 100
VARA function, 100
variability
in graphs, 373
regression line, 371
reporting, 25
variables
categorical, 372–373
de ned, 11
dependent, 11, 12, 57, 256
dichotomous, 301
independent, 11, 12, 57, 222–223, 256
one value, 11
quantitative, 372–373
random, 322–323
relationships, 255
variances
analysis of, 222, 224
between sample means, 221
in covariate, 424
de ned, 95
equal, 195–197, 202
example, 96
formula, 96, 99
from grand mean, 233–234
large, 97
Mean Square, 219
measuring, 93, 94–100
population, 412
population, calculating, 97–98
random variable, 324
residual, 261, 263
sample, 99, 166, 412
small, 97
square root, 100–101
symbol, 96
testing, 181–184
Total, 220, 265
two-factor ANOVA, 244–245, 250
two-factors hypothesis testing, 244–245
unequal, 197, 202
VARP function
de ned, 97
formula, 98
Function Arguments dialog box, 97
working with, 97–98
VARPA function, 98
vertical axis. See also axes
bell curve, 142
de ned, 57
dependent variable, 57
• W •
Weibull distribution, 384
WEIBULL function, 383–384
whiskers. See also box-and-whisker plot
adding, 442
de ned, 438
quartiles becoming, 440
stacked column chart with, 443
wildcard characters, database functions
and, 410
within subjects. See repeated measures
worksheet functions. See also specifi c
functions
arguments, 31–32
categories, 30
for correlation, 300–302
in Excel 2007, 30–33
multiargument capabilities, 32
32 454060-bindex.indd 47932 454060-bindex.indd 479 4/21/09 7:41:39 PM4/21/09 7:41:39 PM
480
Statistical Analysis with Excel For Dummies, 2nd Edition
worksheet functions (continued)
probabilities, 326–329, 383–384
regression, 269–277
steps for using, 30–31
worksheets
as databases, 405–418
names, tracking, 42
Status bar, 138–139
• X •
x-axis. See also horizontal axis
de ned, 57
intercept, 258–259
use of, 256
x-variables. See also independent variables
number of, 283
regression line and, 295
specifying, 287
standard deviation, 267
y-variable relationship, 257
x-y pairs, 257
• Y •
y-axis. See also vertical axis
de ned, 57
intercept, 258–259
use of, 256
y-intercept. See intercept
y-variables. See also dependent variables
de ned, 256
x-variable relationship, 257
• Z •
z-scores. See also scores
auto- lled array, 116
characteristics of, 112
converting scores to, 147
de ned, 112
in exam score example, 113–114
formula, 112
hiding, 115
multiplying by standard error, 164
negative, 115, 164
NORMSDIST function and, 149
NORMSINV function and, 149
positive, 164
STANDARDIZE function and, 114–116
as test statistic, 175, 191
in two-tailed hypothesis testing, 176
z-Test: Two Sample for Means tool
cell ranges, 193
de ned, 48
dialog box, 193
difference, 193
results, 194
use steps, 193–194
variance, 193, 194
z-test formula, 191
ZTEST function
de ned, 177
Function Arguments dialog box, 178
use steps, 178
z-score calculation elimination, 177
32 454060-bindex.indd 48032 454060-bindex.indd 480 4/21/09 7:41:39 PM4/21/09 7:41:39 PM