Graphing and Goal Seek: a. Graph the function y x = 2 2 +x 14 2

Question:

Graphing and Goal Seek:

a. Graph the function y x = −2 2 − +x 14 2 for x = –4.0, –3.75, –3.50, . . ., 3.0. What are the approximate values of x for which y = 0?

b. Using Goal Seek on the function, find x such that y = 0.

Which of the two values of x does Goal Seek find?

c. Use Solver with an appropriate constraint to find the second value of x for which the function y x = −2 2 − +x 14 2 has a value of 0.

Step by Step Answer:

Related Book For  book-img-for-question

Principles Of Finance Wtih Excel

ISBN: 9780190296384

3rd Edition

Authors: Simon Benninga, Tal Mofkadi

Question Posted: