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

Brakes drag motorcycle problem, If Brakes Drag Causes of P...

If Brakes Drag Causes of Problem Remedy   Insufficient pedal free play Recommended brake fluid not used

Flux cored arc welding, Flux Cored Arc Welding Single Pass F illet Weld...

Flux Cored Arc Welding Single Pass F illet Welds upto (8.0 mm) maximum and groove welds made with a single pass or a single pass each side, may be made using an E70T-X electrod

Welding procedure specification (wps), WELDING PROCEDURE SPECIFICATION (WPS...

WELDING PROCEDURE SPECIFICATION (WPS)   The purpose of Welding Procedure Specification (WPS) and Procedure Qualification Record (PQR) is to determine that weldment proposed

Engineering Mechanics, What are the practical applications of solid cylinde...

What are the practical applications of solid cylinder or shaft under cyclic axial loading

Define myocardial oxygen uptake, Q. What do you understand by Myocardial Ox...

Q. What do you understand by Myocardial Oxygen Uptake? VO 2 max = Maximum C.O x Maximum A-V Oxygen difference. It is the maximum amount of oxygen that the person can use du

Mig / co2 welding, MIG / CO 2 WELDING In MIG / CO 2 welding the feed...

MIG / CO 2 WELDING In MIG / CO 2 welding the feeding of filler wire is machanised. If the welder moves the MIG / CO 2 torch the process is called semi automatic MIG / CO 2

#clutches, #constructional features and working of Multiplate Dry Clutch

#constructional features and working of Multiplate Dry Clutch

Plasma welding, PLASMA WELDING This is an extension of TIG welding. In...

PLASMA WELDING This is an extension of TIG welding. In plasma welding torch, plasma energy is constricated and ensures its most efficient utilisation for welding cutting and s

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