April 16, 2024, 04:44:45 PM
Forum Rules: Read This Before Posting


« previous next »
Pages: [1]   Go Down

Topic: line intercept in excel  (Read 2500 times)

0 Members and 1 Guest are viewing this topic.

Offline 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

Offline sjb

  • Global Moderator
  • Sr. Member
  • ***
  • Posts: 3652
  • Mole Snacks: +222/-42
  • Gender: Male
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

Offline 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

Offline 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.

Offline Yggdrasil

  • Retired Staff
  • Sr. Member
  • *
  • Posts: 3215
  • Mole Snacks: +485/-21
  • Gender: Male
  • 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
Pages: [1]   Go Up
« previous next »
Sponsored Links