Sum of Squares Worksheet Using Cadmium Calibration Data (20
Points) (Individual work required)
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.