fbpx
  • Clear Filters

  • Select Categories

  • Select Technology

  • Filter by State

  • Filter by Year Level

CP545 Smoothing Time Series

Smooth time series data in a spreadsheet using moving averages, fit a regression line and calculate residuals.

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP440 Histogram Class Intervals

Vary the class intervals when summarising data with a histogram. Also shows use of the randList() command to create a list of random numbers.

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP442 Residuals And Residual Plots

After finding a linear regression model for a bivariate data set, residuals are calculated and plotted to check suitability of linear model.

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP476 Confidence Interval (Prop) From Summary Data

Calculate a confidence interval for a proportion from supplied summary data in the statistics application.

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP500 Spreadsheet Basics

A quick introduction to the common data types – text, number and formula – and some useful spreadsheet tools.

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP502 Fibonacci Sequence

Create the Fibonacci sequence, adjust columns widths, use the Fill Range command to extend the sequence and display very long integers.

Category:
Technology: ,

Year Level: , , , ,
State: , ,