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

Discuss children diagnosed with developmental disabilities

When Min decided to begin his supervised field experience, he applied at a company in his hometown that provided applied behavior analysis

Identify a specific theory of cognitive or moral development

Problem 1: Identify a specific theory of cognitive or moral development, and summarize the major assumptions.

What is a behavioral indicator related to family

Which of the following is a behavioral indicator related to Family? A) Developing school readiness and transition strategies B) Developing collaborative

Outline a social issue that is important to you

Outline a social issue that is important to you. Describe why it is important to you, why it is important from a societal perspective and how you think

Why you feel unpleasantly hot and sweaty

Working in the yard, you feel unpleasantly hot and sweaty when you come in the house, so you take a shower and begin to feel better.

Describe some of your personality traits

Adler believed that your birth order determines, to a large extent, your personality. He stated that your traits reflect, somehow, how you have achieved

Describe the results, including any scores

Describe the results, including any scores. Result: E6% Extraverted Action oriented, Outgoing, Expressive, Hands-On S17% Sensing Traditional,

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