Regression Analysis

From the Texts: 9th ed. 8th ed. 7th ed. 6th ed. 5th ed.

Problem #4 3-21 3-21 3-21 3-19 3-35

Problem #5 3-22 3-22 3-22 3-21 3-51

Problem #6 3-52 3-44 3-44 3-41 3-52

For the first problem, ignore the requirements of the problem as stated in the text. This is a regression assignment for you, and we are only using the problem for the data.

For the first problem (either 3-21, 3-19, or 3-35), you should generate one regression model. Same for the second problem (either 3-22, 3-21, or 3-51).

For the third problem (either 3-44, 3-41, or 3-52), you should generate three regression models.

use the excel to create the regression

Using Excel , . To do this, you will need to label a tab on a spreadsheet INPUT. On this sheet, the inputs that change every period will be entered. IMPORTANT: the input sheet has data points only. No calculations of any sort should be on the input sheet.

but on output regression calculation is required from input data.