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

Show the vessel internals, Q. Show the vessel internals? Functional des...

Q. Show the vessel internals? Functional design of trays and other removable internals are outside the scope of this document. Removable internals shall be sized to pass thr

Cyclone dip tube length calculation., how can we calcute the length of dip ...

how can we calcute the length of dip tube and what are its effects on cyclone efficiency if we change its length

Introduction to service sector , INTRODUCTION: Service sector, you shall s...

INTRODUCTION: Service sector, you shall study about the growth of service sector followed by the growth of automobile industry, two-wheeler industry and Hero Honda Motors Limited

Moment of Force, How do I solve this question? http://i195.photobucket.com...

How do I solve this question? http://i195.photobucket.com/albums/z154/NanazRulez/20120802_155751.jpg

Design air coolers for plant layout, Q. Design Air Coolers for plant layout...

Q. Design Air Coolers for plant layout? As air coolers (sometimes called aerial coolers, or fin-fans) have extensive heat transfer surfaces, they are more vulnerable to failure

Plate oil separator, Plate oil Separator: Check for plate oil separator fi...

Plate oil Separator: Check for plate oil separator fitment.

Frictionless pulley, Frictionless pulley: The frictionless pulley A ...

Frictionless pulley: The frictionless pulley A is being supported by two bars AB and AC which are hinged at points B and C to a vertical wall. The flexible cable D

Copper alloys, Copper Alloys Some alloys of copper are employed in ind...

Copper Alloys Some alloys of copper are employed in industry for varying causes. Copper forms alloys along with zinc or the brasses, tin or the bronzes, along with tin and pho

Objectives of basic troubleshooting of motorcycle , Objectives After s...

Objectives After studying basics troubleshoot of motorcycle, you should be able to check, perform inspection and identify the reason(s) of various problems reported by

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