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

Tungsten inclusions, Tungsten Inclusions Tungsten inclusion is a disconti...

Tungsten Inclusions Tungsten inclusion is a discontinuity found only in TIG welding. Particles of tungsten from the electrode can be embedded in a weld when improper welding proc

Steps of engine oil replacement and top-up, Engine Oil Replacement and top ...

Engine Oil Replacement and top up steps • The engine oil should be changed only when motorcycle has run through the prescribed kilometers. • Change the engine oil every 4000 k

Governor, spring combined gravity governor

spring combined gravity governor

Fluid friction, Fluid Friction: Fluid friction manifests when the lubr...

Fluid Friction: Fluid friction manifests when the lubricating fluid is introduced between contact surfaces of the two bodies. If thickness of lubricant or oil between the m

Determine thermal efficiency of the cycle, (a) Compare otto, Diesel and Dua...

(a) Compare otto, Diesel and Dual combustion cycle on the basis of compression ratio, same compression ration and same Heat input and constant maximum pressure and heat supplied.

Monte Calro for aerodynamic load simulation.., I have experimental results ...

I have experimental results for a 2D model and a matlab script that computes the aerodynamic loads on that 2D model.When we compare experiment with the theory I have noted that the

Determine range of diameter of the copper core, A copper-silver bimetallic ...

A copper-silver bimetallic wire, 1 cm in diameter, is prepared by co-extrusion with copper as the core and silver as the outer layer. The desired properties along the axis parallel

Illustrate the process of insulation on pipe, Q. Illustrate the process of ...

Q. Illustrate the process of insulation on pipe? Factory fabricated sectional pipe insulation shall be applied in staggered joint construction and secured with wire loops or ba

Evaluate the velocity ratio, (a) A geometrically similar model of spillway ...

(a) A geometrically similar model of spillway is to be laid to a scale of 1 in 50. Evaluate the velocity ratio, discharge ratio and acceleration ratio. (b) If model prototype ra

Theory of machines, What'' is balancing and vibration in machines Need of ...

What'' is balancing and vibration in machines Need of balancing? Causes of vibration and their harmful effects and remedies?

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