9781118041581

Today most spreadsheet programs give you the power to run multiple-regression

programs. In this appendix we review the steps of running a regression using

Microsoft’s Excel spreadsheet program using the airline example in the text.

Simple Regression

Step 1: Enter the data.Recall that in Table 4.1, the average number of coach

seats is the dependent variable and the average price is the independent variable.

The data for both of these variables must be entered into the spreadsheet as

columns, as Table 4A.1 shows.

Step 2: Call up the regression program.The method for calling up a regression

program may vary a bit depending on the version of the program. In Excel,

calling up the regression program involves these steps: Under the Data menu

select Data Analysis, then select Regression, and click OK. A regression dialog

box will appear, such as the one depicted in the bottom part of Table 4A.1.

The following steps show how to complete this box.

Step 3: Designate the columns of data to be used in the regression. The regres-

sion program has to be told where to find the data. This is done by entering the

cells in the boxes labeled “Y Input Range” and “X Input Range.” The Y input

182

APPENDIX TO CHAPTER 4

Regression Using

Spreadsheets

c04EstimatingandForecastingDemand.qxd 9/5/11 5:49 PM Page 182