mrmmickle1
Well-known Member
- Joined
- May 11, 2012
- Messages
- 2,461
It's been a while since I have had to use Goal Seek or Scenario Manager... I have an equation in which I need to solve for X. I know the value of Y. Can someone please show me how I can get the Value of X?
The equation is:
<tbody>
</tbody>
So if I had for Example:
Y = 1.86
B0 = 1.134
B1 = .294
B2 = 0.005607
B3 = -0.000001183
Then I would want to solve for X in this equation: 1.86 = 1.134 + .294*X + .005607*X*X + -0.000001183*X*X*X
Here is the spreadsheet example. The Below Portion that says Plug in Y = X are examples in a software program I have that does this calculation.
I would like to be able to "reverse engineer" this process.... so I can use the formula myself in Excel. Can someone please help me to arrive at my solution? It may be possible with the LINEST() FUNCTION... Not sure how to use it though.
I will always have the Values: Y, B0,B1,B2 & B3
Any help with my issue would be much appreciated.
The equation is:
Y=B0 + B1*X + B2*X*X + B3*X*X*X |
<tbody>
</tbody>
So if I had for Example:
Y = 1.86
B0 = 1.134
B1 = .294
B2 = 0.005607
B3 = -0.000001183
Then I would want to solve for X in this equation: 1.86 = 1.134 + .294*X + .005607*X*X + -0.000001183*X*X*X
Here is the spreadsheet example. The Below Portion that says Plug in Y = X are examples in a software program I have that does this calculation.
I would like to be able to "reverse engineer" this process.... so I can use the formula myself in Excel. Can someone please help me to arrive at my solution? It may be possible with the LINEST() FUNCTION... Not sure how to use it though.
I will always have the Values: Y, B0,B1,B2 & B3
Excel 2012 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Y=B0 + B1*X +B2*X*X + B3*X*X*X | y | x | ||||
2 | B0 | 1.134 | 1.86 | ||||
3 | B1 | 0.294 | 1.134 | ||||
4 | B2 | 0.005607 | |||||
5 | B3 | -0.000001183 | |||||
6 | |||||||
7 | Plug In Y = X | ||||||
8 | Y | X | |||||
9 | 1.86 | 2.363 | |||||
10 | 2.79 | 5.131 | |||||
11 | 3.14 | 6.11 | |||||
FORMULA_EXAMPLE |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E3 | =B2+(B3*E2)+(B4*(E2)^2)+(B5*(E2)^3) |
Any help with my issue would be much appreciated.