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

Principal design criterion of plant layout, Q. Principal design criterion o...

Q. Principal design criterion of Plant layout? Safety-in-Design is a key factor associated with the layout design of any facility. The principal design criterion is to minimize

Determine wheel diameters at the pitch circle of blades, A pelton wheel wor...

A pelton wheel works at the foot of a dam because of which the head available at the nozzle is 220m. the nozzle diameter is 20 c.m. and coefficient of speed 0.98. The wheel operate

Expression for strain energy, Expression for strain energy: Derive an...

Expression for strain energy: Derive an expression for strain energy because of torsion.                                          Sol.: The work done in straining shaf

Stresses and strains, The round tensile specimen given  below has a diamete...

The round tensile specimen given  below has a diameter of 0.5 in. A load, F, is applied and the deflection, g , is calculated. Given the following                    d = 0.5 in

[email protected], how i can know moulair plant calculation?

how i can know moulair plant calculation?

Order sequences and order release, Order Sequences and Order Release Fo...

Order Sequences and Order Release For this system, sequences of orders for particular parts (batch size 1) are produced in the following way: for each machine, here is, for eac

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