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

Correction couple, what is correction couple&why it is needed

what is correction couple&why it is needed

Applications, applications of dynamically induced emf

applications of dynamically induced emf

Carnot cycle - thermodynamics, Carnot Cycle - thermodynamics: Carno ...

Carnot Cycle - thermodynamics: Carno t Cycle: Sadi carnot; this is based on second law of thermodynamics introduced the concepts of reversibility and cycle in the year 1824

Thermodynamics, What are significnces of quasi static process

What are significnces of quasi static process

Concept of absolute thermodynamic temperature scale, (a) Write short note o...

(a) Write short note on steady flow energy equation and its applications. (b) A heat engine operating between two reservoirs at 1000k and 300k is used to drive a heat pump which

Mechanical properties of materials, A tensile test on a specimen having an ...

A tensile test on a specimen having an initial diameter of 13.11 mm and an initial gauge length of 200.0 mm, gave the following data:

Coil-fundamentals of electricity , Coil: A coil is used in ignition s...

Coil: A coil is used in ignition system to increase the voltage supplied by the battery or magneto. Coil

Thermodynamics, microscopic and macroscopic view points

microscopic and macroscopic view points

Mechanical efficiency, The following data were obtained from a test on a si...

The following data were obtained from a test on a single cylinder, double acting steam engine fitted with a rope brake. Cylinder diameter 200mm Stroke 250mm Speed 5rev/min Effec

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