Consider the following function: Y = 37.684 - 15.315X + 3.095X2 - 0.218X3 + 0.005X4 a. Plot
Question:
Y = 37.684 - 15.315X + 3.095X2 - 0.218X3 + 0.005X4
a. Plot this function on an X-Y graph for positive values of X from 1 to 20.
b. How many local maximum solutions are there?
c. How many local minimum solutions are there?
d. Use Solver to find the minimum value of Y using a starting value of X = 3. What value of Y do you obtain?
e. Use Solver to find the minimum value of Y using a starting value of X =18. What value of Y do you obtain?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Question Posted: