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:
     

    1. Set up a LINEST block and clearly label what each calculated value represents
    2. Use the LINEST data to complete the column for predicted absorbances
    3. Calculate the residuals
    4. For each concentration tested, calculate the mean of the replicates for that concentration
    5. Calculate the residuals for each data point from its mean replicate at that concentration
    6. Calculate the mean of the Absorbance data
    7. Set up Mean-Centered Absorbance and Mean-Centered Predicted Absorbance columns
    8. 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.