Learning ObjectivesConcept Map

after the completion of this module, the student will be able to

  • explain the purpose of calibration
  • find a calibration curve using the Excel function trendline
  • write a macro in Excel
  • explain the meaning of R2
  • explain sources of error when estimating the independent variable value
  • find a confidence interval for the independent variable value

Knowledge and Skills

  • trendline calculation
  • linear regression
  • coefficient of determination
  • calibration


  • linear equation
  • average and standard deviation
  • normal distribution

Curricular Materials