problems34
Constant 3Vector Vector*Constant1 3 - =A4:A8*B12 64 125 156 18常数 3向量 向量*常数1 3 - =A4:A8*B12 64 125 156 18RowvectorColumnvector Product1 -8 44 - =MMULT(TRANSPOSE(A2:A6),B2:B6)2 -93 74 65 5行向量 列向量 乘积1 -8 44 - =MMULT(TRANSPOSE(A2:A6),B2:B6)2 -93 74 65 5GE MSFT JNJ K BA IBMGE 0.1035 0.0758 0.0222 -0.0043 0.0857 0.1414MSFT 0.0758 0.1657 0.0412 -0.0052 0.0379 0.1400JNJ 0.0222 0.0412 0.0360 0.0181 0.0101 0.0455K -0.0043 -0.0052 0.0181 0.0570 -0.0076 0.0122BA 0.0857 0.0379 0.0101 -0.0076 0.0896 0.0856IBM 0.1414 0.1400 0.0455 0.0122 0.0856 0.2993The array function below is =IF(B11:G11=A12:A17,B2:G7,0)GE MSFT JNJ K BA IBMGE 0.1035 0.0000 0.0000 0.0000 0.0000 0.0000MSFT 0.0000 0.1657 0.0000 0.0000 0.0000 0.0000JNJ 0.0000 0.0000 0.0360 0.0000 0.0000 0.0000K 0.0000 0.0000 0.0000 0.0570 0.0000 0.0000BA 0.0000 0.0000 0.0000 0.0000 0.0896 0.0000IBM 0.0000 0.0000 0.0000 0.0000 0.0000 0.2993A B C D E F G1234567891011121314151617GE MSFT JNJ K BA IBMGE 0.1035 0.0758 0.0222 -0.0043 0.0857 0.1414MSFT 0.0758 0.1657 0.0412 -0.0052 0.0379 0.1400JNJ 0.0222 0.0412 0.0360 0.0181 0.0101 0.0455K -0.0043 -0.0052 0.0181 0.0570 -0.0076 0.0122BA 0.0857 0.0379 0.0101 -0.0076 0.0896 0.0856IBM 0.1414 0.1400 0.0455 0.0122 0.0856 0.2993The array function below is =IF(B11:G11=A12:A17,B2:G7,0)GE MSFT JNJ K BA IBMGE 0.1035 0.0000 0.0000 0.0000 0.0000 0.0000MSFT 0.0000 0.1657 0.0000 0.0000 0.0000 0.0000JNJ 0.0000 0.0000 0.0360 0.0000 0.0000 0.0000K 0.0000 0.0000 0.0000 0.0570 0.0000 0.0000BA 0.0000 0.0000 0.0000 0.0000 0.0896 0.0000IBM 0.0000 0.0000 0.0000 0.0000 0.0000 0.2993A B C D E F G1234567891011121314151617GE MSFT JNJ K BA IBMGE 0.1035 0.0758 0.0222 -0.0043 0.0857 0.1414MSFT 0.0758 0.1657 0.0412 -0.0052 0.0379 0.1400JNJ 0.0222 0.0412 0.0360 0.0181 0.0101 0.0455K -0.0043 -0.0052 0.0181 0.0570 -0.0076 0.0122BA 0.0857 0.0379 0.0101 -0.0076 0.0896 0.0856IBM 0.1414 0.1400 0.0455 0.0122 0.0856 0.2993The array function below is =IF(B1:G1=A2:A7,0,B2:G7)GE MSFT JNJ K BA IBMGE 0.0000 0.0758 0.0222 -0.0043 0.0857 0.1414MSFT 0.0758 0.0000 0.0412 -0.0052 0.0379 0.1400JNJ 0.0222 0.0412 0.0000 0.0181 0.0101 0.0455K -0.0043 -0.0052 0.0181 0.0000 -0.0076 0.0122BA 0.0857 0.0379 0.0101 -0.0076 0.0000 0.0856IBM 0.1414 0.1400 0.0455 0.0122 0.0856 0.0000A B C D E F G1234567891011121314151617GE MSFT JNJ K BA IBMGE 0.1035 0.0758 0.0222 -0.0043 0.0857 0.1414MSFT 0.0758 0.1657 0.0412 -0.0052 0.0379 0.1400JNJ 0.0222 0.0412 0.0360 0.0181 0.0101 0.0455K -0.0043 -0.0052 0.0181 0.0570 -0.0076 0.0122BA 0.0857 0.0379 0.0101 -0.0076 0.0896 0.0856IBM 0.1414 0.1400 0.0455 0.0122 0.0856 0.2993The array function below is =IF(B1:G1=A2:A7,0,B2:G7)GE MSFT JNJ K BA IBMGE 0.0000 0.0758 0.0222 -0.0043 0.0857 0.1414MSFT 0.0758 0.0000 0.0412 -0.0052 0.0379 0.1400JNJ 0.0222 0.0412 0.0000 0.0181 0.0101 0.0455K -0.0043 -0.0052 0.0181 0.0000 -0.0076 0.0122BA 0.0857 0.0379 0.0101 -0.0076 0.0000 0.0856IBM 0.1414 0.1400 0.0455 0.0122 0.0856 0.0000A B C D E F G1234567891011121314151617FIDELITY DIVERSIFIEDINTERNATIONAL FUNDSource:http:/www.fidelity.comYear Return1998 14.39%1999 50.65%2000 -8.96%2001 -12.99%2002 -9.37%2003 42.38%2004 19.66%2005 17.23%2006 22.52%2007 11.10%Compoundannual return 14.43% - =PRODUCT(1+C3:C12)(1/9)-1Check on resultsYearInvesmentat beg.yearReturnInvest. atend ofyear1998 100 14.39% 114.391999 114.39 50.65% 172.32852000 172.3285 -8.96% 156.88792001 156.8879 -12.99% 136.50822002 136.5082 -9.37% 123.71732003 123.7173 42.38% 176.14882004 176.1488 19.66% 210.77962005 210.7796 17.23% 247.09692006 247.0969 22.52% 302.74322007 302.7432 11.10% 336.3476Compound growth 14.43% - =(E28/C19)(1/9)-1A B C D E F G H123456789101112131415161718192021222324252627282930FDIVX基金Source:http:/www.fidelity.com年 收益率1998 14.39%1999 50.65%2000 -8.96%2001 -12.99%2002 -9.37%2003 42.38%2004 19.66%2005 17.23%2006 22.52%2007 11.10%复合年收益率 14.43% - =PRODUCT(1+C3:C12)(1/9)-1检验该收益年 年初投资 收益 年末投资1998 100 14.39% 114.391999 114.39 50.65% 172.32852000 172.3285 -8.96% 156.88792001 156.8879 -12.99% 136.50822002 136.5082 -9.37% 123.71732003 123.7173 42.38% 176.14882004 176.1488 19.66% 210.77962005 210.7796 17.23% 247.09692006 247.0969 22.52% 302.74322007 302.7432 11.10% 336.3476复合增长率 14.43% - =(E28/C19)(1/9)-1A B C D E F G H123456789101112131415161718192021222324252627282930