odds, calculating for sports games, 506–507
OFFSET function
for data not in consistent location, 148
defined, 145
dynamic ranges and, 153–155
extracting data into separate cells with, 150–151
and MATCH function, 147
summing multiple data sets with, 149
syntax, 146
one-way analysis of variance. See ANOVA
one-way data tables, 110
defined, 110
setting up, 110–111
optimization models, 217.
See also Excel Solver
changing cells, 218
constraints, 218–219
feasible solutions, 219
target cells, 218
option buttons, 213
option pricing, 521–523
OR formulas, 79
outliers, 289
detecting, 440–441