Multiple Regression.xlsx

Multiple Regression.xlsx - SUMMARY OUTPUT Regression...

This preview shows page 1 - 6 out of 64 pages.

SUMMARY OUTPUT Regression Statistics Multiple R 0.9040739699 coeff of coreel between y and y^ R Square 0.817349743 0.817349743 Adjusted R Squa 0.8161197749 Standard Error 0.8299672165 Observations 300 ANOVA analysis of variation SS = sum of squares due to regression Regression 2 915.5160626236 Residual 297 204.5871373764 Total 299 1120.1032 when sst = 0 variablility is 1 Coefficients Standard Error Intercept 0.1273371368 0.2052034797 Miles, x1 0.0671817421 0.0024549786 Deliveries, x2 0.6899982804 0.0295210571 RESIDUAL OUTPUT Observation Predicted Time, y Residuals 1 9.6055044637 -0.3055044637 2 5.5564190807 -0.7564190807 3 9.6055044637 -0.7055044637 4 8.2255079029 -1.7255079029 5 4.8664208003 -0.6664208003 6 6.8818730619 -0.6818730619 7 7.235962632 0.164037368 8 7.2541434919 -1.2541434919 if you add a new variable that fits well to the regression model, the adj R square increases otherwise decreases df = # of independant variables time = 0.1273+0.0672miles +0.69deliveries
Image of page 1
9 8.2436887628 -0.6436887628 10 7.5536904824 -1.4536904824 11 6.9364156415 0.0635843585 12 7.2905052116 -0.2905052116 13 9.2877766133 0.3122233867 14 5.8741469311 0.6258530689 15 6.9545965013 0.2454034987 16 5.5564190807 0.4435809193 17 8.6159591928 1.2840408072 18 7.9259609124 0.6740390876 19 6.5641452115 -1.6641452115 20 8.2436887628 -0.7436887628 21 7.1996009123 0.0003990877 22 10.6495923143 -0.7495923143 23 4.1764225199 1.4235774801 24 7.5718713423 -0.0718713423 25 7.5536904824 0.2463095176 26 7.5718713423 -0.3718713423 27 7.235962632 -0.235962632 28 7.8895991927 0.8104008073 29 6.863692202 -0.463692202 30 8.9155061833 0.9844938167 31 4.8482399404 -0.7482399404 32 8.9336870432 0.3663129568 33 8.2800504825 0.8199495175 34 10.2955027441 -1.3955027441 35 5.5745999405 -0.1745999405 36 6.8818730619 -0.9818730619 37 8.9336870432 -0.1336870432 38 8.9518679031 -0.5518679031 39 7.8895991927 1.5104008073 40 8.6159591928 0.1840408072 41 4.8846016601 0.1153983399 42 5.2205103704 1.2794896296 43 9.3059574732 -0.6059574732 44 9.2695957535 -0.8695957535 45 5.2023295105 1.8976704895 46 7.235962632 -1.135962632 47 5.2023295105 -0.0023295105 48 10.9855010246 -0.9855010246 49 6.2464173611 -1.1464173611 50 3.5046050993 0.0953949007 51 8.9336870432 -0.5336870432 52 6.1918747815 0.2081252185 53 7.5718713423 -0.8718713423 54 9.6236853236 -1.1236853236 55 6.9182347816 -1.0182347816
Image of page 2
56 4.1946033797 -1.3946033797 57 7.5900522021 0.3099477979 58 8.5795974731 0.3204025269 59 6.2645982209 -0.2645982209 60 3.8405138096 -0.7405138096 61 6.6005069312 -0.3005069312 62 7.9441417723 -0.4441417723 63 7.2177817721 -0.0177817721 64 7.2177817721 0.7822182279 65 7.235962632 -0.435962632 66 5.9105086508 -0.8105086508 67 3.5046050993 -0.3046050993 68 6.863692202 -0.963692202 69 8.2255079029 -0.4255079029 70 5.8559660712 -0.0559660712 71 3.8405138096 -0.0405138096 72 6.5277834917 0.2722165083 73 5.5382382208 0.1617617792 74 6.2100556413 -0.7100556413 75 8.5977783329 0.6022216671 76 8.2800504825 0.7199495175 77 9.9777748937 -0.6777748937 78 9.2877766133 -0.4877766133 79 6.2645982209 0.8354017791 80 9.9595940339 0.8404059661 81 6.6005069312 0.2994930688 82 9.9777748937 -0.5777748937 83 4.53051209 -0.93051209 84 7.1996009123 0.4003990877 85 7.9441417723 0.5558582277 86 7.9077800525 -0.8077800525 87 6.9545965013 0.1454034987 88 5.8923277909 0.1076722091 89 4.53051209 0.76948791 90 6.5641452115 -0.2641452115 91 9.2877766133 0.9122233867 92 6.5459643516 1.0540356484 93 4.8846016601 1.1153983399 94 8.5977783329 0.3022216671 95 6.5277834917 1.0722165083 96 6.9545965013 -0.3545965013 97 7.9623226321 0.0376773679 98 10.313683604 -0.613683604 99 6.5277834917 -0.3277834917 100 3.8405138096 0.4594861904 101 4.8664208003 -0.6664208003 102 6.9182347816 1.0817652184
Image of page 3
103 4.53051209 0.96948791 104 8.5977783329 0.3022216671 105 6.863692202 0.236307798 106 4.1946033797 1.3053966203 107 8.2618696227 1.0381303773 108 7.5900522021 1.6099477979 109 6.2100556413 0.0899443587 110 8.2618696227 0.3381303773 111 10.9855010246 0.0144989754 112 5.8559660712 0.8440339288 113 5.5564190807 -0.0564190807 114 7.2905052116 0.8094947884 115 10.9855010246 -0.7855010246 116 8.2255079029 -0.5255079029 117 8.2618696227 -1.0618696227 118 8.9155061833 0.0844938167 119 10.9855010246 -0.5855010246 120 5.2205103704 -0.1205103704 121 6.2464173611 0.1535826389 122 5.5745999405 -1.4745999405 123 8.9155061833 -0.9155061833 124 9.2695957535 -0.7695957535 125 4.8664208003 -1.2664208003 126 7.2541434919 0.0458565081 127 7.6264139219 -0.7264139219 128 8.5977783329 0.1022216671 129 8.2436887628 0.5563112372 130 6.6005069312 1.6994930688 131 7.6264139219 1.6735860781 132 7.2723243517 0.2276756483 133 5.2205103704 0.4794896296 134 9.2695957535 -0.7695957535 135 8.2982313424 -0.8982313424 136 4.5123312301 1.3876687699 137 6.5277834917 1.4722165083 138 8.5795974731 0.1204025269 139 5.8923277909 0.2076722091 140 6.2464173611 0.8535826389 141 7.2905052116 -0.9905052116 142 5.5564190807 -0.3564190807 143 6.9364156415 -0.9364156415 144 8.2436887628 0.1563112372 145 7.2541434919 -0.0541434919 146 8.2982313424 -0.3982313424 147 6.2645982209 -1.0645982209 148 7.5718713423 -0.5718713423 149 7.5355096225 -0.6355096225
Image of page 4
150 8.9700487629 1.6299512371 151 9.6236853236 -0.6236853236 152 6.9000539217 -1.3000539217 153 8.9155061833 -0.1155061833 154 8.5977783329 0.5022216671 155 10.313683604 0.886316396 156 5.5745999405 -1.3745999405 157 7.2177817721 -0.9177817721 158 4.1764225199 -0.6764225199 159 6.2645982209 0.9354017791 160 4.8482399404 -0.0482399404 161 9.2877766133 -1.3877766133 162 6.8818730619 -1.1818730619 163 6.6005069312 -0.4005069312 164 7.5355096225 -0.5355096225 165 10.9855010246 1.2144989754 166 4.5123312301 -1.0123312301 167 6.2100556413 -0.5100556413 168 9.6055044637 0.3944955363 169 6.5459643516 -0.2459643516 170 6.2645982209 0.2354017791 171 6.1918747815 1.2081252185 172 7.5536904824 -0.7536904824 173 6.5459643516 -1.1459643516 174 3.5046050993 -0.0046050993 175 6.2464173611 0.2535826389 176 7.9077800525 1.4922199475 177 5.2205103704 -0.6205103704 178 7.608233062 0.691766938 179 8.2618696227 0.2381303773 180 6.5823260713 -0.7823260713 181 7.2723243517 -0.5723243517 182 10.313683604 -1.413683604 183 5.5745999405 -0.5745999405 184 6.8818730619 0.4181269381
Image of page 5

Want to read all 64 pages?

Image of page 6

Want to read all 64 pages?

You've reached the end of your free preview.

Want to read all 64 pages?

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern