Question about Microsoft EXCEL 2004 for Mac

4 Answers

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 iraqtornado on

Ad

4 Answers

Anonymous

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

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

Ad

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
  • 67 Answers

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

Ad

Anonymous

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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.
Thanks & Regards muralikrishna Tadepalligudem

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
  • 1 Answer

Use the goal seek or solver in the tools menu

Posted on May 05, 2010

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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...

2 Answers

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

2 Answers

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

1 Answer

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

2 Answers

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

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

7,943 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...