Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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

image text in transcribed 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Finance

Authors: Besley, Scott Besley, Eugene F Brigham, Brigham

4th Edition

0324655886, 9780324655889

More Books

Students also viewed these Finance questions

Question

what are the major classifications on income statement?

Answered: 1 week ago

Question

8. What are the costs of collecting the information?

Answered: 1 week ago

Question

1. Build trust and share information with others.

Answered: 1 week ago