The spreadsheet is a utility tool that can be adapted to many different explorations, presentations, and simulations in mathematics. There are spreadsheets available on almost any platform. An essential feature should be the ability to make graphs and charts from the matrix of data.
a.Take a cup of hot water and measure its initial temperature (time = 0) and then record temperature readings each minute for 30 minutes. Make note of the room temperature . . .
b. Enter the data on a spread sheet and construct a function that will model the data.
c. Using the function predict the temperature after 45 minutes, 60 minutes, or 300 minutes.
d. Calculate a measure of the error between your model and
the observed data by taking the square of the difference for
each time, sum the squares, and divide by the number of data
points. You can use this statistic to guide refinement of your
function to model the data.
The data below are collected by my upward bound students at the Morris Brown College chemistry laboratory.
Below is the graph of the collected data ( red and green ) and the theoretical data ( blue )
Based on the graph obtainded from both data, I can conclude
that the data described an exponentional decay.
Using Ti-83 calculator, I constructed the exponential regression.
Using this equation one can predict the water temperature at any time until the temperature reaches room temperature.