Mean smoothing time series plots using Excel and Trendline forecasting

Looks at how to smooth out the natural irregular fluctuations we see in real life data to clarify trends using mean-smoothing on Excel. Also delves into trend line forecasting to use the model developed to predict future values. Unit 3 QLD 12 General Maths. Includes practice SF and CF questions with worked solutions.
Copy of Excel spreadsheets to open, save and use yourself:
Lesson objectives:
• Smoothing time series data using moving averages using Excel
• Techniques of odd and even mean-smoothing
• Plotting raw and smoothed time series data onto Excel graphs
• Fitting least squares regression lines to smoothed time series data to use in trend line forecasting using Excel