60.1K

Verified Solution

Link Copied!

Question 9 10 pts What is VZ's beta between November 2000 and November 2020? 0.634 1.000 O 0.343 0.270 O 0.078 Question 10 10 pts What is the intercept of the single-index model? 0.634 O 1.000 O 0.270 O 0.137 O 0.078 How? Instructor A. Agapova Presentation of your work Provide a spreadsheet in an Excel file showing your calculations of the various combinations of expected return and standard deviation. Follow the format in "Project 1 Examplo" 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 return of VZ and the X-variable is the monthly excess return of the S&P 500 stock index Performing regression analysis using Excel 2013's (or older version) Data Analysis package D) On the Tool menu, click Data Analysis, If Data Analysis is not available, load the Analysis ToolPak. 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. ii) 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 arca in the worksheet. Make sure the highlighted area has at least 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 1 Example" page 5. Question 9 10 pts What is VZ's beta between November 2000 and November 2020? 0.634 1.000 O 0.343 0.270 O 0.078 Question 10 10 pts What is the intercept of the single-index model? 0.634 O 1.000 O 0.270 O 0.137 O 0.078 How? Instructor A. Agapova Presentation of your work Provide a spreadsheet in an Excel file showing your calculations of the various combinations of expected return and standard deviation. Follow the format in "Project 1 Examplo" 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 return of VZ and the X-variable is the monthly excess return of the S&P 500 stock index Performing regression analysis using Excel 2013's (or older version) Data Analysis package D) On the Tool menu, click Data Analysis, If Data Analysis is not available, load the Analysis ToolPak. 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. ii) 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 arca in the worksheet. Make sure the highlighted area has at least 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 1 Example" page 5

Answer & Explanation Solved by verified expert

See Answer