O


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




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net