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

Autocad help menu-options buttons-coordinate system, AUTOCAD HELP MENU ...

AUTOCAD HELP MENU In this section it will show the Drawing objects its will have some predifined oblects that will help , with some Lectures  notes .It also having options as s

Calculate tension in limbs, Calculate tension in limbs: Q : A horizon...

Calculate tension in limbs: Q : A horizontal drum of belt drive carries the belt over semicircle around it. It is rotated counter clockwise to transmit a torque of 300N-m. If

Determine the maximum permissible eccentricity of the load, Determine the m...

Determine the maximum permissible eccentricity of the load: A small hollow cylindrical column carries a compressive force of 400 kN. The external diameter of the column is 200

Find the tension in each wire, A 54 kg chandelier is suspended 1.5 m below ...

A 54 kg chandelier is suspended 1.5 m below a ceiling by 3 wires, each of which has the similar tension and the similar length of 2.0 m (see the drawing). Find the tension in every

Simple Mechanisms, I have an assignment on kinematic chains.I have to tell ...

I have an assignment on kinematic chains.I have to tell the type of chain whether it is locked,constrained or unconstrained?? I am facing problem in counting number of joints,pair

Supports for rigid bodies, Supports for Rigid Bodies: In this unit, yo...

Supports for Rigid Bodies: In this unit, you have learnt to classify various types of supports and constraints, rollers, rockers, ball and socket joints, cables, short links,

Illustrate all the laws of mechanics, (a) Illustrate all the laws of mechan...

(a) Illustrate all the laws of mechanics? (b) What ate the two limits of limitation on Newtonian mechanic?

Why is stress relieving in post-weld treatment necesaary, In case of welded...

In case of welded vessels why is stress relieving in the form of post-weld treatment necessary? When a metal is welded together the point at which two surfaces are joined are s

Metallurgical defects-gas porosity, Gas Porosity Porosity is the...

Gas Porosity Porosity is the presence of gas pockets or voids caused by the entrapment of gas evolved during weld metal solidification. This Porosity is caused due to im

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