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


--
scarlett1
------------------------------------------------------------------------
scarlett1's Profile: http://www.excelforum.com/member.php...o&userid=17495
View this thread: http://www.excelforum.com/showthread...hreadid=545672