NOTE: Lobel the resulting worksheet tab "Original Regression". Leave in which independent variable(s): Take out which independent variable (s]: 2. Build a model to predict winning bid. To answer this, remove the non-significant independent variables from the model and rerun it. NOTE: For Excel's Data Analysis, independent variables must be in contiguous columns. 5o, you may have to copy and paste only the variables that you want in a new worksheet and then run the regression. NOTE: Label the reduced datoset worksheet "Reduced Doto" and the resulting worksheet tob "Reduced Regression". What is the adjusted R' for this new model? What does the R' tell you about this model? Are all the slopes for the individual coefficients significant for this reduced model? Based on the above evidence, is the reduced model a good model? what is the resulting regression equation. Use the actual coefficient values and variable names. Copy and P Intercept: Estimated Value Slope: 3. What is the point prediction for the winning bid for a residential property coming up Buyer Slope: for auction on July 10, 1011 with an estimated value of $1,500,000? Use the regression equation in part 2 for the point prediction. Winning Bid Buyer: Forecast Nonresident Resident 4. Does this prediction change if there is a lot of interst in the property (that is, many bids are expected]? Compute a 959% prediction interval (PI) about the point predictions in part 3. Copy and P