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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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) ?
 
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
 
You must log in or register to reply here.

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
Is there a function similar to FORECAST for a power distribution? 1
forecast using a four parameter logistic equation 2
Finding the weighted average of text that have been given values 1
How to forecast non-numerics? 4
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1

Back
Top