Chemical Forums

Chemistry Forums for Students => Analytical Chemistry Forum => Topic started by: Discosucks on February 17, 2017, 08:18:03 AM

Title: line intercept in excel
Post by: Discosucks on February 17, 2017, 08:18:03 AM

Hey just im trying to do an intercept of the line generated from my data in excel . I have drawn the line in here in red using paint but wish to do it properly in excel .


can anyone shed some light on this for me :)

Title: Re: line intercept in excel
Post by: sjb on February 20, 2017, 06:07:50 AM

I'm not really sure you can easily.

Perhaps look at things like http://www.excelcurvefitting.com/pdfs/curve%20fitting%20best%20practice%20part%203.pdf ?

Title: Re: line intercept in excel
Post by: Irlanur on February 21, 2017, 07:26:39 AM

I would quit Excel sooner rather than later... but that's your decision. (or maybe not).

I can't help you, but the keyword you might want to look for is "interpolation".

Title: Re: line intercept in excel
Post by: Arkcon on February 21, 2017, 09:29:15 PM

I believe Excel can give you the best fit formula to your data points, in any of a number of ways.  Once you have the formula, you can find the exact values for any point on the line.  So I'm left wondering, why you need the intercept.

Title: Re: line intercept in excel
Post by: Yggdrasil on February 22, 2017, 11:05:19 AM

Another option is to numerically calculate the second derivative and find where it crosses zero.