Can any one tell me how to fix this error message? (#VALUE!)
J | K | J | M | N | O | |
Var_COV | ||||||
9 | Column 1 | 0.0368% | 0.0071% | 0.0039% | 0.0081% | -0.0001% |
10 | Column 2 | 0.0071% | 0.0132% | 0.0065% | 0.0070% | 0.0087% |
11 | Column 3 | 0.0039% | 0.0065% | 0.0108% | 0.0036% | 0.0065% |
12 | Column 4 | 0.0081% | 0.0070% | 0.0036% | 0.0114% | 0.0060% |
13 | Column 5 | -0.0001% | 0.0087% | 0.0065% | 0.0060% | 0.0171% |
SUM | VAR | |||||
22 | Portfolio 1 | 0.3 | 0.3 | 0.3 | 0.9 | #VALUE! |
23 | P2 | 0.3 | 0.3 | 0.3 | 0.9 | |
24 | P3 | 0.3 | 0.3 | 0.3 | 0.9 | |
25 | P4 | 0.3 | 0.3 | 0.3 | 0.9 | |
26 | P5 | 0.3 | 0.3 | 0.3 | 0.9 | |
27 | P6 | 0.3 | 0.3 | 0.3 | 0.9 | |
Formula | {MMULT(K22:M22,MMULT(K9:O13,TRANSPOSE(K22:M22)))} | |||||
Im sure im doing it right but maybe my Variance/ Covariance matrix might be wrong | ||||||
Matrix multiplication occurs when we have same columns
In MMULT(K9:O13,TRANSPOSE(K22:M22)) you have K9:O13 having 5 columns but K22:M22 transpose will have 1 column only
Can any one tell me how to fix this error message? (#VALUE!) J K J M...
these two questions im having trouble on. Provides the tables for both M 6.2.75 се Use a standard normal distribution table to obtain the Z-score that has an area of 0.975 to its right. Click here to view page 1 of the normal distribution table, As Click here to view page 2 of the normal distribution table. Za St (Round to two decimal places as needed.) normal distribution page 1 Areas under the standard normal curve Second decimal place in...
please help me with this calculations. i used the data analysis to figure out the correlation matrix. Below there are 10 Assets row 66: Mean Return Row 67: Standard Deviation Row 69: Annual Return Row 70 Annual ST. deviation I used the data analysis to calculate the CORRELATION matrix with the DATA ASSET RANGE. now im stuck on how to calculate the covariance matrix Enr gy Telc 0.0559 0.0508 0.0093 0.0297 0.0352 0.0065 0.0249 0.0646 0.0165 0.0554 0.0524 0.0278 0.0307...