. 54
, . B16:P30. ,
xi, ,
15 15
D =åå xi xj (Ri, R j),
(Ri, R j)
-
i =1
j =1
.
, , , . B32:P32 . x1, x2, x15 100% ( A33), , A33=1.
D
15 ì15 ü
D = å xi íå x j (Ri, R j)ý.
i =1
î j =1 þ
,
=(). Apple, ,
ì15 ü
x 1 íå x j (R 1, R j)ý
î j =1 þ
=B32*($B$32:$P$32;B16:P16). B35. . , , , . J35 .
B35:P35 D . A37 (. 54) , . .
,
A38 (=(A37)).
, . I37 =(B32:P32;B14:P14). . I38.
. . A37, . B32:P32. - Standard LP/Quadratic ( Solver). (Assume Non-Negative) , ,
. , , 100% (A33=1) I37>=I38.
|
. 55
, 4 . 18%, 5.64%. , , , , 95% ~7% (18%-1.96*5.64%) ~29% (18%+1.96*5.64%).
, ? 25% .
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
0.0% | 19.2% | 0.0% | 25.2% | 0.0% | 0.0% | 0.0% | 0.0% | 8.6% | 0.0% | 0.0% | 7.4% | 0.0% | 25.6% | 14.0% | ||
100.00% | AP | BO | BP | DB | DO | DP | EX | FI | FO | GE | GM | IN | LM | MS | PEP | |
0.0283 | 0.036 | 0.009 | 0.03 | 0.124 | 0.023 | |||||||||||
15.922 | 29.31 | -7.79 | 16.88 | 76.39 | 3.547 | |||||||||||
. | ||||||||||||||||
134.26 | 25% | |||||||||||||||
11.59 | 25% |
. 56
, 11.6%. 95% 2.3% (25%-1.96*11.6%) 47.7% (25%+1.96*11.6%). , . . , , 6 .
, 95%- .
, . , . , , , 8%, . . ( I37-1.96*D38/100>=8%).
|
|
A33=1, , . 3.78%, .
|
. 57
, 18%, ! , , , , . , -6.7%, + 42.4%. , ! , , .
, . (NYSE), . , , . .