Problem Set 1
The purpose of the assignment is to review basic hypothesis testing and regression techniques. There is an appendix in your textbook, Appendix C: Using Excel to Conduct Analysis, which may help you with running regressions in Microsoft Excel. You may also wish to use a basic statistics text for guidance if needed. I have also provided you with a table with the t distribution.
If you have an older version of EXCEL and have not previously loaded the Analysis ToolPak, go to TOOLS, ADD-INS, Analysis Tool Pak. This will load the regression software that you will need. Then go to TOOLS, DATA ANALYSIS, Regression. Now you are ready to run regressions in EXCEL. Alternatively, if you have the most…show more content… Excess rate of return (firm) = Rate of return (firm) - Risk free rate.
1b. Determine the alpha and beta coefficients for this stock by running a simple linear regression. Use the file from part (1a) and regress the excess rate of return for the firm against the excess rate of return for the market. The “excess rate of return for the firm” data is the Input Y Range (dependent variable) and the “excess rate of return for the market” is the Input X Range (In Excel, the Data Analysis menu is under Tools (older version of Excel) or Data (newer version)). If you include the row with the variable name in your Input Y Range and your Input X Range, check the box LABELS, and Excel will automatically name your