Suppose that a response variable Y is related to four predictor variables, x1, x2, x3, and x4, so that k = 4. 1. Enter the observed values of y and each of the k = 4 predictor variables into the first (k + 1) columns of an Excel spreadsheet. (NOTE: In order for the mul- tiple regression analysis to work properly, there must be a column of values for each independent predictor variable x, in your model, and the x columns must be adjacent to each other.) 2. Use Data Data Analysis Regression to generate the dialogue box, high- lighting or typing in the cell ranges for the x and y values and check "Labels" if necessary. 3. If you click "Confidence Level," Excel will calculate confidence intervals for the regression estimates, bo, b1, b2, b3, and b4. Enter a cell location for the Output Range and click OK to generate the regression output. NOTE: Excel does not provide options for estimation and prediction. Also, the diagnostic plots which can be generated in Excel are not the same plots as we have discussed in Section 13.3 and will not be discussed in this section.