practical

Using Google Spreadsheet to obtain best-fit line

I am taking the opportunity (since my students are all doing home-based learning) to teach them how to use spreadsheets to do calculations and to obtain a best-fit line. While they can still submit graph work using PDF scanning apps such as Office Lens and Camscanner into Google Classroom for me to mark, they can make use of the spreadsheet-generated graph to check their results.

Even though for exams, we still require them to plot the points on paper and obtain the gradient and intercept from points on the best-fit line, nobody is going to do so when they start working. So I might as well teach them now.

Due to the lack of face-to-face time, I made this step-by-step video showing them how to do so.

Best-fit Line

For lab work, students often have to estimate a line of best fit for their data points manually. It takes a bit of practice to get it right. With this app, students can generate data points with varying types of scatter and predict their own best-fit line before comparing it with a computer generated one based on the least mean square method.