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.

X⁴-8x³-x²-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 = X⁴-8x³-x²-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

Pyrolysis-manufacturing methods of ceramics, Pyrolysis Pyrolysis is th...

Pyrolysis Pyrolysis is the procedure of depositing a ceramic on a heated substrate. The process is used to deposit coating or generate thin walled components of graphite or si

Calculation for stress-strain carves, Calculation for Stress-strain carves:...

Calculation for Stress-strain carves: After reaching point D, if bar is strained further, a local reduction in cross section occurs in gauge length (that is, formati

Simple sresses and strains, Derive the formula for maximum instanteneous st...

Derive the formula for maximum instanteneous stress due to impact loading

For elevated temperatures, For Elevated Temperatures, Other Materials ...

For Elevated Temperatures, Other Materials High temperature creep is a significant phenomenon to be guarded in various machines like gas turbines, missiles, reentry vehicles a

Types of brake , Types of Brake The brakes used in motorcycles can be ...

Types of Brake The brakes used in motorcycles can be classified as follows: (a) Drum Brake (b) Disc Brake

Electron beam welding, ELECTRON BEAM WELDING In this process fusion is...

ELECTRON BEAM WELDING In this process fusion is achieved by focusing a high power density beam of electrons on the area to be joined. Upon striking the metal, the kinetic ener

Calculate efficiency of turbine, (a) Explain briefly the functions of the s...

(a) Explain briefly the functions of the spiral casing guide vanes, and draft tube of a reaction water. (b) A Kaplan turbine developing 3250 KW under a head of 6m has a draft tu

Resistant body-mechanism-curvilinear motion-machine, Resistant Body: A bo...

Resistant Body: A body is called resistant body if this is capable of transmitting the needed forces with negligible deformation. Machine: A machine is a mechanism or a se

Slip-on flanges, Slip-On Flanges Slip-on flanges are limited to use und...

Slip-On Flanges Slip-on flanges are limited to use under the following conditions: ASME/ANSI B16.5 standard forged flanges for design pressures and coincident temperatures n

Schedule selection-generation of continuation, Schedule Selection Of th...

Schedule Selection Of the p excellent continuations, q (first) operations are scheduled. This offers p latest partial schedules. After that step 1 is repeated. These steps'

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages