Business Statistics
Mike95DSCI_3710_Excel_Quiz_4_Prediction_Template.xls
Sheet1
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | ||
Intercept | 59.8479811539 | 43.8763985913 | 1.3640130702 | 0.1759277373 | -27.3071034677 | 147.0030657755 | |
42542 | Income1 | 0.0002782124 | 0.0013082731 | 0.2126562199 | 0.8320707598 | -0.0023205116 | 0.0028769364 |
10000 | Income2 | 0.0010363567 | 0.0010341939 | 1.0020913057 | 0.3189567269 | -0.0010179426 | 0.003090656 |
4 | Famlsize | 44.0613620903 | 3.9175286019 | 11.2472343071 | 6.57012769352658E-19 | 36.2796719842 | 51.8430521964 |
0 | Ownrent | -5.4859225254 | 16.5456193606 | -0.3315634432 | 0.7409813089 | -38.3517661632 | 27.3799211125 |
6000 | Autodebt | 0.0007875325 | 0.0033603667 | 0.2343591017 | 0.8152326913 | -0.0058874239 | 0.007462489 |
0 | ED | 25.7486300966 | 22.0348513808 | 1.1685411284 | 0.2456407174 | -18.0208997275 | 69.5181599207 |
0 | WD | 0.1262568948 | 20.3905897345 | 0.0061919197 | 0.9950731484 | -40.377148828 | 40.6296626176 |
1 | SD | 19.3841499408 | 20.7043112675 | 0.9362373706 | 0.3516289892 | -21.7424251311 | 60.5107250127 |
Pred Groc= | 282.402053786 | ||||||
Instructions for Predictions: | |||||||
1. Type the value for each explanatory variable in the PINK cells. | |||||||
2. Collect your prediction from the YELLOW cell. That contains a formula that re-creates the regression formula in the format Predicted Y = b0 + b1 * X1 + b2 * X2 + … + b8 * X8. The b coefficients are already in column C and the X values are typed in column A. |