Secondary activities
None for this page but see related links.
Curriculum links
NCEA Mathematics Achievement Standard AS90641
- Determine the trend for time series data
Mathematics: Statistics strand – Level 8
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.doc and the advanced is called Report on clothingsales.doc . These follow the same analysis process as the PowerPoints.
Along with them is the spreadsheet Example sales answers.xls 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.
An information page has been provided for teachers and students who wish to know more about the seasonal adjustment process and how this is applied in practice. This can be found in the information section and is called Analysis of time series information.
|