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

Complaints of engine starting by repairing of motorcycle , Complaints of En...

Complaints of Engine Starting: If there is a problem related to the starting of the bike, it can be due to mechanical as well as electrical reasons. The possible reasons could be

Equilibrium of body - force acted at any angle, Equilibrium of body - force...

Equilibrium of body - force acted at any angle: Magnitude of force ' p ' which is required to move the body down the plane. When ' p ' is acted with an angle of φ.

Explain the difference between si and ci engines, Difference between SI and...

Difference between SI and CI engines SI engine stands for spark ignition engine while CI engine stands for compression ignition engine. SI engine works on the principle of w

Locomotive boiler, advantages and disadvantages of locomotive boiler

advantages and disadvantages of locomotive boiler

Concept of temperature - thermodynamics, Concep t of Temperature: The...

Concep t of Temperature: The temperature is thermal state of body which describes the degree of hotness or coldness of body. If the two bodies are brought in contact, heat wi

Electrical system, Electrical System: Electrical system consists of a batt...

Electrical System: Electrical system consists of a battery, spark plug, lighting system, ignition system, charging system and electricity generator. These components of electrical

Clutch-free pedal play -factors in clutch design , Clutch-free Pedal Play :...

Clutch-free Pedal Play : To reduce effective clamping load on the carbon thrust bearing and wear thereof, sufficient clutch free pedal play must be provided in the clutch.

What are the limitations with rectangular combined footings, What are the l...

What are the limitations with rectangular combined footings? In this section the analysis is limited to the determination of plan dimensions of the footing. The physical dimens

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