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.

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP543 Reducible Interest

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

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP411 Scatterplot and Regression

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

Category:
Technology: ,

Year Level: , , , ,
State: , ,

CP544 Annuities

Use a spreadsheet to examine the balance of an annuity.

Category:
Technology: ,

Year Level: , , , ,
State: , ,

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: , ,

CP441 Prediction From Regression Line

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

Category:
Technology: ,

Year Level: , , , ,
State: , ,