Chemical Forums
1 Hour
1 Day
1 Week
1 Month
Forever
April 19, 2024, 09:52:11 AM
Forum Rules
: Read This Before Posting
Home
Help
Search
Login
Register
Chemical Forums
Chemistry Forums for Students
Analytical Chemistry Forum
line intercept in excel
« previous
next »
Print
Pages: [
1
]
Go Down
Topic: line intercept in excel (Read 2504 times)
0 Members and 1 Guest are viewing this topic.
Discosucks
Regular Member
Posts: 16
Mole Snacks: +0/-0
line intercept in excel
«
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
Logged
sjb
Global Moderator
Sr. Member
Posts: 3652
Mole Snacks: +222/-42
Gender:
Re: line intercept in excel
«
Reply #1 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
?
Logged
Irlanur
Chemist
Full Member
Posts: 423
Mole Snacks: +32/-4
Re: line intercept in excel
«
Reply #2 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".
Logged
Arkcon
Retired Staff
Sr. Member
Posts: 7367
Mole Snacks: +533/-147
Re: line intercept in excel
«
Reply #3 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.
Logged
Hey, I'm not judging. I just like to shoot straight. I'm a man of science.
Yggdrasil
Retired Staff
Sr. Member
Posts: 3215
Mole Snacks: +485/-21
Gender:
Physical Biochemist
Re: line intercept in excel
«
Reply #4 on:
February 22, 2017, 11:05:19 AM »
Another option is to numerically calculate the second derivative and find where it crosses zero.
Logged
Print
Pages: [
1
]
Go Up
« previous
next »
Sponsored Links
Chemical Forums
Chemistry Forums for Students
Analytical Chemistry Forum
line intercept in excel