Nayland College

Nayland College - Mathematics

Home . Year 9 . Year 10 . Level 1 . Level 2 . L3 Statistics . L3 Maths . L3 Calculus . About . Links

NZAMT NZQA NZ Grapher NZ Maths Census at School Study It

3.8 Time Series HOME | Achievement Objectives | Overview | The Statistics Cycle
NZ Grapher: The best choice | iNZight: Getting Started , Importing Data
Using EXCEL: Smoothing, Trend, Seasonal Effects, Graphing, Forecasts, Seasonal Adjustment, Non-Linear models, Comparing Excel & iNZight
Report Writing: Summary | Introduction | Trend | Decompose | Recompose | Seasonal Effect | Forecasts | Robustness | Additive vs Multiplicative model | Comparing | Combining | Conclusion | Practice Assessment

Comparing Variables

9

 

Compare multiple variables

Comparing Series (Auckland Uni)

(Excellence)
Investigate links between variables by comparing them. Thoughtful choice of variables to compare is needed to add to your report.

What are similarities and differences in trends and seasonal components between the variables.

Discuss what you notice about the comparative data series - similarities, differences, possible relationships, reasons, causes, links etc

 

 

Starter 8

word docs Class notespdf

EXEMPLARS:
Use iNZight to produce a time series graph and add the trend line. Copy this into your report and discuss

- Alcohol Consumptn: Data csv,| Word Worksheet | Google Doc class write up

- Travel Destination Data csv | Word Write up | Google Doc class work

- Travel Purposes: Data csv

- Electricity Production: Data csv | (Website)

 

 

Comparing variables over the same time period

Input the data as per normal

Hold down CTRL to select multiple data variables

then Compare Series using the 'Single-Plot' and 'Multi-Plot'

Discuss & compare in context

For each variable a Raw data graph with smoothed trend line, and seasonal effects are graphed with the same time.

The raw data graph also has 'trend + seasonal' (the hard to see green line) This shows what data values may be above or below average, and by how much.

Discuss what you notice about the comparative data series - similarities, differences, possible relationships, reasons, causes, links etc

Discuss and compare the Trend Lines.

Discuss and compare the Estimated Seasonal Effects (red line) and the Individual Seasonal Effects for each cycle (gray lines)

 

How would visitor numbers to NZ compare between European countries?

 

How would visitor numbers to NZ compare between Asian countries?

 

How would visitor numbers to NZ compare between Europe and Asia?

 

How would visitor numbers to NZ compare between USA & Canada?

 

back to top