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.

X4-8x3-x2-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 = X4-8x3-x2-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

Lami theorem - mechanics, Explain lami's theorem: Sol.: Lami's theore...

Explain lami's theorem: Sol.: Lami's theorem states that "If the three coplanar forces which are acting at a point be in equilibrium, then every force is proportional to sin

Polymer, classification of polymers

classification of polymers

Design a control chart and control limit for the process, a) Describe Quali...

a) Describe Quality. What are various quality measures. b) A steel chairs manufacturer is also the quality inspector in his manufacturing unit this parameter of a chair being de

Throttle valve-components of a carburettor , Throttle Valve: The throttle...

Throttle Valve: The throttle valves control the quantity of mixture supplied to the cylinder. This is controlled by throttle grip with the help of a cable. When we open throttle

Thyristor fundamentals of electricity , Thyristor: The thyristor is just l...

Thyristor: The thyristor is just like an ordinary diode. Thyristor

Identification of defects of coating, Q. Identification of Defects of coati...

Q. Identification of Defects of coating? All holidays and other coating defects, including without limitation primer blister, excess powder mounds, crazed coating, lifted and u

Briefly explain model scale design, Q. Briefly explain Model scale design? ...

Q. Briefly explain Model scale design? Knowledge of dynamic similarity conditions enables evaluation of model scales. Almost alI the problems related to river hydraulics are ab

Closed, Closed, open and isolated system-Thermodynamics system: Sol: ...

Closed, open and isolated system-Thermodynamics system: Sol: In thermodynamics the system can be defined as the quantity of matter or region in space upon which attention is

Condenser capacitor electricity , Condenser ( Capacitor ) : A capacitor i...

Condenser ( Capacitor ) : A capacitor is used to store the electrical energy. The maximum value of stored energy depends on its capacity. It helps to achieve required high voltag

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd