
128 BUSINESS APPLICATIONS OF MULTIPLE REGRESSION
data with while you move data and delete columns. Second, before you
begin, make a backup copy of your data on a second worksheet tab. That
way, if you accidentally delete data, you can go to this backup sheet and
recover it.
The less serious problem is that the regression function in Excel
remembers your last set of inputs and has no reset button. That means
you must remember to manually change the setting for the independent
variables and output sheet each time you run regression.
Dropping Number of Bathrooms results in an r
2
value of 0.992. That
regression run is shown in Figure 4.4. ...