Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Day Monday Monday Monday Monday Monday Monday Monday Monday Monday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday

Day Monday Monday Monday Monday Monday Monday Monday Monday Monday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Friday Friday Friday Friday Friday Friday Friday Friday Friday Saturday Hour Temperature 1:00 P.M. to 2:00 P.M. 82 2:00 P.M. to 3:00 P.M. 83 3:00 P.M. to 4:00 P.M. 87 4:00 P.M. to 5:00 P.M. 93 5:00 P.M. to 6:00 P.M. 95 6:00 P.M. to 7:00 P.M. 96 7:00 P.M. to 8:00 P.M. 93 8:00 P.M. to 9:00 P.M. 89 9:00 P.M. to 10:00 P.M. 86 1:00 P.M. to 2:00 P.M. 86 2:00 P.M. to 3:00 P.M. 90 3:00 P.M. to 4:00 P.M. 92 4:00 P.M. to 5:00 P.M. 96 5:00 P.M. to 6:00 P.M. 99 6:00 P.M. to 7:00 P.M. 100 7:00 P.M. to 8:00 P.M. 97 8:00 P.M. to 9:00 P.M. 94 9:00 P.M. to 10:00 P.M. 93 1:00 P.M. to 2:00 P.M. 90 2:00 P.M. to 3:00 P.M. 94 3:00 P.M. to 4:00 P.M. 96 4:00 P.M. to 5:00 P.M. 98 5:00 P.M. to 6:00 P.M. 100 6:00 P.M. to 7:00 P.M. 103 7:00 P.M. to 8:00 P.M. 101 8:00 P.M. to 9:00 P.M. 98 9:00 P.M. to 10:00 P.M. 95 1:00 P.M. to 2:00 P.M. 88 2:00 P.M. to 3:00 P.M. 90 3:00 P.M. to 4:00 P.M. 92 4:00 P.M. to 5:00 P.M. 95 5:00 P.M. to 6:00 P.M. 99 6:00 P.M. to 7:00 P.M. 99 7:00 P.M. to 8:00 P.M. 97 8:00 P.M. to 9:00 P.M. 94 9:00 P.M. to 10:00 P.M. 92 1:00 P.M. to 2:00 P.M. 90 2:00 P.M. to 3:00 P.M. 93 3:00 P.M. to 4:00 P.M. 96 4:00 P.M. to 5:00 P.M. 99 5:00 P.M. to 6:00 P.M. 103 6:00 P.M. to 7:00 P.M. 105 7:00 P.M. to 8:00 P.M. 104 8:00 P.M. to 9:00 P.M. 101 9:00 P.M. to 10:00 P.M. 99 1:00 P.M. to 2:00 P.M. 88 Sales 55.49 61.89 44.79 68.62 58.82 51.85 66.2 52.89 61.95 59.55 47.07 53.29 47.42 60.52 71.98 55.71 64.95 60.12 48.72 66.41 65.27 54.76 48.08 53.59 62.99 66.35 67.92 47.85 56.62 46.05 56.72 69.94 65.72 51.01 73.51 65.57 63.26 44.09 65.69 48.62 68.16 67.79 62.79 70.16 68.05 60.43 Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday 2:00 P.M. to 3:00 P.M. 3:00 P.M. to 4:00 P.M. 4:00 P.M. to 5:00 P.M. 5:00 P.M. to 6:00 P.M. 6:00 P.M. to 7:00 P.M. 7:00 P.M. to 8:00 P.M. 8:00 P.M. to 9:00 P.M. 9:00 P.M. to 10:00 P.M. 90 92 95 97 99 98 95 92 63.78 67.8 69.53 61.8 57.92 53.97 71.55 57.93 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Squ Standard Error Observations 0.4600 0.2116 0.0503 7.8422 54 ANOVA df Regression Residual Total Intercept Temperature Hour 1 Hour2 Hour3 Hour4 Hour5 Hour6 Hour7 Hour8 9 44 53 SS 726.281 2705.971 3432.252 Coefficients Standard Error 21.834 31.725 0.450 0.340 -5.233 4.899 -5.672 4.629 -6.292 4.529 -7.403 4.654 -5.069 4.966 -5.488 5.196 -7.286 4.899 1.929 4.597 MS 80.698 61.499 t Stat 0.688 1.323 -1.068 -1.225 -1.389 -1.591 -1.021 -1.056 -1.487 0.420 F Significance F 1.312 0.258 P-value Lower 95% Upper 95% 0.495 -42.105 85.772 0.193 -0.235 1.135 0.291 -15.105 4.640 0.227 -15.001 3.657 0.172 -15.420 2.836 0.119 -16.782 1.977 0.313 -15.077 4.940 0.297 -15.961 4.984 0.144 -17.158 2.587 0.677 -7.335 11.193 Lower 95.0%Upper 95.0% -42.105 85.772 -0.235 1.135 -15.105 4.640 -15.001 3.657 -15.420 2.836 -16.782 1.977 -15.077 4.940 -15.961 4.984 -17.158 2.587 -7.335 11.193 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.256 0.066 0.048 7.853 54 ANOVA df Regression Residual Total Intercept Temperature SS 1 225.031 52 3207.222 53 3432.252 MS 225.031 61.677 F 3.649 Coefficients Standard Error t Stat P-value 22.264 19.72198 1.128896 0.264123 0.398 0.208188 1.910108 0.061642 Significance F 0.062 Lower 95% Upper 95%Lower 95.0% -17.310984453 61.8391 -17.31098 -0.0200981309 0.81542 -0.020098 59.25 Upper 95.0% 61.8391 0.81542 SUMMARY OUTPUT Regression Statistics Multiple R 0.256054 R Square 0.065564 Adjusted R 0.047594 Standard E 7.853492 Observatio 54 ANOVA df Regression Residual Total SS MS F Significance F 1 225.0306 225.0306 3.648513 0.061642 52 3207.222 61.677 53 3432.252 Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 22.26406 19.72198 1.128896 0.264123 -17.31098 61.8391 -17.31098 61.8391 Temperatu 0.397661 0.208188 1.910108 0.061642 -0.020098 0.81542 -0.020098 0.81542 Upper 95.0% SUMMARY OUTPUT Regression Statistics Multiple R 0.256054 R Square 0.065564 Adjusted R 0.047594 Standard E 7.853492 Observatio 54 ANOVA df Regression Residual Total SS MS F Significance F 1 225.0306 225.0306 3.648513 0.061642 52 3207.222 61.67734 53 3432.252 Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 22.26406 19.72198 1.128896 0.264123 -17.31098 61.8391 -17.31098 61.8391 Temperatu 0.397661 0.208188 1.910108 0.061642 -0.020098 0.81542 -0.020098 0.81542 RESIDUAL OUTPUT Observation Predicted SalesResiduals 1 54.87224 0.617765 2 55.2699 6.620104 3 56.86054 -12.07054 4 59.2465 9.373497 5 60.04182 -1.221825 6 60.43949 -8.589485 7 59.2465 6.953497 8 57.65586 -4.76586 9 56.46288 5.487122 10 56.46288 3.087122 11 58.05352 -10.98352 12 58.84884 -5.558843 13 60.43949 -13.01949 14 61.63247 -1.112468 15 62.03013 9.949872 16 60.83715 -5.127146 17 59.64416 5.305836 18 59.2465 0.873497 19 58.05352 -9.333521 20 59.64416 6.765836 21 60.43949 4.830515 22 61.23481 -6.474807 23 62.03013 -13.95013 24 63.22311 -9.63311 0.381633 43.82577 145.6979 87.86244 1.492856 73.77926 48.35112 22.71343 30.1085 9.53032 120.6377 30.90073 169.507 1.237584 98.99995 26.28763 28.1519 0.762996 87.11462 45.77654 23.33387 41.92312 194.6061 92.79682 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 62.42779 61.23481 60.04182 57.2582 58.05352 58.84884 60.04182 61.63247 61.63247 60.83715 59.64416 58.84884 58.05352 59.2465 60.43949 61.63247 63.22311 64.01843 63.62077 62.42779 61.63247 57.2582 58.05352 58.84884 60.04182 60.83715 61.63247 61.23481 60.04182 58.84884 0.562211 5.115193 7.878175 -9.4082 -1.433521 -12.79884 -3.321825 8.307532 4.087532 -9.827146 13.86584 6.721157 5.206479 -15.1565 5.250515 -13.01247 4.93689 3.771568 -0.830771 7.732211 6.417532 3.1718 5.726479 8.951157 9.488175 0.962854 -3.712468 -7.264807 11.50818 -0.918843 0.316081 26.1652 62.06565 88.51422 2.054983 163.8104 11.03452 69.01509 16.70792 96.5728 192.2614 45.17396 27.10742 229.7196 27.5679 169.3243 24.37288 14.22473 0.690181 59.78709 41.18472 10.06032 32.79256 80.12322 90.02547 0.927088 13.78242 52.77742 132.4381 0.844272 Sum of err 3207.222 3207.222 MSE 59.393 MSE=Sum of error/Count 59.393 Upper 95.0% Count 54 MSE=Sum of error/Count SUMMARY OUTPUT Regression Statistics Multiple R 0.460005 R Square 0.211605 Adjusted R 0.050342 Standard E 7.842151 Observatio 54 ANOVA df Regression Residual Total SS MS F Significance F 9 726.2814 80.69793 1.312176 0.258252 44 2705.971 61.49934 53 3432.252 Coefficients Standard Error t Stat Intercept 21.83361 31.72532 0.688208 Temperatu 0.449799 0.34 1.322938 Hour 1 -5.232769 4.898641 -1.068208 Hour2 -5.672235 4.629016 -1.225365 Hour3 -6.291734 4.529086 -1.389184 Hour4 -7.402698 4.653922 -1.590636 Hour5 -5.068797 4.966023 -1.020695 Hour6 -5.488496 5.196373 -1.056217 Hour7 -7.285564 4.898641 -1.487262 Hour8 1.928801 4.596646 0.419611 RESIDUAL OUTPUT Observation Predicted SalesResiduals 1 53.4844 2.005597 2 53.49474 8.395263 3 54.67444 -9.884436 4 56.26227 12.35773 5 59.49577 -0.675769 6 59.52587 -7.675869 7 56.3794 9.820597 8 63.79457 -10.90457 9 60.51637 1.43363 10 55.2836 4.266399 11 56.64333 -9.573333 12 56.92343 -3.633434 13 57.61167 -10.19167 14 61.29497 -0.774967 15 61.32507 10.65493 16 58.1786 -2.468601 4.022421 70.48044 97.70208 152.7135 0.456663 58.91896 96.44413 118.9096 2.055295 18.20216 91.64871 13.20184 103.8701 0.600573 113.5276 6.093989 P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% 0.494935 -42.10458 85.7718 -42.10458 85.7718 0.19269 -0.235426 1.135025 -0.235426 1.135025 0.291252 -15.10533 4.639794 -15.10533 4.639794 0.226957 -15.0014 3.656935 -15.0014 3.656935 0.171768 -15.41951 2.836041 -15.41951 2.836041 0.118852 -16.78206 1.976666 -16.78206 1.976666 0.312978 -15.07716 4.939566 -15.07716 4.939566 0.296634 -15.9611 4.984106 -15.9611 4.984106 0.144077 -17.15813 2.586999 -17.15813 2.586999 0.676812 -7.335131 11.19273 -7.335131 11.19273 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 66.04357 63.66497 57.0828 58.44253 58.72263 58.51127 61.74477 62.67447 59.9778 67.84277 64.56457 56.1832 56.64333 56.92343 57.16187 61.29497 60.87527 58.1786 66.04357 63.21517 57.0828 57.99273 58.72263 58.96107 63.09416 63.57406 61.3272 69.19216 66.36376 56.1832 56.64333 56.92343 57.16187 60.39537 60.87527 58.6284 66.49337 63.21517 -1.093567 -3.544967 -8.362799 7.967469 6.547368 -3.751266 -13.66477 -9.084465 3.012201 -1.492765 3.355434 -8.3332 -0.023333 -10.87343 -0.441867 8.645033 4.844733 -7.168601 7.466433 2.354833 6.177201 -13.90273 6.967368 -10.34107 5.065835 4.215936 1.462803 0.967836 1.686236 4.2468 7.136667 10.87657 12.36813 1.404632 -2.955267 -4.6584 5.056633 -5.285167 Sum of error 1.195889 12.56679 69.9364 63.48056 42.86803 14.07199 186.7258 82.52751 9.073357 2.228348 11.25894 69.44222 0.000544 118.2316 0.195247 74.7366 23.47143 51.38884 55.74762 5.545238 38.15782 193.286 48.54422 106.9376 25.66269 17.77411 2.139792 0.936707 2.843393 18.03531 50.93201 118.2997 152.9707 1.972992 8.733605 21.70069 25.56954 27.93299 2705.971 MSE 50.111 Upper 95.0% MSE=Sum of error/Count =2705.971/54 Day Monday Monday Monday Monday Monday Monday Monday Monday Monday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Friday Friday Friday Friday Friday Friday Friday Friday Friday Hour Temperature Hour 1 Hour2 Hour3 Hour4 1 1:00 P.M. to 2:00 P.M. 82 0 0 0 0 1 2:00 P.M. to 3:00 P.M. 83 0 0 3:00 P.M. to 4:00 P.M. 87 0 0 1 0 0 0 1 4:00 P.M. to 5:00 P.M. 93 0 0 0 5:00 P.M. to 6:00 P.M. 95 0 0 0 0 6:00 P.M. to 7:00 P.M. 96 0 0 0 0 7:00 P.M. to 8:00 P.M. 93 0 0 0 0 8:00 P.M. to 9:00 P.M. 89 0 0 0 0 9:00 P.M. to 10:00 P.M. 86 0 0 1 1:00 P.M. to 2:00 P.M. 86 0 0 0 0 1 2:00 P.M. to 3:00 P.M. 90 0 0 0 0 1 3:00 P.M. to 4:00 P.M. 92 0 0 0 1 4:00 P.M. to 5:00 P.M. 96 0 0 0 5:00 P.M. to 6:00 P.M. 99 0 0 0 0 6:00 P.M. to 7:00 P.M. 100 0 0 0 0 7:00 P.M. to 8:00 P.M. 97 0 0 0 0 8:00 P.M. to 9:00 P.M. 94 0 0 0 0 9:00 P.M. to 10:00 P.M. 93 0 0 1 0 1:00 P.M. to 2:00 P.M. 90 0 0 0 1 2:00 P.M. to 3:00 P.M. 94 0 0 0 0 1 3:00 P.M. to 4:00 P.M. 96 0 0 0 0 1 4:00 P.M. to 5:00 P.M. 98 0 0 0 0 5:00 P.M. to 6:00 P.M. 100 0 0 0 0 6:00 P.M. to 7:00 P.M. 103 7:00 P.M. to 8:00 P.M. 101 0 0 0 0 0 0 0 0 8:00 P.M. to 9:00 P.M. 98 0 0 0 0 9:00 P.M. to 10:00 P.M. 95 1:00 P.M. to 2:00 P.M. 88 1 0 0 0 0 1 0 0 2:00 P.M. to 3:00 P.M. 90 0 0 1 0 3:00 P.M. to 4:00 P.M. 92 4:00 P.M. to 5:00 P.M. 95 0 0 0 1 0 0 0 0 5:00 P.M. to 6:00 P.M. 99 0 0 0 0 6:00 P.M. to 7:00 P.M. 99 7:00 P.M. to 8:00 P.M. 97 0 0 0 0 0 0 0 0 8:00 P.M. to 9:00 P.M. 94 0 0 0 0 9:00 P.M. to 10:00 P.M. 92 1 0 0 0 1:00 P.M. to 2:00 P.M. 90 0 1 0 0 2:00 P.M. to 3:00 P.M. 93 0 0 1 0 3:00 P.M. to 4:00 P.M. 96 0 0 0 1 4:00 P.M. to 5:00 P.M. 99 0 0 0 0 5:00 P.M. to 6:00 P.M. 103 0 0 0 0 6:00 P.M. to 7:00 P.M. 105 0 0 0 0 7:00 P.M. to 8:00 P.M. 104 0 0 0 0 8:00 P.M. to 9:00 P.M. 101 0 0 0 0 9:00 P.M. to 10:00 P.M. 99 Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday 1:00 P.M. to 2:00 P.M. 2:00 P.M. to 3:00 P.M. 3:00 P.M. to 4:00 P.M. 4:00 P.M. to 5:00 P.M. 5:00 P.M. to 6:00 P.M. 6:00 P.M. to 7:00 P.M. 7:00 P.M. to 8:00 P.M. 8:00 P.M. to 9:00 P.M. 9:00 P.M. to 10:00 P.M. 88 90 92 95 97 99 98 95 92 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 Hour5 Hour6 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 Hour7 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 Hour8 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 Sales 55.49 61.89 44.79 68.62 58.82 51.85 66.2 52.89 61.95 59.55 47.07 53.29 47.42 60.52 71.98 55.71 64.95 60.12 48.72 66.41 65.27 54.76 48.08 53.59 62.99 66.35 67.92 47.85 56.62 46.05 56.72 69.94 65.72 51.01 73.51 65.57 63.26 44.09 65.69 48.62 68.16 67.79 62.79 70.16 68.05 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 60.43 63.78 67.8 69.53 61.8 57.92 53.97 71.55 57.93 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Squ Standard Error Observations 0.4600 0.2116 0.0503 7.8422 54 ANOVA df Regression Residual Total Intercept Temperature Hour 1 Hour2 Hour3 Hour4 Hour5 Hour6 Hour7 Hour8 9 44 53 SS 726.281 2705.971 3432.252 Coefficients Standard Error 21.834 31.725 0.450 0.340 -5.233 4.899 -5.672 4.629 -6.292 4.529 -7.403 4.654 -5.069 4.966 -5.488 5.196 -7.286 4.899 1.929 4.597 MS 80.698 61.499 t Stat 0.688 1.323 -1.068 -1.225 -1.389 -1.591 -1.021 -1.056 -1.487 0.420 F Significance F 1.312 0.258 P-value Lower 95% Upper 95% 0.495 -42.105 85.772 0.193 -0.235 1.135 0.291 -15.105 4.640 0.227 -15.001 3.657 0.172 -15.420 2.836 0.119 -16.782 1.977 0.313 -15.077 4.940 0.297 -15.961 4.984 0.144 -17.158 2.587 0.677 -7.335 11.193 Lower 95.0%Upper 95.0% -42.105 85.772 -0.235 1.135 -15.105 4.640 -15.001 3.657 -15.420 2.836 -16.782 1.977 -15.077 4.940 -15.961 4.984 -17.158 2.587 -7.335 11.193 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.256 0.066 0.048 7.853 54 ANOVA df Regression Residual Total Intercept Temperature SS 1 225.031 52 3207.222 53 3432.252 MS 225.031 61.677 F 3.649 Coefficients Standard Error t Stat P-value 22.264 19.72198 1.128896 0.264123 0.398 0.208188 1.910108 0.061642 Significance F 0.062 Lower 95% Upper 95%Lower 95.0% -17.310984453 61.8391 -17.31098 -0.0200981309 0.81542 -0.020098 59.25 Upper 95.0% 61.8391 0.81542 SUMMARY OUTPUT Regression Statistics Multiple R 0.256054 R Square 0.065564 Adjusted R 0.047594 Standard E 7.853492 Observatio 54 ANOVA df Regression Residual Total SS MS F Significance F 1 225.0306 225.0306 3.648513 0.061642 52 3207.222 61.677 53 3432.252 Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 22.26406 19.72198 1.128896 0.264123 -17.31098 61.8391 -17.31098 61.8391 Temperatu 0.397661 0.208188 1.910108 0.061642 -0.020098 0.81542 -0.020098 0.81542 Upper 95.0% SUMMARY OUTPUT Regression Statistics Multiple R 0.256054 R Square 0.065564 Adjusted R 0.047594 Standard E 7.853492 Observatio 54 ANOVA df Regression Residual Total SS MS F Significance F 1 225.0306 225.0306 3.648513 0.061642 52 3207.222 61.67734 53 3432.252 Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 22.26406 19.72198 1.128896 0.264123 -17.31098 61.8391 -17.31098 61.8391 Temperatu 0.397661 0.208188 1.910108 0.061642 -0.020098 0.81542 -0.020098 0.81542 RESIDUAL OUTPUT Observation Predicted SalesResiduals 1 54.87224 0.617765 2 55.2699 6.620104 3 56.86054 -12.07054 4 59.2465 9.373497 5 60.04182 -1.221825 6 60.43949 -8.589485 7 59.2465 6.953497 8 57.65586 -4.76586 9 56.46288 5.487122 10 56.46288 3.087122 11 58.05352 -10.98352 12 58.84884 -5.558843 13 60.43949 -13.01949 14 61.63247 -1.112468 15 62.03013 9.949872 16 60.83715 -5.127146 17 59.64416 5.305836 18 59.2465 0.873497 19 58.05352 -9.333521 20 59.64416 6.765836 21 60.43949 4.830515 22 61.23481 -6.474807 23 62.03013 -13.95013 24 63.22311 -9.63311 0.381633 43.82577 145.6979 87.86244 1.492856 73.77926 48.35112 22.71343 30.1085 9.53032 120.6377 30.90073 169.507 1.237584 98.99995 26.28763 28.1519 0.762996 87.11462 45.77654 23.33387 41.92312 194.6061 92.79682 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 62.42779 61.23481 60.04182 57.2582 58.05352 58.84884 60.04182 61.63247 61.63247 60.83715 59.64416 58.84884 58.05352 59.2465 60.43949 61.63247 63.22311 64.01843 63.62077 62.42779 61.63247 57.2582 58.05352 58.84884 60.04182 60.83715 61.63247 61.23481 60.04182 58.84884 0.562211 5.115193 7.878175 -9.4082 -1.433521 -12.79884 -3.321825 8.307532 4.087532 -9.827146 13.86584 6.721157 5.206479 -15.1565 5.250515 -13.01247 4.93689 3.771568 -0.830771 7.732211 6.417532 3.1718 5.726479 8.951157 9.488175 0.962854 -3.712468 -7.264807 11.50818 -0.918843 0.316081 26.1652 62.06565 88.51422 2.054983 163.8104 11.03452 69.01509 16.70792 96.5728 192.2614 45.17396 27.10742 229.7196 27.5679 169.3243 24.37288 14.22473 0.690181 59.78709 41.18472 10.06032 32.79256 80.12322 90.02547 0.927088 13.78242 52.77742 132.4381 0.844272 Sum of err 3207.222 3207.222 MSE 59.393 MSE=Sum of error/Count 59.393 Upper 95.0% Count 54 MSE=Sum of error/Count SUMMARY OUTPUT Regression Statistics Multiple R 0.460005 R Square 0.211605 Adjusted R 0.050342 Standard E 7.842151 Observatio 54 ANOVA df Regression Residual Total SS MS F Significance F 9 726.2814 80.69793 1.312176 0.258252 44 2705.971 61.49934 53 3432.252 Coefficients Standard Error t Stat Intercept 21.83361 31.72532 0.688208 Temperatu 0.449799 0.34 1.322938 Hour 1 -5.232769 4.898641 -1.068208 Hour2 -5.672235 4.629016 -1.225365 Hour3 -6.291734 4.529086 -1.389184 Hour4 -7.402698 4.653922 -1.590636 Hour5 -5.068797 4.966023 -1.020695 Hour6 -5.488496 5.196373 -1.056217 Hour7 -7.285564 4.898641 -1.487262 Hour8 1.928801 4.596646 0.419611 RESIDUAL OUTPUT Observation Predicted SalesResiduals 1 53.4844 2.005597 2 53.49474 8.395263 3 54.67444 -9.884436 4 56.26227 12.35773 5 59.49577 -0.675769 6 59.52587 -7.675869 7 56.3794 9.820597 8 63.79457 -10.90457 9 60.51637 1.43363 10 55.2836 4.266399 11 56.64333 -9.573333 12 56.92343 -3.633434 13 57.61167 -10.19167 14 61.29497 -0.774967 15 61.32507 10.65493 16 58.1786 -2.468601 4.022421 70.48044 97.70208 152.7135 0.456663 58.91896 96.44413 118.9096 2.055295 18.20216 91.64871 13.20184 103.8701 0.600573 113.5276 6.093989 P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% 0.494935 -42.10458 85.7718 -42.10458 85.7718 0.19269 -0.235426 1.135025 -0.235426 1.135025 0.291252 -15.10533 4.639794 -15.10533 4.639794 0.226957 -15.0014 3.656935 -15.0014 3.656935 0.171768 -15.41951 2.836041 -15.41951 2.836041 0.118852 -16.78206 1.976666 -16.78206 1.976666 0.312978 -15.07716 4.939566 -15.07716 4.939566 0.296634 -15.9611 4.984106 -15.9611 4.984106 0.144077 -17.15813 2.586999 -17.15813 2.586999 0.676812 -7.335131 11.19273 -7.335131 11.19273 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 66.04357 63.66497 57.0828 58.44253 58.72263 58.51127 61.74477 62.67447 59.9778 67.84277 64.56457 56.1832 56.64333 56.92343 57.16187 61.29497 60.87527 58.1786 66.04357 63.21517 57.0828 57.99273 58.72263 58.96107 63.09416 63.57406 61.3272 69.19216 66.36376 56.1832 56.64333 56.92343 57.16187 60.39537 60.87527 58.6284 66.49337 63.21517 -1.093567 -3.544967 -8.362799 7.967469 6.547368 -3.751266 -13.66477 -9.084465 3.012201 -1.492765 3.355434 -8.3332 -0.023333 -10.87343 -0.441867 8.645033 4.844733 -7.168601 7.466433 2.354833 6.177201 -13.90273 6.967368 -10.34107 5.065835 4.215936 1.462803 0.967836 1.686236 4.2468 7.136667 10.87657 12.36813 1.404632 -2.955267 -4.6584 5.056633 -5.285167 Sum of error 1.195889 12.56679 69.9364 63.48056 42.86803 14.07199 186.7258 82.52751 9.073357 2.228348 11.25894 69.44222 0.000544 118.2316 0.195247 74.7366 23.47143 51.38884 55.74762 5.545238 38.15782 193.286 48.54422 106.9376 25.66269 17.77411 2.139792 0.936707 2.843393 18.03531 50.93201 118.2997 152.9707 1.972992 8.733605 21.70069 25.56954 27.93299 2705.971 MSE 50.111 Upper 95.0% MSE=Sum of error/Count =2705.971/54 Day Monday Monday Monday Monday Monday Monday Monday Monday Monday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Tuesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Wednesday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Thursday Friday Friday Friday Friday Friday Friday Friday Friday Friday Hour Temperature Hour 1 Hour2 Hour3 Hour4 1 1:00 P.M. to 2:00 P.M. 82 0 0 0 0 1 2:00 P.M. to 3:00 P.M. 83 0 0 3:00 P.M. to 4:00 P.M. 87 0 0 1 0 0 0 1 4:00 P.M. to 5:00 P.M. 93 0 0 0 5:00 P.M. to 6:00 P.M. 95 0 0 0 0 6:00 P.M. to 7:00 P.M. 96 0 0 0 0 7:00 P.M. to 8:00 P.M. 93 0 0 0 0 8:00 P.M. to 9:00 P.M. 89 0 0 0 0 9:00 P.M. to 10:00 P.M. 86 0 0 1 1:00 P.M. to 2:00 P.M. 86 0 0 0 0 1 2:00 P.M. to 3:00 P.M. 90 0 0 0 0 1 3:00 P.M. to 4:00 P.M. 92 0 0 0 1 4:00 P.M. to 5:00 P.M. 96 0 0 0 5:00 P.M. to 6:00 P.M. 99 0 0 0 0 6:00 P.M. to 7:00 P.M. 100 0 0 0 0 7:00 P.M. to 8:00 P.M. 97 0 0 0 0 8:00 P.M. to 9:00 P.M. 94 0 0 0 0 9:00 P.M. to 10:00 P.M. 93 0 0 1 0 1:00 P.M. to 2:00 P.M. 90 0 0 0 1 2:00 P.M. to 3:00 P.M. 94 0 0 0 0 1 3:00 P.M. to 4:00 P.M. 96 0 0 0 0 1 4:00 P.M. to 5:00 P.M. 98 0 0 0 0 5:00 P.M. to 6:00 P.M. 100 0 0 0 0 6:00 P.M. to 7:00 P.M. 103 7:00 P.M. to 8:00 P.M. 101 0 0 0 0 0 0 0 0 8:00 P.M. to 9:00 P.M. 98 0 0 0 0 9:00 P.M. to 10:00 P.M. 95 1:00 P.M. to 2:00 P.M. 88 1 0 0 0 0 1 0 0 2:00 P.M. to 3:00 P.M. 90 0 0 1 0 3:00 P.M. to 4:00 P.M. 92 4:00 P.M. to 5:00 P.M. 95 0 0 0 1 0 0 0 0 5:00 P.M. to 6:00 P.M. 99 0 0 0 0 6:00 P.M. to 7:00 P.M. 99 7:00 P.M. to 8:00 P.M. 97 0 0 0 0 0 0 0 0 8:00 P.M. to 9:00 P.M. 94 0 0 0 0 9:00 P.M. to 10:00 P.M. 92 1 0 0 0 1:00 P.M. to 2:00 P.M. 90 0 1 0 0 2:00 P.M. to 3:00 P.M. 93 0 0 1 0 3:00 P.M. to 4:00 P.M. 96 0 0 0 1 4:00 P.M. to 5:00 P.M. 99 0 0 0 0 5:00 P.M. to 6:00 P.M. 103 0 0 0 0 6:00 P.M. to 7:00 P.M. 105 0 0 0 0 7:00 P.M. to 8:00 P.M. 104 0 0 0 0 8:00 P.M. to 9:00 P.M. 101 0 0 0 0 9:00 P.M. to 10:00 P.M. 99 Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday Saturday 1:00 P.M. to 2:00 P.M. 2:00 P.M. to 3:00 P.M. 3:00 P.M. to 4:00 P.M. 4:00 P.M. to 5:00 P.M. 5:00 P.M. to 6:00 P.M. 6:00 P.M. to 7:00 P.M. 7:00 P.M. to 8:00 P.M. 8:00 P.M. to 9:00 P.M. 9:00 P.M. to 10:00 P.M. 88 90 92 95 97 99 98 95 92 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 Hour5 Hour6 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 Hour7 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 Hour8 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 Sales 55.49 61.89 44.79 68.62 58.82 51.85 66.2 52.89 61.95 59.55 47.07 53.29 47.42 60.52 71.98 55.71 64.95 60.12 48.72 66.41 65.27 54.76 48.08 53.59 62.99 66.35 67.92 47.85 56.62 46.05 56.72 69.94 65.72 51.01 73.51 65.57 63.26 44.09 65.69 48.62 68.16 67.79 62.79 70.16 68.05 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 60.43 63.78 67.8 69.53 61.8 57.92 53.97 71.55 57.93

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Robert F Blitzer

7th Edition

013449492X, 9780134453262

More Books

Students also viewed these Mathematics questions