fbpx
  • Clear Filters
  • Select Categories

  • Select Technology

  • Filter by State

  • Filter by Year Level

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.


CP471 Inverse Normal Probability Calculations

Calculate inverse normal probabilities in Statistics using the Calc menu and Inverse Normal CD tool.


CP473 Confidence Interval (Mean) From Summary Data

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


CP476 Confidence Interval (Prop) From Summary Data

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


CP500 Spreadsheet Basics

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


CP501 Arithmetic Sequence

Create a simple sequence and then extend the spreadsheet using Cut and Paste technique.