fbpx
  • Clear Filters
  • Select Categories

  • Select Technology

  • Filter by State

  • Filter by Year Level

CP542 Compound Interest

Create a flexible Compound Interest spreadsheet using Absolute and Relative cell references and format cells to 2dp.


CP410 Statistical Calcs: Two Variables

Calculate two variable statistics from paired data.


CP543 Reducible Interest

Use a spreadsheet to examine the balance of a reducible interest loan.


CP411 Scatterplot and Regression

Create a scatterplot and then calculate and plot the least squares linear regression line through the data.


CP544 Annuities

Use a spreadsheet to examine the balance of an annuity.


CP412 xyLine Time Series

Create an xyLine of time series data.


CP545 Smoothing Time Series

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


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.


CP441 Prediction From Regression Line

Substitute a value into a recently calculated regression line to determine a predicted value.


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.