How can i find an X value given a Y value?

G

Guest

I can use the "forecast" formula to find a Y value given an X, but not the
other way around. please help! thanks
 
D

David Biddulph

Can't you just reverse the order in which you give the second and third
arguments of the FORECAST() function?
In other words, instead of =FORECAST(x,known_y's,known_x's), use
=FORECAST(y,known_x's,known_y's) ?
 
M

Mike Middleton

jmi -

Behind the scenes, FORECAST uses the least-squares method for fitting a
simple linear function.

So, instead of using FORECAST, use the SLOPE and INTERCEPT worksheet
functions.

Since Y = Intercept + Slope*X, a little algebra indicates X = (Y -
Intercept)/Slope.

- Mike
http://www.mikemiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Looking a value up for a 1
Lookup within a 2 dimensional array 5
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
How to forecast non-numerics? 4
Is there a function similar to FORECAST for a power distribution? 1
Array function - I think! 8
Finding Annual Growth Rate 7

Top