How to find the y-values corresponding to new x-values from a graph

1. How to find the y-values corresponding to new x-values from a graph

I have this data, which corresponds to x-values from 0->29.53 (in days) in intervals of 0.01 as shown on the excel spreadsheet attached, on the 1st Sheet. I have the graph plotted in the spreadsheet using scatter with lines of best fit.

Now from the same data/graph, I need to find the Y-values for a new set of x values given in the 2nd sheet of the attachment. Does anyone know a simple way of doing this? The values still go up from 0->29.53 in intervals 0.0035 or so, but be warned they are inconsistent and skip a couple of times every so often. I have checked and seen that people have linearly interpolated, which is effective for a few data points, but as you can see there on my graph multiple trend lines so trend functions and forecast functions won't work either.

If you need more clarity on what it is I need, please don't hesitate to ask. Appreciate all help provided, Thanks in advance!

2. Re: How to find the y-values corresponding to new x-values from a graph

Find the equation of a line given by two nearby points and then linear extrapolate.

Formula:
`Please Login or Register  to view this content.`

Might look complicated formula but principle is easy.
You just need to fin each x1, x2, y1, y2 with INDEX/MATCH combination

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1