Predictive Analytics: Microsoft® Excel

Index

accessing

Data Analysis add-in, 54-56

Solver, 99

ACFs (autocorrelation functions), 139-141

ARIMA workbook, 147-148

adjusting autocorrelation formula, 139-140

alpha, 84, 88-89

Holt’s linear exponential smoothing, 118-119

selecting, 96-108

analysis sheets (collector), 28-33

dynamic range name, defining, 29-30

analytics, 7, 36

analyzing composite variable for multiple regression, 48-50

ANOVA (Analysis of Variance), 61-62

antilogs, 182-183

applications, R, 193-198

applying dynamic range name to pivot table, 30-33

AR process, identifying, 244-248

ARIMA (AutoRegressive Integrated Moving Average), 241-244

diagnostic and forecasting stages, 264-265

differencing, 249-251

estimation stage, 257-264

exponential smoothing, 261-263

identification stage, ...

Get Predictive Analytics: Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.