Forecast Archives - Dawn Wright, Ph.D.

Use Excel to Calculate MAD, MSE, RMSE & MAPE

by Dawn Wright
February 26, 2016August 23, 2021
11 Comments

To optimize your forecast, whether moving average, exponential smoothing or another form of a forecast, you need to calculate and evaluate MAD, MSE, RMSE, and MAPE. With Excel 2016 or later, this is easy to… Use Excel to Calculate MAD, MSE, RMSE & MAPE

What’s so difficult about confidence intervals

by Dawn Wright
February 21, 2015February 26, 2016

Interpretation of Confidence Interval

I admit that it is almost common usage to say that a parameter of interest lies in the confidence interval we construct around a sample statistic, so I won’t count off for that answer. But the most accurate meaning of the confidence interval is thatWhat’s so difficult about confidence intervals