week 2 stats homework

Please submit your Homework Assignment as one Word file for your written answers and one Excel workbook containing self-explanatory worksheets to organize your quantitative work. Failing to comply with this policy or submitting unorganized documents will result in a score of zero.

Answer the following:

Chapter 4: 4-5, 4-9, 4-19 (for part a, add the linear regression line to your scatter plot and make sure ridership is on the vertical axis; for part b, use Excel's regression functionality), 4-21 (use Excel's regression functionality and a dummy variable for major where 1 if business and 0 if other), 4-23 (use Excel's regression functionality)