Create an xyLine of time series data.
Vary the class intervals when summarising data with a histogram. Also shows use of the randList() command to create a list of random numbers.
Substitute a value into a recently calculated regression line to determine a predicted value.
After finding a linear regression model for a bivariate data set, residuals are calculated and plotted to check suitability of linear model.
Create a geometric sequence including the sum of terms and extend using Tap and Drag technique.
Create a pie chart, determine the percentages represented by each sector and dynamically modify.
Create a flexible Simple Interest spreadsheet using Absolute and Relative cell references and extend by copying and pasting multiple columns.
Create a flexible Compound Interest spreadsheet using Absolute and Relative cell references and format cells to 2dp.
Use a spreadsheet to examine the balance of a reducible interest loan.