i use the goal seek tool in ms excel to solve the, Mechanical Engineering

+44 141 628 6080
[email protected]

i use the goal seek tool in ms excel to solve the

(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.

View Complete Question

Request for Solution File

Ask an Expert for Answer!!

Mechanical Engineering: i use the goal seek tool in ms excel to solve the

Reference No:- TGS0219122

Expected delivery within 24 Hours

Have a Question? (oR Write a Review)

Write atleast 100 words!!

Asked Questions

Investigate the cause of the recent werewolf attacks

create a temporary committee to investigate the cause of the recent werewolf attacks in major cities throughout the United States.

Describe marxist theory and psychology of addiction

Compare the Marxist Theory and Psychology of Addiction with the Realistic Theory and psychology of Addition.

Explain framers decisions in creating the constitution

Explain how the Articles of Confederation made the above scenario possible. Describe how this scenario influenced the framers' decisions in creating the Constit

Federal bureaucracy has to put up with a lot of red tape

Question: The Federal Bureaucracy has to put up with a lot of "red tape". What is "red tape" in regards to government?

What power of recognition when it comes to office president

Question: What is "power of recognition" when it comes to the office of the president? Question Select one

What right ordinance power give to the president

Question: What right does the Ordinance Power give to the president? Question Select one:

Analyze leadership of organization during particular event

Analyze leadership of an organization during a particular event or across a defined set of events. The assignment will assess your ability to identify

Request for Solution File

Ask an Expert for Answer!!

Mechanical Engineering: i use the goal seek tool in ms excel to solve the

Reference No:- TGS0219122

Have a Question? (oR Write a Review)

Recent Questions Asked Mechanical Engineering

Q : consider the kristen cookie company casefrom the

Q : which electronic level would allow the hydrogen

Q : 1 gm of a metallic oxide on reduction gives 068

Q : a tank is filled up to a height 2h with a liquid

Q : i use the goal seek tool in ms excel to solve the

Q : four 04 coins are tossed simultaneously ie at the

Q : a polynomial satisfies the following relation

Q : a company makes two types of sofas regular and

Q : if 4x49x464 then the maximum value of x2y2 is