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

Determine the velocity, Question The three freight cars are rolling alo...

Question The three freight cars are rolling along the horizontal track with the velocities shown in the Figure. After the impacts occur the three cars become coupled together a

Production technology, How is gas cutting torch different from the gas weld...

How is gas cutting torch different from the gas welding torch .explain

Determine the lateral shift-sketch the beams, Transmission Through a LiNb0 ...

Transmission Through a LiNb0 3 Plate Examine the transmission of an unpolarized He-Ne laser beam (λ o = 633 nm) normally incident on a LiNb0 3 plate (ne = 2.29, no = 2.20) of th

#mechanics of materials, What is maximum shear stress in mechanics of mater...

What is maximum shear stress in mechanics of materials ? Derivation for maximum and minimum shear stress seperately.

Crankshaft-basic components of engine , Crankshaft : It converts the recip...

Crankshaft : It converts the reciprocating motion of the piston into useful rotary motion. In the crankshaft of a single cylinder engine, there is a pair of crank arms and balance

Laser surface treatment-transformation hardening, Transformation Hardening ...

Transformation Hardening The main features of the laser as a heat source for transformation hardening are: (A) Clean energy source. (B) Energy is localised: no heat spillage.

Upward compatibilityof iges, Upward Compatibilityof IGES Upward Compati...

Upward Compatibilityof IGES Upward Compatibility : The need for generations of processors to parse files compliant with earlier versions of IGES thwarted the breadth and rate o

Camshaft-basic components of engine , Camshaft : The camshaft controls th...

Camshaft : The camshaft controls the opening and closing of the two valves. The associated parts are push rods, rocker arms and valve springs. The camshaft is driven by a camchai

Balancing, basics of static balancing.

basics of static balancing.

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