分散共分散行列																		
		A	B																
	A	1	0.84																
	B	0.84	1.44																
																			
	平均	0.04	0.06																
	標準偏	1	1.2																
		=SQRT(C3)	=SQRT(D4)																
																			
		IBM投資比率	-1.6	-1.4	-1.2	-1	-0.8	-0.6	-0.4	-0.2	0	0.2	0.4	0.6	0.8	1	1.2	1.4	1.6
		平均値(%)	=D10*$C$6+(1-D10)*$D$6	=E10*$C$6+(1-E10)*$D$6	=F10*$C$6+(1-F10)*$D$6	=G10*$C$6+(1-G10)*$D$6	=H10*$C$6+(1-H10)*$D$6	=I10*$C$6+(1-I10)*$D$6	=J10*$C$6+(1-J10)*$D$6	=K10*$C$6+(1-K10)*$D$6	=L10*$C$6+(1-L10)*$D$6	=M10*$C$6+(1-M10)*$D$6	=N10*$C$6+(1-N10)*$D$6	=O10*$C$6+(1-O10)*$D$6	=P10*$C$6+(1-P10)*$D$6	=Q10*$C$6+(1-Q10)*$D$6	=R10*$C$6+(1-R10)*$D$6	=S10*$C$6+(1-S10)*$D$6	=T10*$C$6+(1-T10)*$D$6
		標準偏差(%)	=SQRT(D13)	=SQRT(E13)	=SQRT(F13)	=SQRT(G13)	=SQRT(H13)	=SQRT(I13)	=SQRT(J13)	=SQRT(K13)	=SQRT(L13)	=SQRT(M13)	=SQRT(N13)	=SQRT(O13)	=SQRT(P13)	=SQRT(Q13)	=SQRT(R13)	=SQRT(S13)	=SQRT(T13)
		分散	=D10^2*$C$3+(1-D10)^2*$D$4+2*D10*(1-D10)*$D$3	=E10^2*$C$3+(1-E10)^2*$D$4+2*E10*(1-E10)*$D$3	=F10^2*$C$3+(1-F10)^2*$D$4+2*F10*(1-F10)*$D$3	=G10^2*$C$3+(1-G10)^2*$D$4+2*G10*(1-G10)*$D$3	=H10^2*$C$3+(1-H10)^2*$D$4+2*H10*(1-H10)*$D$3	=I10^2*$C$3+(1-I10)^2*$D$4+2*I10*(1-I10)*$D$3	=J10^2*$C$3+(1-J10)^2*$D$4+2*J10*(1-J10)*$D$3	=K10^2*$C$3+(1-K10)^2*$D$4+2*K10*(1-K10)*$D$3	=L10^2*$C$3+(1-L10)^2*$D$4+2*L10*(1-L10)*$D$3	=M10^2*$C$3+(1-M10)^2*$D$4+2*M10*(1-M10)*$D$3	=N10^2*$C$3+(1-N10)^2*$D$4+2*N10*(1-N10)*$D$3	=O10^2*$C$3+(1-O10)^2*$D$4+2*O10*(1-O10)*$D$3	=P10^2*$C$3+(1-P10)^2*$D$4+2*P10*(1-P10)*$D$3	=Q10^2*$C$3+(1-Q10)^2*$D$4+2*Q10*(1-Q10)*$D$3	=R10^2*$C$3+(1-R10)^2*$D$4+2*R10*(1-R10)*$D$3	=S10^2*$C$3+(1-S10)^2*$D$4+2*S10*(1-S10)*$D$3	=T10^2*$C$3+(1-T10)^2*$D$4+2*T10*(1-T10)*$D$3