Embedded Files
Analysis of time series graph
Analysis of time series graph
Making predictions
Making predictions
Writing the report
Writing the report
Odd numbered seasons
Odd numbered seasons
(E.g. daily, week days)
Even numbered seasons
Even numbered seasons
(E.g. hourly, quarters, months, weeks in a year)
Individual seasonal effects and average seasonal effects
Individual seasonal effects and average seasonal effects
Written guide to creating the graph
Written guide to creating the graph
Excel Guide WIP.docxExercises
Exercises
Using the examples as above as a guide.
Using the examples as above as a guide.
Download each of the datasets below and create the graph for each in excel
Download each of the datasets below and create the graph for each in excel
Practice One - Supermarket Earnings
Practice One - Supermarket Earnings
This data shows the amount of money taken in each day by a supermarket in October 2005. The figures are in 1000's of dollars.
Click the image to download the dataset.
Practice Two - Library Books
Practice Two - Library Books
This data shows the number of books issued by a library over a four-month period.
Book issues have been recorded in two ways:
number of books issued to staff per day
number of books issued to students per day.
The holiday column is marked with an H for holiday periods and exam breaks.
Click the image to download the dataset.
Practice Three - EFTPOS Transactions
Practice Three - EFTPOS Transactions
This data shows the amount of money charged through electronic card transactions (EFTPOS, Credit, Debit) in millions of dollars in NZ.
The span from September 2004 until December 2008.
Click the image to download the dataset.
Practice Four - Sunglasses Sales
Practice Four - Sunglasses Sales
This data shows the amount of money sepnt nationally in New Zealand on sunglasses in 1000's of dollars.
The span from the quarter ending September 2000 until December 2005.
Click the image to download the dataset.
Page updated
Google Sites
Report abuse