Curriculum links
NCEA Mathematics Achievement Standard AS90641
Determine the trend for time series data
Mathematics: Statistics strand – Level 8
Use graphs, moving averages, separation into smooth and rough (with awareness of additive and multiplicative models) to explore time series.
Background
This is a set of three PowerPoint presentations which demonstrate a suggested method for students to analyse and report on time series data for AS90641. The first presentation shows a basic analysis and forecast. The second two give some suggestions for a more comprehensive analysis and report. These PowerPoints may be used with a data show, or made available to students on individual computers or as printed notes. They could be used as a teaching tool or for individual learning or revision by students.
Basic analysis.ppt
Extra for experts.ppt
Reporting.ppt
Datasets from the spreadsheet Example sales.xls are used in the analyses. Basic analysis uses the worksheet called Hardware. Extra for experts, and Reports use the worksheet called Clothing.
A set of sample reports is also provided. The basic one is called Report on hardware sales and the advanced is called Report on clothing sales . These follow the same analysis process as the PowerPoints.
Along with them is the spreadsheet Example sales answers which gives the worked answers and graphs used in the reports. This can also be used to automatically calculate these for any other dataset. There is also a set of other retail sales datasets for extra practice.