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

About learning software''s, I am am Mtech student of Machine design and I a...

I am am Mtech student of Machine design and I am willing to join some core companies so is this the right time for learning some software''s if yes which are they...

Evaluate the risks in oil spill disaster , Case study entitled " Exxon Vald...

Case study entitled " Exxon Valdez Oil Spill Disaster ". 1.      Examine the aim and objectives of Exxon Mobil Corporation. 2.      Carefully observe the oil and refinery ind

Explain in detail about the large excavations, Explain in detail about the ...

Explain in detail about the Large excavations Large excavations required for construction of rafts may need dewatering, depending on the ground water flow and the choice of  a

Calculate the support reactions of beam, Calculate the support reactions of...

Calculate the support reactions of beam: Q: Bending moment diagram (BMD) of the simple supported beam can be given as shown in figure given below. Calculate the support reac

Performance of heat engine - thermodynamics , Performance of Heat engine: ...

Performance of Heat engine: Performanc e of HP:   It is measured by thermal efficiency that is the degree of useful conversion of heat received into work.

Form tool, detals of type of form tool?

detals of type of form tool?

Third gear position - shifting of gear, Third Gear Position: When gea...

Third Gear Position: When gear M3 on the main shaft is in mesh with gear C3 on the counter shaft then this is known as third gear position. The fixed gear M3 rotates with mai

Gage factor and transverse sensitivity of the gage, A biaxial rosette is sh...

A biaxial rosette is shown at right. Derive equations to correct for transverse sensitivity effects for the case in which the two strain gage elements exhibit different gage factor

Common rules concerning corresponding option , COMMON RULES CONCERNING CORR...

COMMON RULES CONCERNING CORRESPONDING OPTION:     Let us consider the DATA DIVISION entries as shown below. Now, let us see which data items will be moved if

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