50.1K

Verified Solution

Link Copied!

D Question 5 10 pts What is the sample covariance of IBM and Verizon Communication between November 2015 and November 2020? 0.397 0.142 07.121 4.853 6.194 Question 6 10 pts If you form a portfolio with equal weights on IBM and Verizon Communication, what will be the expected return and standard deviation? Expected return = 0,397% and Standard deviation = 7.121 % Expected return = 0.502 % and Standard deviation = 5.948% Expected return = 0.659% and Standard deviation = 4,654% Expected return 0.920% and Standard deviation = 4.8530% Expected return = 0.774% and Standard deviation = 4.322% TOJO Instructor: A. Agapova Presentation of your work Provide a spreadsheet in an Excel file showing your calculations of the various combinations of expected retum and standard deviation Follow the format in "Project Example" page 3. Task 3. Regression Analysis a) Use regression analysis to estimate the single index model for Verizon (VZ). For input data, use monthly excess returns from November 2000 through November 2020. The Y-variable is the monthly excess retum of VZ and the X-variable is the monthly excess retum of the S&P 500 stock index. Performing regression analysis using Excel 2013's (or older version) Data Analysis package On the Tool menu, click Data Analysis. If Data Analysis is not available, load the Analysis ToolPak. How? On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program in) in the Data Analysis dialog box click Regression and then click OK iii) In the Regression dialog box, you must specify the inputs. For Input Y Range, highlight the monthly excess returns of VZ (including the column heading) as the Y-axis variable For Input X Range, highlight the monthly excess returns of SP500 (including the column heading) as the X-axis variable iv) Check the Labels box v) in the Output option section, highlight an empty area in the worksheet. Make sure the highlighted area hus at Toast 20 rows and 10 columns vi) Click OK If you have questions at any stage, you can use the Help button on the dialog box to get more information about the options Presentation of your work: Provide a spreadsheet in an Excel file showing your work for the regression analysis results. Follow the format in "Project Example" page S. D Question 5 10 pts What is the sample covariance of IBM and Verizon Communication between November 2015 and November 2020? 0.397 0.142 07.121 4.853 6.194 Question 6 10 pts If you form a portfolio with equal weights on IBM and Verizon Communication, what will be the expected return and standard deviation? Expected return = 0,397% and Standard deviation = 7.121 % Expected return = 0.502 % and Standard deviation = 5.948% Expected return = 0.659% and Standard deviation = 4,654% Expected return 0.920% and Standard deviation = 4.8530% Expected return = 0.774% and Standard deviation = 4.322% TOJO Instructor: A. Agapova Presentation of your work Provide a spreadsheet in an Excel file showing your calculations of the various combinations of expected retum and standard deviation Follow the format in "Project Example" page 3. Task 3. Regression Analysis a) Use regression analysis to estimate the single index model for Verizon (VZ). For input data, use monthly excess returns from November 2000 through November 2020. The Y-variable is the monthly excess retum of VZ and the X-variable is the monthly excess retum of the S&P 500 stock index. Performing regression analysis using Excel 2013's (or older version) Data Analysis package On the Tool menu, click Data Analysis. If Data Analysis is not available, load the Analysis ToolPak. How? On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program in) in the Data Analysis dialog box click Regression and then click OK iii) In the Regression dialog box, you must specify the inputs. For Input Y Range, highlight the monthly excess returns of VZ (including the column heading) as the Y-axis variable For Input X Range, highlight the monthly excess returns of SP500 (including the column heading) as the X-axis variable iv) Check the Labels box v) in the Output option section, highlight an empty area in the worksheet. Make sure the highlighted area hus at Toast 20 rows and 10 columns vi) Click OK If you have questions at any stage, you can use the Help button on the dialog box to get more information about the options Presentation of your work: Provide a spreadsheet in an Excel file showing your work for the regression analysis results. Follow the format in "Project Example" page S

Answer & Explanation Solved by verified expert

See Answer