Principles of Finance with Excel (Основы финансов c Excel)
Подождите немного. Документ загружается.
PFE Chapter 32, Goal Seek and Solver page 8
Solver is more flexible
Again we use an algebra example, but this time we use the function
2
714yx x=−−.
This function is a simple parabola:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
ABC DEF
x5 Table
y -24 <-- =B2^2-7*B2-14 xy
-9 130
-8 106
-7 84
-6 64
-5 46
-4 30
-3 16
-2 4
-1 -6
0-14
1-20
2-24
3-26
4-26
5-24
6-20
7-14
8-6
94
10 16
11 30
SECOND EXAMPLE
-40
-20
0
20
40
60
80
100
120
140
-10 -5 0 5 10 15
Now suppose we want to find
x such that y = 21. As you can see above, there are 2 such
x’s: One is between –3 and –4, and the other is between 10 and 11. If you use Goal Seek, you
cannot specify which
x to find.
With
Solver, however, you can specify constraints on the variables:
PFE Chapter 32, Goal Seek and Solver page 9
Here we’ve used
Add to enter 2 constraints on x. Pressing Solve gives the correct
answer:
1
2
3
ABC
x 10.37386
y 21 <-- =B2^2-7*B2-14
SECOND EXAMPLE
EXERCISES
Using Goal Seek on the function
2
714yx x
=
−−, find x such that y = 21. Which of the 2
values of x does Goal Seek find?