Problem
Set 2: Sum of Squares (Individual work required)
I.
Sum of Squares Worksheet Using Cadmium Calibration Data
Using the
data from the cadmiun calibration testing, complete this
spreadsheet as follows:
- Set up a LINEST block and clearly label what
each calculated value represents
- Use the LINEST data to complete the column for
predicted absorbances
- Calculate the residuals
- For each concentration tested, calculate the
mean of the replicates for that concentration
- Calculate the residuals for each data point from
its mean replicate at that concentration
- Calculate the mean of the Absorbance data
- Set up Mean-Centered Absorbance and
Mean-Centered Predicted Absorbance columns
- Calculate each of the following putting the
formula in the designated block:
- Number of Data Points
- Number of Regression Parameters
- Number of Concentrations Used
- Number of Replicate Degress of Freedom (DOF
- Overall Mean Absorbance
- Total Sum of Squares (SS)
- Regression SS
- Coefficient of Determination (Regr SS / Tot SS)
- Residual SS
- Root Mean Square of Residual Error
- Average Percent Error (Use RMS Residual Error
and Overall Absorbance Mean)
- Replicate SS
- Lack of Fit SS
- Mean SS for Lack of Fit
- Mean SS for Replicates
- F Ratio of MSS LOF/MSS Repl
- F Prob.