. 50
140 . 200 . , 60 . . 54.1 . (108.7+5.4-60).
, 2.7 .
22.8 . - 1044 ., 1066.8 . . , , (. 48), .
, , . , , . , . , ?
, .
. : . , , , . E14:E16 (. 51). G14:G16 .
A | B | C | D | E | F | G | H | I | J | K | |
- | . | =C14-H14 | =E14*$K$14 | . | 5% | ||||||
- | . | =F14+G14- H15+C15 | =E15*$K$14 | . | |||||||
- | . | =F15+G15- H16+C16 | =E16*$K$14 | . | |||||||
- | . | ||||||||||
- | . | ||||||||||
- | . | ||||||||||
.= | =( | C14:C19)+G20 | =(G14:G16) |
. 51
F14:F16 (F14), . , . , E14:E16 , F14:F16. . , , , ( ), .
, .
|
. 52
, . , , - ! 168 . ( , ), 12 .
-7.
, , $1 . . 15 11 . .
, % | |||||||||||
90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 00 | |
APPLE | -46 | -33 | -29 | -67 | |||||||
BOEING | -22 | -25 | |||||||||
BP AMOCO | -12 | -28 | -22 | ||||||||
DEBEERS | -1 | -59 | -29 | -26 | |||||||
DOW CHEM | -24 | -15 | |||||||||
DU PONT | -4 | -27 | |||||||||
EXXON | -4 | ||||||||||
FIAT | -39 | -16 | -23 | -17 | -5 | -8 | -10 | ||||
FORD | -36 | -11 | -14 | -13 | -15 | ||||||
GE | -12 | -7 | |||||||||
G. MOTORS | -7 | -11 | -28 | -28 | |||||||
INTEL | -3 | -10 | |||||||||
LOCKHEED | -21 | -2 | -62 | ||||||||
MICROSOFT | -12 | -39 | |||||||||
PEPSICO | -2 | -12 | -16 |
|
|
18% . , .
, (.. ) , , , , , , . .. , , . . ( s12) p % , ( s22) q % , :
2 + q 2s
2 + 2r
p s1 q s2
r12 . , . , , . . .
N N
N
Dïîðòôåëÿ
=åå xi x j Cov (Ri, R j),
i =1
j =1
Cov (Ri, R j)
- , xi
, .
a. Excel, . Excel =().
b. ( ) ?
c. ( ) , 18% .
d. , ? , 25% ?
.
.
, , , . , . , MS Excel, . , , .
, , , . Excel , 200 . , Premium Solver. , Excel , - FrontLine System www.solver.com. , Excel . Premium Solver .
. , . , , (Standard LP/Quadratic), - GRG Nonlinear Solver - .
|
|
MS Excel (. 53). (). B14:P14 Excel =() 11 . . , . , , , , ,
, , .
, . , . , ( MS 48%), ( FI). .
|
|
|
. 53
, ( ). 15 , ,
1515 . (A16:A30) (. 54). 225 . B17, Apple-Boeing ( ), =($C$3:$C$13;B$3:B$13), $C$3:$C$13 Boeing, B$3:B$13 Apple. , . Boeing, . Boeing, =($C$3:$C$13; C$3:C$13) .
, , , , .
, , .
|
|
|