Lab 2 : Regression | Automotive MPG excel

This exercise is based on your assigned MindTap homework: Chapter 7 Assignment, Question# 4, Problem 07-15 Part (e) and (f). Since you need to launch Excel to work the problem, this lab’s effort leverages work that you are already doing. It will validate your Excel competency with basic spreadsheet design and use of regression tools.

1. Launch the worksheet associated with the problem in MindTap and work down to part (e).

2. Use Excel functions with appropriate row & col addressing modes ($) to translate the non-numeric categorical variables to the 3 auxiliary variables with 1’s and 0’s in new table, where the columns are arranged correctly to address the question. (DO NOT hand translate the data into the 900 cells!)

3. Run the regression tool on the worksheet that you will be turning in and specify the output location on the same worksheet. DO NOT run it on another worksheet or workbook and copy it into your submission file. (No credit given if it cannot be verified that the regression tool was launched on the data in the reorganized table.)

4. Organize both the table (input) and the regression report (output) so they are presentable. Remember best practices covered in the prior lab (Refer to its instructions), the assigned reading, and the lectures.

5. Use YELLOW to highlight all the cells of the regression report that you referenced to answer parts (e) and (f) of the MindTap exercise.