Skip to main content

Best fits to data with Google Sheets

Downloaded: 178

Last edit: 02 June 2023

Resource Type Worksheets and Activities
Curriculum Topic Computational Thinking, Data & Information, Effective use of tools
English Key Stage 7-11 year (KS2), 11-14 year (KS3), 14-16 years (KS4), 16-18 Years (KS5)

Fitting models to data is one of the key techniques in data science, aka statistics.  Free tools, such as Google Sheets, allow younger learners to access such content.  The short pdf shows how to fit the graph of a chosen model such as linear, polynomial, exponential, sine etc to a scatterplot of data in a given column.  

Edit history

Adrian Oldknow | 02.06.23

another image used on bigger scale

Adrian Oldknow | 02.06.23

one last go using a bigger file

Adrian Oldknow | 02.06.23

bigger image replaced

Adrian Oldknow | 02.06.23

I cant seem to make the image

Adrian Oldknow | 02.06.23

a smaller image loaded by me

Adrian Oldknow | 02.06.23

new picture removed by me

Adrian Oldknow | 02.06.23

smaller image

Adrian Oldknow | 02.06.23

Initial creation

Discuss: Best fits to data with Google Sheets (2023-06-01)

Please login to post a comment

Unlock