M


machine lifetime, modeling. See Weibull random variable

MATCH function

defined, 23

finding highest value with, 25–26

lookup range for, specifying ascending or descending, 23

and OFFSET function, 147

payback period calculation with, 27–28

returning sales for specific month with, 25

syntax, 23–24

when to use, 23

matching text in lists, identifying, 576

MAX function, 25

mean, 287

comparing between data sets. See ANOVA

vs. median, as measure of central location, 287

of random variables, 446

trimmed, 292–293

median vs. mean, as measure of central location, 287

Microsoft Word documents

importing, 259–263

saving as text, 260

MID function, 30

MINUTE function, 94.

See also times

MIRR (modified internal rate of return), 54–55

MOD function, 85

mode, 287

modified internal rate of return (MIRR), 54–55

Monte Carlo simulation

defined, 475

demonstration of, 479–482

name origin, 475

risk and, 482

scenario creation with, 128

uses for, 475–476

month formats. See date formats

months, sorting in chronological order, 190

mortgages. See loans

moving average graphs, 427–428

moving-average trading rules, tracking performance of, 76–79

multiple regression, 389–392

coefficient interpretation, 399

dummy variables. See dummy variables

for predicting auto sales, 395–399

for presidential election predictions, 400–403

qualitative independent variables, 396

significance, 399

multiplying numbers when pasting, 99–101




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