Question about Microsoft EXCEL 2004 for Mac

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

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

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

Use the goal seek or solver in the tools menu

Posted on May 05, 2010

0helpful

1answer

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.

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

0helpful

1answer

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.

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

0helpful

1answer

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!

{ 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

0helpful

1answer

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

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

0helpful

2answers

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.

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

5helpful

2answers

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.

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

0helpful

1answer

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

1helpful

2answers

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]

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

0answers

0answers

8,886 views

Usually answered in minutes!

×