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

Connected rod - part of combustion engine, Connecte d Rod: It is att...

Connecte d Rod: It is attached to piston at its small end by means of gudgeon pin. The big end bearing is connected to crank pin. It is made up of forged steel.

Explain the single cast component auger, Explain the Single Cast Component ...

Explain the Single Cast Component Auger Material for Single Cast Component Auger: Either Ni-Cr or Cast iron Length of components: 1250 mm. Outer Diameter of Auger compone

Evaluation of specific volume of steam - thermodynamics , Evaluation of Spe...

Evaluation of Specific Volume of Steam: Specific volume of steam means the volume which is occupied by unit mass of steam. It is expressed in m3 /kg. Specific volume of steam

Assignment, AskTask 2 (3 questions) Material engineers should be conversant...

AskTask 2 (3 questions) Material engineers should be conversant of various materials, their properties, manufacturing process involved, environmental issues, monetary issues and mo

Mechanical Design, do the assignment

do the assignment

Explain the uses of residual soils, Explain the uses of Residual soils ...

Explain the uses of Residual soils Residual soils may be underlain by sloping rock which may contain weathered seams. The possibility of foundations sliding on these seams have

Blasting abrasive, Blasting Abrasive: Sand had been use widely before ...

Blasting Abrasive: Sand had been use widely before new abrasive media invented. Today, manufacturer had more choices and better options in choosing blasting media for their ow

Jig and fixture, design summarised of milling fixture

design summarised of milling fixture

Calculate the cycle and production rate , Calculate the Cycle and Productio...

Calculate the Cycle and Production Rate for Single-Machine Robotic Cell Determine the cycle and production rate for a single-machine robotic cell for an 8-hr shift if the syst

Calculate for spring amount of load carried, Calculate for spring amount of...

Calculate for spring amount of load carried: The table below gives specific of a compound spring consisting of two co-axial close-coiled springs. If the spring is subjected to

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages