Learning Objectives
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
Prerequisites
- linear equation
- average and standard deviation
- normal distribution