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