Question about Microsoft EXCEL 2004 for Mac

# Using excel to solve problem by trial and error method

HI
I want to solve this equation by excel, any one can help me PLEASE.

Find "d"
5*d^4 - 10.29*d^(-1.333) = 0.124

"d" to the power X
"I hope Trial and Error method "
Thanks for help

Posted by on

### Anonymous

• Level 1:

An expert who has achieved level 1.

Mayor:

An expert whose answer gotÂ voted for 2 times.

• Contributor

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Posted on Jun 16, 2009

### Anonymous

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotÂ 5 achievements.

Governor:

An expert whose answer gotÂ voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

Hello, this is Baris... I think I can help :)

A1 is your power X, so leave it empty.
B1 type the following formula :
=5*(A1^4)-10.29*(A1^(-1.333))-0.124

Fill the following cells accordingly
A1=1
A2=2
A3=3
A4=4
A5=5
A6=6

Then copy B1 to B1 through B6
You will have your values appeared in the B column

Select all the numbers from A1 to B6 and click on insert and click on chart.
On the chart window select "line" chart type and click on next until you get the finish.

That will be your solution graph for this equation.
I hope this helps :)
Good Luck

Posted on May 22, 2009

### Anonymous

• Level 1:

An expert who has achieved level 1.

• Contributor

What is the school rank formula the excel sheet. I begg you send to information as early as urgent. I looked waiting for the you reply.

Posted on Jun 05, 2010

• Anonymous Jun 05, 2010

how the created marks rank and exams rank,post ranks. I need this furmulas

×

### Anonymous

• Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

• Contributor

Use the goal seek or solver in the tools menu

Posted on May 05, 2010

×

my-video-file.mp4

×

## Related Questions:

### I want to solve an complex equation on casio fx-570 ES Plus

Your scientific calculator is unable to solve complex equation with complex coefficients. You should try to solve by hand directly using the quadratic formula or by factoring the polynomial in z
failing that, another way would be to set z=x+iy, substitute this for z, carry out the algebra and try to separate real and imaginary parts. But your two equations will constitute a system of two quadratic equations. I am not aware of any general method to solve coupled nonlinear equations.
Good luck.

Dec 20, 2012 | Casio FX-115ES Scientific Calculator

### The sum of two numbers is 20. the larger of two numbers is four less than thrice the smaller.What are the numbers?

Assume this:
A is the greater number
B is the lesser

You have 2 equations

A + B = 20
A = 3xB - 4

Substitute the solution for the second eqation into the first

(3xB - 4 ) + B = 20

solve for B

3xB + B = 20 + 4
4xB = 24
B = 6

solve for A with solution for B

go back to equation 2

A = 3xB - 4
A = 3x6 - 4
A = 14

So A = 14
and B = 6

Otherwise use trial and error.

Hope that helps.

Jun 29, 2011 | HP 12c Calculator

### 2x -y +z -w = -1 x +3y -2z = -5 3x -2y +4w = 1 -x +y -3z -w = -6 solve for the variables w,x,y,z using matrix equation

You have to put the equations into matrix form first. To do this, each variable has one column in the first matrix and you fill in the co-efficients for the variables. The second matrix has one column and contains all the numbers.

{ 2 -1 1 -1} = Matrix A
{ 1 3 -2 0}
{ 3 -2 0 4}
{-1 -3 -3 -1}

{-1} = Matrix B
{-5}
{ 1}
{-6}

{x=-2} = A*(B^-1)
{y=-.2}
{z=3}
{w=1/6}

I used excel for all my calculation and a helpful tutorial can be found here. I hope this helps and have a nice day!

May 05, 2011 | Computers & Internet

### The product of two 2-digit numbers is 1938. If the product of their unit's digit is 28 and that of their ten's digit is 15, find the numbers.

For solving this type of problem trial and error method is easy.We can solve this problem using trial and error method.

There are two two digits number.Product of their units place is 28,which means only possibility is 7 and 4

Now product of tens place number is 15.Possibility is 3 and 5

so numbers can be 37,54 or 57,34.

By multiplying these numbers we can see that our required solution is 57 and 34

May 21, 2010 | Vivendi [email protected] Mathematics Study Skills...

### How do I solve x and y in the following equations? 5x+3y=6 2x-4y=5 Thank you

You can solve it with following method.

5x+3y=6 2x-4y=5
So 5x=6-3y so 2[(6-3y)/5]-4y=5
So x=(6-3y)/5 so 12-6y-20y=25
so -26y=25-12
so -26y=13
so y= -(1/2)
2x-4y=5
so 2x=5+4y
so 2x=5+4(-1/2)
so 2x=(10-4)/2
so 2x=6/4
so x =3/2

The value of x=3/2 and value of y= -1/2

Let me know if you need further assistance.
Thanks for using FixYa.

Mar 03, 2010 | Office Equipment & Supplies

### If there are 623 students and the ratio of girls is 2 to 3 boys. how many girls are there?

The best way to solve this is to develop one or more equations and then solve for the unknown numbers.

I solved this problem twice using different sets of equations to make sure I was right, and here is what I found:

1) I used the equations x + y = 623, and x = (2/3)y. In these equations, x is the number of girls and y is the number of boys.
Substituting the second equation into the first, I get (2/3)y + y = 623.
Adding the left side together I get : (5/3)y = 623.
Dividing both sides by (5/3) I get 373.8.
This means that x (the number of girls) is 249.2.

2) For the second attempt, I developed the equation: 2x+3x=623. Here 2x is the number of girls, and 3x is the number of boys.
Adding the left side I get: 5x = 623.
Dividing both sides by 5 I get: x = 124.6.
This means that the number of girls (2x) is 249.2. Just like in the first method.

But since you can't have a 1/5 of a girl, the answer must be 249 girls.

Nov 19, 2009 | Office Equipment & Supplies

### Please suggest me how i use the v lookup and h look up

Select a blank cell in workbook. Click the function icon located informula bar("fx"). In the popup Insertwindow Select category as ALL.Select the function you want to get help and click on "help on this function " located in the left down page. You can get all the formula help bu using this method.

Feb 03, 2009 | Microsoft Excel for PC

### How do i make subtraction, additions and divisions using excell

Put the figure which you have to multiply in cell A1, Put the figure in cell A2 by which you have to multiply by, type =A1*A2 in cell A3. You will get the right answer.
You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.

[email protected]

Jul 29, 2008 | Microsoft Excel for PC

7,943 views

Level 3 Expert

Level 3 Expert