Assgt_4_prediction_template

Assgt_4_prediction_template - 2. Collect your prediction...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Coefficients Standard Error t Stat P-value Lower 95%Upper 95% Intercept 59.85 43.88 1.36 0.18 -27.31 147 42542 Income1 0 0 0.21 0.83 0 0 10000 Income2 0 0 1 0.32 0 0 4 Famlsize 44.06 3.92 11.25 0 36.28 51.84 0 Ownrent -5.49 16.55 -0.33 0.74 -38.35 27.38 6000 Autodebt 0 0 0.23 0.82 -0.01 0.01 0 ED 25.75 22.03 1.17 0.25 -18.02 69.52 0 WD 0.13 20.39 0.01 1 -40.38 40.63 1 SD 19.38 20.7 0.94 0.35 -21.74 60.51 Pred Groc= 282.4 Instructions for Predictions: 1. Type the value for each explanatory variable in the PIN
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2. Collect your prediction from the YELLOW cell. That co formula that re-creates the regression formula in the form Predicted Y = b0 + b1 * X1 + b2 * X2 + + b8 * X8. The coefficients are already in column C and the X values are column A. INK cells. ontains a mat e b re typed in...
View Full Document

Page1 / 2

Assgt_4_prediction_template - 2. Collect your prediction...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online