Chemical Forums

Please login or register.

Login with username, password and session length

Sponsored links

Pages: [1]   Go Down

Author Topic: line intercept in excel  (Read 401 times)

0 Members and 1 Guest are viewing this topic.

Discosucks

  • Regular Member
  • ***
  • Mole Snacks: +0/-0
  • Offline Offline
  • Posts: 16
line intercept in excel
« on: February 17, 2017, 02: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
  • ***
  • Mole Snacks: +198/-39
  • Offline Offline
  • Gender: Male
  • Posts: 3099
Re: line intercept in excel
« Reply #1 on: February 20, 2017, 12: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
  • *
  • Mole Snacks: +22/-4
  • Offline Offline
  • Posts: 382
Re: line intercept in excel
« Reply #2 on: February 21, 2017, 01: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

  • Global Moderator
  • Sr. Member
  • ***
  • Mole Snacks: +469/-133
  • Offline Offline
  • Posts: 6656
Re: line intercept in excel
« Reply #3 on: February 21, 2017, 03: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
That all depends on how reasonable we're all willing to be.  I just want my friends back, except for Cartman, you can keep him.

Yggdrasil

  • Retired Staff
  • Sr. Member
  • *
  • Mole Snacks: +479/-21
  • Offline Offline
  • Gender: Male
  • Posts: 3181
  • Physical Biochemist
Re: line intercept in excel
« Reply #4 on: February 22, 2017, 05:05:19 AM »

Another option is to numerically calculate the second derivative and find where it crosses zero.
Logged
Pages: [1]   Go Up
 

Mitch Andre Garcia's Chemical Forums 2003-Present.

Page created in 0.084 seconds with 23 queries.