Question on setting up excell to solve a math problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to solve Y=((1+x)^5)/x with Y known in excell? There is no
way to solve this algabraically that I am aware of.

Thank You,
Frank
 
Maybe using Goal Seek?:

With
B1: 1
A1: =((1+B1)^5)/B1
(Note: at that point A1 returns 32

Fom the Excel main menu:
<tools><goal seek>
Set cell: A1
To value: 1555.2
By changing cell: B1
Click [OK]

Goal Seek returns a solution of: 5

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Another option might be the Newton equation. Taking Ron's excellent
example, we can find the other two real solutions.

'// Given y, solve for x with an initial guess for x.

Function MyFx(y, x)
Dim j
For j = 1 To 20
x = (x * ((3 * x - 2) * (x + 1) ^ 4 + x * y)) / ((x + 1) ^ 4 * (4 * x -
1))
Next j
MyFx = x
End Function

Sub TestIt()
Debug.Print MyFx(1555.2, -5)
Debug.Print MyFx(1555.2, 0.0001)
Debug.Print MyFx(1555.2, 5)
End Sub


Returns the 3 Real solutions:
-7.50826391236509
6.45080740534675E-04
5

--
HTH :>)
Dana DeLouis
Windows XP & Office 2003


Ron Coderre said:
Maybe using Goal Seek?:

With
B1: 1
A1: =((1+B1)^5)/B1
(Note: at that point A1 returns 32

Fom the Excel main menu:
<tools><goal seek>
Set cell: A1
To value: 1555.2
By changing cell: B1
Click [OK]

Goal Seek returns a solution of: 5

Does that help?
***********
Regards,
Ron

XL2002, WinXP


frank c said:
Is there a way to solve Y=((1+x)^5)/x with Y known in excell? There is
no
way to solve this algabraically that I am aware of.

Thank You,
Frank
Click to expand...
Click to expand...
 
Back
Top