Looking a way to solve this equation

[aaronchan322]

Dear all,

Feel thankful to find this forum.

I'm not an excel expert, nor a math expert.
But recently I have to find the X value with this equation:
Y = 0.0000302307X^6 - 0.0017620175X^5 + 0.0376232469X^4 - 0.3880372117X^3 + 2.3962783035X^2 - 3.6979108034X + 1.4580209629
I have a series of Y value already.
But since I only know how to solve a formula when Y is on the right hand side,
I have no ways to solve my X value now.

What should I do with excel according to get my X value?

Thanks
Aaron Chan

 

[Legacy 143009]

Dear all,

Feel thankful to find this forum.

I'm not an excel expert, nor a math expert.
But recently I have to find the X value with this equation:
Y = 0.0000302307X^6 - 0.0017620175X^5 + 0.0376232469X^4 - 0.3880372117X^3 + 2.3962783035X^2 - 3.6979108034X + 1.4580209629
I have a series of Y value already.
But since I only know how to solve a formula when Y is on the right hand side,
I have no ways to solve my X value now.

What should I do with excel according to get my X value?

Thanks
Aaron Chan

Ok it needs a few steps. First of all correct your notation. Paste the following to B1:

=(0.0000302307*(A1^6)) - (0.0017620175*(A1^5)) + (0.0376232469*(A1^4)) - (0.3880372117*(A1^3)) + (2.3962783035*(A1^2)) - (3.6979108034*A1) + 1.4580209629

Then go to Data tab and find Solver->Goal Seek.

Set cell: B1
To value: Your Y value
By changing cell: A1

You have to do this one by one for each Y value or use VBA.

 

[aaronchan322]

Ok it needs a few steps. First of all correct your notation. Paste the following to B1:

=(0.0000302307*(A1^6)) - (0.0017620175*(A1^5)) + (0.0376232469*(A1^4)) - (0.3880372117*(A1^3)) + (2.3962783035*(A1^2)) - (3.6979108034*A1) + 1.4580209629

Then go to Data tab and find Solver->Goal Seek.

Set cell: B1
To value: Your Y value
By changing cell: A1

You have to do this one by one for each Y value or use VBA.

Thank you very much Flashbond!
It works!

aaron