This laboratory introduces students to graphing experimental
data sets, linear regression analysis, and determining the equation
of the linear fit equation. Several types of data sets are used to
introduce the concepts of using a spreadsheet to analyze data sets
and plot best fit equations for both linear and exponential data,
to select data points that should be eliminated from the fit, to
determine R-squared values for a data set, and to observe the
conditions under which extrapolation is unreliable. Student will
plot data sets, determine the best fit equations, and answer asked
for observations and to draw conclusions based on their
- Introduce the concept of graphical curve fitting.
- Illustrate how to convert data from exponential to linear
- Illustrate how to use the coefficients of the fitted curve to
calculate expected values.
- Compare and analyze the relative significance of dispensing
error and variability in a sample set.