Hi there,
if I plot a graph with Excel, I can make it do an interpolation, and the graph also shows it's equation: there is a way to calculate that equation starting from the points?
In the attached example, what I'd like to have from the points, without having to plot the graph, it's the equation y = 0.0607x + 5.4587, so that I can input x values and get y's.
I'm using Excel 2007.
I prefer the LINEST() function: https://support.office.com/en-us/art...a-fa7abf772b6d
there are also the SLOPE() (https://support.office.com/en-us/art...a-61d7e01276b9 ) and INTERCEPT() (https://support.office.com/en-us/art...3-3bca70bf63ef ) functions.
Is that what you are looking for?
Originally Posted by shg
Yes, thanks, LINEST works: if I use INDEX(LINEX) I can find the coefficient of the interpolation line, thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks