Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, You just gave me 10 regressions about my project, but you get the 11 observations, but the correct observation should be 12. So could
Hello, You just gave me 10 regressions about my project, but you get the 11 observations, but the correct observation should be 12. So could you correct it?
No. of Wells 33 19 3 15 21 24 22 27 28 27 26 28 Rig Supplies 117232 80605 16186 60643 72093 80284 76560 118891 113896 116510 96517 108970 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Rig+ Fuel 241715 270708 39152 242111 166594 349277 132372 298665 419481 277908 505235 620436 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept 33 egression Statistics 0.7198326763 0.5181590819 0.4646212021 122457.511028065 11 df 1 9 10 Coefficients -48739.1256069925 16075.2890903205 SS MS 145135215606.029 145135215606.029 134962578064.699 14995842007.1887 280097793670.727 F 9.6783638782 Standard Error 118631.652930387 5167.2303056763 P-value 0.6907963932 0.0124985473 t Stat -0.4108441921 3.1110068914 Significance F 0.0124985473 Lower 95% Upper 95% Lower 95.0% Upper 95.0% -317102.569018059 219624.317804073 -317102.569018059 219624.317804073 4386.2020425069 27764.3761381341 4386.2020425069 27764.3761381341 Distance 3960 2260 485 2570 3035 3000 2745 3760 3755 4405 3380 4625 Rig Supplies 117232 80605 16186 60643 72093 80284 76560 118891 113896 116510 96517 108970 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Rig+ Fuel 241715 270708 39152 242111 166594 349277 132372 298665 419481 277908 505235 620436 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.7331151856 0.5374578753 0.4860643059 119980.104184506 11 ANOVA df Regression Residual Total Intercept 1 9 10 Coefficients -31637.419980077 3960 107.8762674833 SS MS 150540765069.603 150540765069.603 129557028601.124 14395225400.1249 280097793670.727 Standard Error 109327.596821302 33.3586208127 t Stat -0.2893818295 3.2338347586 F 10.457687246 Significance F 0.0102594403 P-value Lower 95% Upper 95% Lower 95.0% 0.7788447958 -278953.626220899 215678.786260745 -278953.626220899 0.0102594403 32.4138244707 183.3387104958 32.4138244707 Upper 95.0% 215678.786260745 183.3387104958 Weight 2353 1577 192 1984 2655 3043 3656 4604 4830 4335 4402 4340 Rig Supplies 117232 80605 16186 60643 72093 80284 76560 118891 113896 116510 96517 108970 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Rig+ Fuel 241715 270708 39152 242111 166594 349277 132372 298665 419481 277908 505235 620436 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept 2353 ssion Statistics 0.6676985326 0.4458213304 0.3842459227 131328.351282468 11 df 1 9 10 Coefficients 59882.6188103946 74.7720308014 SS MS 124873571015.586 124873571015.586 155224222655.141 17247135850.5712 280097793670.727 F 7.2402497491 Standard Error 98306.0042604391 27.7883271136 P-value 0.5574898188 0.0247652129 t Stat 0.6091450798 2.6907712183 Significance F 0.0247652129 Lower 95% Upper 95% Lower 95.0% Upper 95.0% -162501.012873429 282266.250494218 -162501.012873429 282266.250494218 11.9104675793 137.6335940236 11.9104675793 137.6335940236 Depth 68219 38004 7049 42228 65197 73771 71526 85405 92269 83872 83409 89135 Rig Supplies 117232 80605 16186 60643 72093 80284 76560 118891 113896 116510 96517 108970 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Rig+ Fuel 241715 270708 39152 242111 166594 349277 132372 298665 419481 277908 505235 620436 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept 68219 ression Statistics 0.6895400783 0.4754655195 0.4171839106 127767.562691633 11 df 1 9 10 Coefficients 14586.5471718375 4.3197679642 SS MS 133176842985.285 133176842985.285 146920950685.443 16324550076.1603 280097793670.727 F 8.1580712708 Standard Error 107746.913386884 1.5124000109 P-value 0.8952925961 0.0188960889 t Stat 0.1353778657 2.8562337563 Significance F 0.0188960889 Lower 95% Upper 95% Lower 95.0% Upper 95.0% -229153.904715699 258326.999059374 -229153.904715699 258326.999059374 0.8984814465 7.7410544818 0.8984814465 7.7410544818 Ton-Miles 278510 184797 31118 339253 372239 371278 453465 616432 647494 692815 557021 709685 Rig Supplies 117232 80605 16186 60643 72093 80284 76560 118891 113896 116510 96517 108970 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Rig+ Fuel 241715 270708 39152 242111 166594 349277 132372 298665 419481 277908 505235 620436 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.6923675094 0.479372768 0.4215252978 127290.803980177 11 ANOVA df Regression Residual Total Intercept 1 9 10 Coefficients 61455.830482676 278510 0.5317803803 SS MS 134271254669.448 134271254669.448 145826539001.279 16202948777.9199 280097793670.727 Standard Error 91951.1196318016 0.1847301642 t Stat 0.6683532591 2.8786873146 F 8.2868406554 Significance F 0.0182169415 P-value Lower 95% Upper 95% Lower 95.0% 0.5206789517 -146552.053419719 269463.71438507 -146552.053419719 0.0182169415 0.1138917162 0.9496690444 0.1138917162 Upper 95.0% 269463.71438507 0.9496690444 No. of Wells 33 19 3 15 21 24 22 27 28 27 26 28 Mud 83420 46470 6430 49870 73270 89780 91220 99760 12600 102050 103610 105730 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Mud+Fuel 207903 236573 29396 231338 167771 358773 147032 279534 318185 263448 512328 617196 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.6964580597 0.4850538289 0.4278375876 124829.441144499 11 ANOVA df Regression Residual Total Intercept 1 9 10 Coefficients -47197.5441890578 33 15336.4457753318 SS MS 132100562127.606 132100562127.606 140241504388.03 15582389376.4478 272342066515.636 Standard Error 120929.478420923 5267.316523971 t Stat -0.3902898185 2.9116241079 F 8.4775549459 Significance F 0.0172655503 P-value Lower 95% Upper 95% Lower 95.0% 0.7053988531 -320759.029992399 226363.941614284 -320759.029992399 0.0172655503 3420.9479719055 27251.9435787582 3420.9479719055 Upper 95.0% 226363.941614284 27251.9435787582 Distance 3960 2260 485 2570 3035 3000 2745 3760 3755 4405 3380 4625 Mud 83420 46470 6430 49870 73270 89780 91220 99760 12600 102050 103610 105730 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Mud+Fuel 207903 236573 29396 231338 167771 358773 147032 279534 318185 263448 512328 617196 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept 3960 gression Statistics 0.7177465927 0.5151601713 0.4612890792 121125.4083268 11 df SS MS 1 140299785634.719 140299785634.7 9 132042280880.918 14671364542.32 10 272342066515.636 Coefficients -34668.05481713 104.1423457669 Standard Error 110371.21443068 33.6770549969 t Stat -0.3141041348 3.0923828041 F 9.5628314074 Significance F 0.0128798307 P-value Lower 95% 0.7606007291 -284345.08810823 0.0128798307 27.9595545836 Upper 95% Lower 95.0% Upper 95.0% 215008.978474 -284345.0881082 215008.978474 180.3251369501 27.9595545836 180.3251369501 Weight 2353 1577 192 1984 2655 3043 3656 4604 4830 4335 4402 4340 Mud 83420 46470 6430 49870 73270 89780 91220 99760 12600 102050 103610 105730 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Mud+Fuel 207903 236573 29396 231338 167771 358773 147032 279534 318185 263448 512328 617196 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept 2353 ression Statistics 0.6385967431 0.4078058003 0.3420064448 133865.3519695 11 df SS MS 1 111062674394.285 111062674394 9 161279392121.352 17919932457.93 10 272342066515.636 Coefficients Standard Error 59084.84985999 100205.079349072 70.5160495126 28.3251419315 t Stat 0.5896392702 2.4895214888 F 6.1977172434 Significance F 0.0344490441 P-value Lower 95% 0.5699367774 -167594.78813828 0.0344490441 6.4401268051 Upper 95% Lower 95.0% Upper 95.0% 285764.4878583 -167594.7881383 285764.4878583 134.5919722202 6.4401268051 134.5919722202 Depth 68219 38004 7049 42228 65197 73771 71526 85405 92269 83872 83409 89135 Mud 83420 46470 6430 49870 73270 89780 91220 99760 12600 102050 103610 105730 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Mud+Fuel 207903 236573 29396 231338 167771 358773 147032 279534 318185 263448 512328 617196 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.6717109235 0.4511955647 0.3902172941 128867.948789222 11 ANOVA df Regression Residual Total Intercept 1 9 10 Coefficients 11342.6939845603 68219 4.1494051036 SS MS 122879532489.362 122879532489.362 149462534026.275 16606948225.1416 272342066515.636 Standard Error 108674.873528342 1.5254254135 t Stat 0.1043727369 2.7201625638 F 7.3992843732 Significance F 0.0236015324 P-value Lower 95% Upper 95% Lower 95.0% 0.9191625199 -234496.949583768 257182.337552888 -234496.949583768 0.0236015324 0.6986530781 7.6001571291 0.6986530781 Upper 95.0% 257182.337552888 7.6001571291 Ton-Miles 278510 184797 31118 339253 372239 371278 453465 616432 647494 692815 557021 709685 Mud 83420 46470 6430 49870 73270 89780 91220 99760 12600 102050 103610 105730 Fuel 124483 190103 22966 181468 94501 268993 55812 179774 305585 161398 408718 511466 Mud+Fuel 207903 236573 29396 231338 167771 358773 147032 279534 318185 263448 512328 617196 SUMMARY OUTPUT Regression Statistics Multiple R 0.6663795025 R Square 0.4440616414 Adjusted R Square 0.3822907127 Standard Error 129702.82333757 Observations 11 ANOVA df Regression Residual 1 9 Total Intercept 278510 SS MS 120936665080.003 120936665080 151405401435.633 16822822381.737 F 7.1888451495 10 272342066515.636 Coefficients 59133.490051337 Standard Error 93693.4912215073 t Stat 0.6311376519 P-value 0.5436442276 0.504684284 0.1882305956 2.6812021836 0.0251564723 Significance F 0.0251564723 Lower 95% Upper 95% Lower 95.0% -152815.912222966 271082.89232564 -152815.912222966 0.0788770939 0.9304914741 0.0788770939 Upper 95.0% 271082.892325641 0.9304914741Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started