Im setting up a calibration graph for an analytical method and need to work out a linear regression calculation so that I can calculate the concentration of an unknown.
I have two columns within the calibration graph and want to have a separate area where I input a value and the concentration is calculated from the linear regression equation. Ive got the equation onto a chart and know I need to use the TREND function. I have looked at the excel explanation but dont really understand it. Can someone explain it simply? and how I need to set up my data entry? thanks
Bookmarks