80.2K

Verified Solution

Link Copied!

Question 3 What is IBM's sample standard deviation between November 2015 and November 2020? 0.397% 0.142% 7.121% 4.853% O 6.194% Question 4 What is Verizon Communication's sample standard deviation between November 2015 and November 2020? O 0.397% 0.142% O 7.121% 0 4.853% 6.194% TE 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 Example" page 3 Task 3Regression Analysis *) 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 return of the S&P 500 stock index Performing regression analysis using Excel 2013% (or older version) Data Analysis package 3) On the Tool menu, click Data Analysis. Ir 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 Li) in the Data Analysis dialog box click Regression and then click OK til) 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 boading) as the X-axis variable. iv) Check the Labels box ) In the Output option section, highlight an empty area in the worksheet. Make sure the highlighted arca 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 3 What is IBM's sample standard deviation between November 2015 and November 2020? 0.397% 0.142% 7.121% 4.853% O 6.194% Question 4 What is Verizon Communication's sample standard deviation between November 2015 and November 2020? O 0.397% 0.142% O 7.121% 0 4.853% 6.194% TE 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 Example" page 3 Task 3Regression Analysis *) 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 return of the S&P 500 stock index Performing regression analysis using Excel 2013% (or older version) Data Analysis package 3) On the Tool menu, click Data Analysis. Ir 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 Li) in the Data Analysis dialog box click Regression and then click OK til) 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 boading) as the X-axis variable. iv) Check the Labels box ) In the Output option section, highlight an empty area in the worksheet. Make sure the highlighted arca 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