Determine the two roots of equation , Mechanical Engineering

Assignment Help:

(i) Use the GOAL SEEK tool in MS EXCEL to solve the following equation and determine the TWO roots of this equation between 0 < x < 9.

X⁴-8x³-x²-14x+21=0

(ii). Use the SOLVER tool in MS EXCEL to find the maximum and minimum value of the function in the above range (0 < x < 9).

(iii). Plot the graph of Y = X⁴-8x³-x²-14x+21for the range 0 < x < 9 in the SAME WORKSHEET and CLEARLY SHOW that the values you obtained as roots for part (i) and values for part (ii) are correct.

Related Discussions:- Determine the two roots of equation

Composities, example with its properties

example with its properties

Pin-jointed steel structure, Pin-jointed steel structure: Find out the...

Pin-jointed steel structure: Find out the forces in the members of the pin-jointed steel structure. Solution Joint D Suppose f CD and f DE both as tensile forc

Explain the information phase of radial drilling machine, Information Phase...

Information Phase: Step: To secure all and complete information and gather facts and from best sources. Our project is selected based on the current problem face by the

Forecasting system outputs, Forecasting System Outputs: In a company, ...

Forecasting System Outputs: In a company, inventory level is reviewed biweekly. If the parts used in an assembly have the lead time of one and a half week, what period should

Hardness testing, After final PWHT, the hardness of the deposited weld meta...

After final PWHT, the hardness of the deposited weld metal and heat affected zone (HAZ) shall be examined. Hardness values shall not exceed 200 BHN. Heat treatment shall be perfo

Mechine element and design, what is structure with example

what is structure with example

Basic electrical and electronics book, what are the examples of statically ...

what are the examples of statically induced e.m.f

Impulse- momentum - work and energy, Impulse, Momentum, Work and Energy: ...

Impulse, Momentum, Work and Energy: As a part of summary, you can remember various important principles in terms of following equations. (i) Impulse-Momentum equati

Find the laplace transform, Find the Laplace transform of the following dif...

Find the Laplace transform of the following differential equation: ? +3? +6x = 0, x(0) =0, ?(0)=3 Taking the inverse Laplace transform of X(s), obtain the time solution x(t).

Find out the common velocity, Find out their common velocity: An aerop...

Find out their common velocity: An aeroplane weighing 40 kN horizontally moves with a velocity of 20 m/sec (72 kmph, that means 72 km per hour). A helicopter of weight 20 kN i

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages