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 a least square geometric curve, Determine a least square geometri...

Determine a least square geometric curve y = ax b to the following data : x:  1   2  3   4   5 y: 0.5  2 4.5 8 12.5 Fit a straight line y = a + bx to the following data b

Describe the slope - area method, Q. Describe the Slope - Area Method? ...

Q. Describe the Slope - Area Method? In the event of infeasibility of Velocity Area method on account of either rapid rise or fall of floods or lack of equipment or any other r

Leaf spring, weight of leaf spring in bus

weight of leaf spring in bus

Bending stress, What is bending stress? The bending moment at section t...

What is bending stress? The bending moment at section tends to bend or deflect beam and internal stresses resist its bending. The process of bending stops when the cross sectio

Particle moving in a circle with a constant angular speed, Which of the sta...

Which of the statements are true for a particle moving in a circle with a constant angular speed? Ans)  The angular speed is how fast the angle changes. So  it measures  A particl

Calculate amplitude of vibration of machine, A machine of mass one tonne is...

A machine of mass one tonne is acted upon by an external force of 3000 N at a frequency of 1500 rpm. To reduce the effects of vibration, isolator of rubber having a static deflecti

Concept of absolute thermodynamic temperature scale, (a) Write short note o...

(a) Write short note on steady flow energy equation and its applications. (b) A heat engine operating between two reservoirs at 1000k and 300k is used to drive a heat pump which

Piping stress analysis, The Mechanical Engineer/Specialist shall be respons...

The Mechanical Engineer/Specialist shall be responsible for coordinating project issues related to stress analysis, as they relate to his/her equipment, with the Stress Engineer/Sp

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