Index

B

bakery example

C

captures, screen

charts

coefficients

creating spreadsheets

cubic spline interpolation adjustment method

custom dates

setting

custom rounding

D

data

adjusting

discontiguous

extracted, (1), (2)

extracting, (1), (2)

extracting results, (1), (2)

historical statistics

screening and adjustment

selecting

data attributes

data screening

data screening options

dates

event

formatting

decomposition, singular value

defining events

deleting events

DES,

detecting outliers

mean and standard deviation method

median and interquartile deviation method (IQD)

median and median absolute deviation method (MAD)

developer kit

deviation, standard

discontiguous data

DMA, . See double moving average

double exponential smoothing. See Holt's double exponential smoothing

double exponential smoothing (DES)

double moving average

Durbin-Watson

description

E

equations

RMSE. See RMSE

errors

events, (1), (2)

highlighting in results

examples

extracted results data, (1), (2)

extracting results data, (1), (2)

F

F statistic

forecasting

time-series, (1), (2)

weighted lead

forecasting guidelines

forecasting methods

ARIMA

double moving average (DMA)

Holt's double exponential. See Holt's double exponential smoothing

Holt-Winters' additive

Holt-Winters' multiplicative

non-seasonal

non-seasonal parameters

seasonal

seasonal additive

seasonal multiplicative

seasonal parameters

single exponential smoothing

single moving average (DMA)

time-series, (1), (2)

forecasting results

forecasting statistics

Theil's U

forecasting techniques, (1), (2)

forecasting time periods

forecasts

pasting, (1), (2)

forward stepwise regression

G

gas tutorial

guidelines

setting up forecasts

H

hardware requirements

highlighting events, seasonality, and screened data

historical data

selecting

statistics

holdout forecasting

Holt-Winters' additive forecasting method

Holt-Winters' multiplicative forecasting method

human resources example

hyperplanes

I

inventory example

iterative stepwise regression

L

lead forecasting

M

MAD

manual

MAPE

mean absolute deviation, . See MAD

mean absolute percentage error, . See MAPE

measures

measures, error

methods

cubic spline interpolation adjustment

data screening and adjustment

forecasting

Holt-Winters' additive forecasting

Holt-Winters' multiplicative forecasting

neighbor interpolation adjustment

non-seasonal forecasting

outlier and missing value adjustment

outlier detection

regression

seasonal additive forecasting

seasonal forecasting

seasonal multiplicative forecasting

standard regression

time-series forecasting, (1), (2)

Methods table, (1), (2)

minimum

missing value adjustment methods

models

moving averages

multiple linear regression, (1), (2)

N

neighbor interpolation adjustment method

non-seasonal forecasting methods

parameters

O

options

ARIMA

setting forecast

organization

manual

outlier adjustment methods

outlier detection

outliers

mean and median absolute deviation detection method (MAD)

mean and standard deviation detection method

median and interquartile deviation method (IQD)

P

parameters

non-seasonal forecasting methods

seasonal forecasting methods

setting

partial F statistic

as stopping criteria

partial F-test, . See partial F statistic

pasting forecast results

pasting forecasts

Predictor

starting

Predictor developer kit

probability (p)

R

R squared

references

regression

detecting autocorrelation

determining coefficients

multiple linear, (1), (2)

regression analysis

regression methods

regression variables

reports

creating, (1), (2)

requirements, system

results

analyzing

multiple linear regression

pasting

reporting

time-series forecast

viewing and analyzing

Results table, (1), (2)

RMSE

description

root mean squared error,

rounding

custom

running

running a forecast

S

screen captures

screened data

highlighting in results

screening criteria

screening data

screening options

seasonal additive forecasting method

seasonal forecasting methods

Holt-Winters' additive

Holt-Winters' multiplicative

parameters

seasonal additive

seasonal multiplicative

seasonal multiplicative forecasting method

seasonality, (1), (2)

autocorrelations

highlighting in results

selecting error measures

selecting forecasting techniques

selecting historical data

selecting regression variables

SES, . See single exponential smoothing

setting event dates

setting forecast options

setting method parameters

shampoo tutorial

simple lead forecasting

single exponential smoothing (SES)

single moving average

singular value decomposition

use

SMA, . See single moving average

software requirements

spreadsheets

creating

titles

SSE

description

standard

forecasting technique

start dates

statistics

sum of square deviations

system requirements

T

t statistic

description

tables

Results and Methods, (1), (2)

techniques

time-series forecasting

Theil's U

description

time periods, (1), (2), (3)

time-series

forecasting overview

time-series accuracy measures

time-series error measures

time-series forecasting

time-series forecasting methods, (1), (2)

time-series forecasting techniques

titles

tutorials

V

variables

selecting regression

viewing charts

viewing screened data

W

weighted lead forecasting

what you need

worksheets, creating