I have attached the homework, I will only need only the answer and solution of question 3 and 4. Thanks

Assignment 6 1. a. b. c. d. Use Excel to perform the following matrix operations: 2 2 12 6 1 1 4 8 7 8 0 23 1 0 9 1 7 3 2 9 5 0 3 1 1 2 3 2 6 6 2 9 3 1 1 2 3 2 5 0 6 6 2 0 6 1 1 2 4 8 7 8 0 2 1 0 9 1 7 3 2. Find the determinant and inverses of the following matrices: a. b. c. 1 2 2 5 4 4 5 2 8 3 2 1 9 0 7 6 3 2 1 6 1 3 7 4 3 3 3 20 2 1 10 2 2 3 2 40 9 3 2 9 33 1 3. Using matrix functions and solver in excel draw the minimum variance frontier without short sale for a portfolio of four stocks with following variance covariance matrix and mean returns. Variance Covariance Matrix = Returns matrix = 0.22 0.034 .016 .034 .88 .032 .016 .032 .15 .019 .046 .027 .019 .046 .027 .102 0.13 0.16 0.05 0.1 4. (The following problem has been taken from Encyclopedia Galactica) There was a lot commotion on planet BAJOUR. The Grand Sarak is coming to inspect whether the money given to planet BAJOUR has been profitably spent on the projects for which it was assigned to. Planet BAJOUR Latinum spent in recovering of Wasteland after the Great War of Supremacy on star-date 99880 Entire Federation of Planets No. of Observations Average Expense Per hectare Stan. Dev No. of Observations Average Expense Per hectare Stand. Dev 50 67.74 4.06 123 55.56 9.23 (Use alpha value = 0.01) Assume that the populations (recovery expenses of wastelands in Bajour and the entire federation of planets) are normally distributed and that the samples are independent. The population variances are not known. Answer the following a. Prior experience says that the mean recovery expense of wastelands like in 2 Planet Bajour is 50.12. Based on this information, do you think that the current mean recovery expense of the wasteland in Planet Bajour is significantly more than prior expenses? b. Obtain a 95% confidence interval on the mean recovery expense of wasteland in Planet Bajour. c. Do you think that the mean recovery expense of the wasteland in Planet Bajour is same as the mean recovery expense of wastelands in the entire federation of planets? Use the proper statistical test to arrive at your conclusion. You must justify as to why did you use this test? (Exchange rate Earth 1 = Latinum 1.2) (Use alpha value = 0.01) 3