Question: 5 3 2 3 = If f 8 2 1 4 9 Suppose A 3 0 0 2 2 8 8 7 5 11 12

5 3 2 3 = If f 8 2 1 4 9 Suppose A 3 0 0 2 2 8 8 7 5 11 12 (1) 14 A-1 = B 221 222 223 224 1 232 233 234 241 242 243 244 then what is 100 x bui? II. (Use MINVERSE function in Excel.) 1 1 If 1 = 1 and [0.091 0.045 0.048 0.037 0.041 0.045 0.088 0.050 0.042 0.063 E = 0.048 0.050 0.00 0.039 0.053 0.037 0.042 0.039 0.048 0.032 20.041 0.063 0.053 0.032 0.140] then what is W4 in 21 W2 w = W3 ? W4 ws 1. Open an empty Excel sheet. 2. Input 1 from A1 to A5. 3. Input from C1 to G5. 4. Select from 11 to 15. 5.Press F2, input (copy and paste) =MMULT(MINVERSE(C1:G5),A1:A5) and insert by pressing Shift+Enter. (Submit 12.34 rather than 0.1234 or 12.34%.) (Note: is the annualized covariance matrix from the FAANG (in that order) stocks, and w is the weights for the minimum standard deviation portfolio using the stocks.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
