Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6 Multiple Choice Questions Instructions: 1. There are 11 questions. Choose the best answer to each question and write your answer choice (A, B, C,
6 Multiple Choice Questions Instructions: 1. There are 11 questions. Choose the best answer to each question and write your answer choice (A, B, C, D or E) on the answer sheet (page 9). Questions are equally weighted. Answering all of these questions correctly does not result in a top grade on the assignment. The graphs and the write up will be considered when the total project grade is assigned. 2. Your Excel printouts will serve as evidence of your work. 3. Submit the answer sheet together with your Excel printouts and write ups. Questions 1 to 6 are directed at Task 1 1. What is MSFT's arithmetic average and geometric average monthly return between June 2007 and June 2022 (inclusive of June 2022)? A. Arithmetic average is 1.652% and Geometric average is 1.427% B. Arithmetic average is 0.876% and Geometric average is 0.746% C. Arithmetic average is 5.608% and Geometric average is 5.497% D. Arithmetic average is 1.003% and Geometric average is 0.740% E. Arithmetic average is 1.146% and Geometric average is 0.865% 2. What is Walmart's arithmetic average and geometric average monthly return between June 2007 and June 2022 (inclusive of June 2022)? A. Arithmetic average is 1.754% and Geometric average is 1.533% B. Arithmetic average is 0.876% and Geometric average is 0.746% C. Arithmetic average is 5.608% and Geometric average is 5.497% D. Arithmetic average is 1.003% and Geometric average is 0.740% E. Arithmetic average is 1.146% and Geometric average is 0.865% 3. What is MSFT's sample standard deviation between June 2007 and June 2022? A. 1.754% B. 0.955% C. 6.777% D. 5.678% E. 5.951% 4. What is Walmart's sample standard deviation between June 2007 and June 2022? A. 1.306% B. 0.740% C. 5.609% D. 5.090% E. 5.951% + 5. What is the sample covariance of MSFT and Walmart between June 2007 and June 2022 (multiply the result that you get in your calculation by 10,000 to get a number displayed in below answer choices? A. 1.31 B. 0.74 C. 5.61 D. 5.50 E. 8.29 6. What is the sample correlation of MSFT and Walmart between June 2007 and June 2022? A. 0.3447 B. 0.4532 C. 0.2415 D. 0.2759 E. 0.3121 Questions 7 to 9 are directed at Task 2 - use data computed in previous task 7. If you form a portfolio with equal weights on MSFT and Walmart, what will be the expected return and standard deviation? A. Expected return - 1.021% and Standard deviation = 5.608 % B. Expected return=1.136 % and Standard deviation = 4.542% C. Expected return= 1.264% and Standard deviation - 4.704% D. Expected return -0.909% and Standard deviation - 4.487% E. Expected return - 1.016% and Standard deviation = 4.288% = Maitiple Cboice Questiens Iastrections: 3. Subnat the answer seet tegether widh your Eitel prinhouts ind write upe Quention in te 6 are directed et Tak 1 and June 2022 (inclusive of Juni 2022 ? A. 1.7349 is a sass. c.min D 362kN it 3 sors A. 13006 if 6.740% : c. 560% 5000% L. 5981% miser thocen? A. 131 a. 074 c. 56 D 550 t. 12 A as4i? B. 04932 azuis D. exwe E. 03121 8. What aft the weights on MSFT and Walmart in the minimus vatiance portistso? A. Weight en MSs =041, werght en Walmart =0.15 ? B. Weight ea MSAT =0.493, welight on Walmart -0.507 C. Weigla on MSFT =0 5, wrieth en Walmat =03 D. Weight on MsrT =0.319, wripht on Walmart =0.68 1. Weptr en MSIT =0.16, woilh en Whimart =0.84 A. Expected iehim 1.306% abd Slablard deviation =5605 C. Inpected return =1.02W and Statidard deviation =4.2km Qeestien is te 11 are directed ot Tak, A. 1,203 a7s21 0683 1.4512 E. 0.0121 petient in your calculations; fount your animen? A 1203 B. a.741 D. 14312 E00121 A a tor. 11. 0.75% c. 0.90% b. 130se 1. 120% A Ousert, iwi in Sequater, 2009 C Dnimber, 2000 D Jem 2012 k. Janug, ing Maitiple Cboice Questiens Iastrections: 3. Subnat the answer seet tegether widh your Eitel prinhouts ind write upe Quention in te 6 are directed et Tak 1 and June 2022 (inclusive of Juni 2022 ? A. 1.7349 is a sass. c.min D 362kN it 3 sors A. 13006 if 6.740% : c. 560% 5000% L. 5981% miser thocen? A. 131 a. 074 c. 56 D 550 t. 12 A as4i? B. 04932 azuis D. exwe E. 03121 8. What aft the weights on MSFT and Walmart in the minimus vatiance portistso? A. Weight en MSs =041, werght en Walmart =0.15 ? B. Weight ea MSAT =0.493, welight on Walmart -0.507 C. Weigla on MSFT =0 5, wrieth en Walmat =03 D. Weight on MsrT =0.319, wripht on Walmart =0.68 1. Weptr en MSIT =0.16, woilh en Whimart =0.84 A. Expected iehim 1.306% abd Slablard deviation =5605 C. Inpected return =1.02W and Statidard deviation =4.2km Qeestien is te 11 are directed ot Tak, A. 1,203 a7s21 0683 1.4512 E. 0.0121 petient in your calculations; fount your animen? A 1203 B. a.741 D. 14312 E00121 A a tor. 11. 0.75% c. 0.90% b. 130se 1. 120% A Ousert, iwi in Sequater, 2009 C Dnimber, 2000 D Jem 2012 k. Janug, ing
6 Multiple Choice Questions Instructions: 1. There are 11 questions. Choose the best answer to each question and write your answer choice (A, B, C, D or E) on the answer sheet (page 9). Questions are equally weighted. Answering all of these questions correctly does not result in a top grade on the assignment. The graphs and the write up will be considered when the total project grade is assigned. 2. Your Excel printouts will serve as evidence of your work. 3. Submit the answer sheet together with your Excel printouts and write ups. Questions 1 to 6 are directed at Task 1 1. What is MSFT's arithmetic average and geometric average monthly return between June 2007 and June 2022 (inclusive of June 2022)? A. Arithmetic average is 1.652% and Geometric average is 1.427% B. Arithmetic average is 0.876% and Geometric average is 0.746% C. Arithmetic average is 5.608% and Geometric average is 5.497% D. Arithmetic average is 1.003% and Geometric average is 0.740% E. Arithmetic average is 1.146% and Geometric average is 0.865% 2. What is Walmart's arithmetic average and geometric average monthly return between June 2007 and June 2022 (inclusive of June 2022)? A. Arithmetic average is 1.754% and Geometric average is 1.533% B. Arithmetic average is 0.876% and Geometric average is 0.746% C. Arithmetic average is 5.608% and Geometric average is 5.497% D. Arithmetic average is 1.003% and Geometric average is 0.740% E. Arithmetic average is 1.146% and Geometric average is 0.865% 3. What is MSFT's sample standard deviation between June 2007 and June 2022? A. 1.754% B. 0.955% C. 6.777% D. 5.678% E. 5.951% 4. What is Walmart's sample standard deviation between June 2007 and June 2022? A. 1.306% B. 0.740% C. 5.609% D. 5.090% E. 5.951% + 5. What is the sample covariance of MSFT and Walmart between June 2007 and June 2022 (multiply the result that you get in your calculation by 10,000 to get a number displayed in below answer choices? A. 1.31 B. 0.74 C. 5.61 D. 5.50 E. 8.29 6. What is the sample correlation of MSFT and Walmart between June 2007 and June 2022? A. 0.3447 B. 0.4532 C. 0.2415 D. 0.2759 E. 0.3121 Questions 7 to 9 are directed at Task 2 - use data computed in previous task 7. If you form a portfolio with equal weights on MSFT and Walmart, what will be the expected return and standard deviation? A. Expected return - 1.021% and Standard deviation = 5.608 % B. Expected return=1.136 % and Standard deviation = 4.542% C. Expected return= 1.264% and Standard deviation - 4.704% D. Expected return -0.909% and Standard deviation - 4.487% E. Expected return - 1.016% and Standard deviation = 4.288% =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started