How to Make an Exponentially-Weighted Moving Average Plot in Excel 2007

I show how you can create a fitted line plot of this time-series model along with a point forecast and a measure of quality of fit (the root mean square error statistic). I used a technique from a chapter called "Smoothing Data" from Professor Marlene A. Smith's free online "Data Analysis Handbook." Here is a link to her chapters: http://carbon.ucdenver.edu/~mas/cours....