Back fitter

10 graphs of experimental data are given. Can you use a spreadsheet to find algebraic graphs which match them closely, and thus discover the formulae most likely to govern the underlying processes?

Exploring and noticing Working systematically Conjecturing and generalising Visualising and representing Reasoning, convincing and proving
Being curious Being resourceful Being resilient Being collaborative

Back Fitter printable sheet



Several experiments were performed and data measured over a period of 10 hours.

The resulting charts are shown below.

Can you find algebraic equations which closely match the curves, which could be used to predict values of the variables at other times? There might be many possible curves of the right sort of shape by eye, so a numerical plot will be needed to discover the most likely candidates.

The following Office 2003 spreadsheet will allow you easily to compare plots of the likely curves against the actual data - the intention is that you will tackle this problem numerically.

Note: The different sets of experimental data are distinct, so try as many or as few as you like. Fitting all of the sets will present quite a challenge!



 

Image
Back fitter



 

Image
Back fitter



 

Image
Back fitter



 

Extension: Whilst there are 'obvious' candidates for each data set, can you find multiple functions which give rise to apparently good matches to some of the data sets? How might you numerically determine which fits are best?