Question: Please help I need it in 2 hours!! (c) Use a multiple linear regression model with the enusal variable outside temperature and dummy variables as

(c) Use a multiple linear regression model with the enusal variable outside temperature and dummy variables as follows to develep an equation to aceount for both seisonal etfects and the relaticnship between cutside temperature (in Fahrenheit) and hourly sales (in s) in the dats. x1=1ifthesaleswererecordedbetween1:00p.m.and2:00p.m,0otherwisex2=1ifthesaleswererecordedbetween2:00p.m.and3:00p.m.,0otherwisex8=1ifthesaluswererecordedbetween8:00p.m.and9:00p.m.,0otherwise Note that when the values of the eight dummy variables are equal to 0 , the observation corresponds to the 9:00-to-10:00-p.m. hour. (Use the variabie If for outdoor temperature. Round your numerical values to three decimal placts.) = Based on this model, comoute an estimate of hourly swies for today (in s) from 2:00 p.m, to 3:00 p.m. If the temperature at 2:00 p.m. is 924 . (Round your answer to two decimal places.) s (d) Is the model you developed in part (b) or the model you developed in part (c) more effective? Justify your answer. The model from part (b) is more effective. Even though it has a slightiy higher Mse, the hour of operation and outside temperature are highly cerrelated, so we should use the part (b) model since it's simpler. The model from part (b) is more effective since it has a signincantly lower Mse than the moce complicated model from part (d). The model from part (d) is more effective. Since the hour of operation and outside temperature are Nighly correloted, we should choose the model which uses both variables as predictors, regardiess of MSE. The model from part (d) is more effective since it has a significantily lower Mse than the simplor model from part (b), The model from part (d) is more effective. Even though the hour of operation and outside termperature are highly correiated, part (d)'s model has a slightily lower Mse, so we should use the mere eomplicated model. JceCreamsoles. sales (in 5 ) in the data. (Use the varlable Tfor outdoer temperature. Round your numerical values to three decimal places.) = 5 \begin{tabular}{|c|c|c|c|} \hline Day & Hour & Tenperature & Sales \\ \hline Monday & 1:00PM to 2:00PM & 2 & 55.49 \\ \hline Monday & 200PM to 3:00PM & 83 & 61.89 \\ \hline Monday & 3:00PM to 4:00PM & 87 & 44.79 \\ \hline Monday & 4,00PM to 5;00PM & 93 & 68.62 \\ \hline Monday & 5:00PM to 6:00PM & 95 & 58.82 \\ \hline Monday & 6:00DM to 7:00 PM & 96 & 51.85 \\ \hline Monday & 7.00PM to 8:00PM & 99 & 66.2 \\ \hline Monday & 8:00PM to 9:00PM & 99 & 52.89 \\ \hline Monday & 9:00 PM. D 10:00PM & 86 & 6193 \\ \hline Tuesday & 100PM to 2:00PM & 86 & 5955 \\ \hline Tuesday & 2:00PM to 3:00PM & 90 & 47.07 \\ \hline Tuesday & 3,00PM to 4:00 PM & 92 & 53.29 \\ \hline Tuesday & 400PM to 5:00PM & 96 & 47.42 \\ \hline Tuesday & 5:00 P M to 6:00 P M & 99 & 6052 \\ \hline Tvesday & 600PM to 7:00PM & 100 & 7198 \\ \hline Tuesday & 700PM to 8:00PM & 97. & 55.71 \\ \hline Tuesday & 8.00PM to 9:00PM & 94 & 6495 \\ \hline Tuesday & 9:00 PM. D 10:00 PM & 93 & 60.12 \\ \hline Wednesday & 1:00PM to 2:00PM & 90 & 48.72 \\ \hline Wednesday & 2:00PM to 3:00PM & 94 & 66.41 \\ \hline Wednesday & 300PM to 4:00PM & 96 & 65.27 \\ \hline Wednesday & 4,00 PM to 5:00 PM & 98 & 54.76 \\ \hline Wednesday & 5:00PM to 6:00PM & 100 & 48.08 \\ \hline Wodnesdy & 6:00PM to 7:00 PM & 103 & 53,59 \\ \hline Wednesday & 7.00PM to 8:00PM & 101 & 62.99 \\ \hline Wednesday & 8:00 PM to 9:00 PM & 98 & 6635 \\ \hline Wednesday & 9:00PM. 10:00PM & 98 & 6792 \\ \hline Thursday & 1:00PM to 2:00PM & 88 & 47.85 \\ \hline Thursdy & 2:00PM to 3:00PM & 90 & 56.62 \\ \hline Thursday & 3.00PM to 4:00 PM & 92 & 46.05 \\ \hline Thursday & 400PM to 5:00PM & 95 & 56.72 \\ \hline Thursday & 5:00PM to 6:00 PM & 99 & 69.94 \\ \hline Thursday & 6:00PM to 7:00PM & 99 & 65.72 \\ \hline Thursdy & 7,00PM to 8:00 PM & 97 & 51.01 \\ \hline Thursday & 8.00PM to 9:00PM & 94 & 7351 \\ \hline Thursday & 9:00 PM. o 10:00 PM & 92 & 6557 \\ \hline Friday & 1,00PM to 2:00PM & 90 & 6326 \\ \hline Friday & 2:00PM to 3:00PM & 95 & 44.09 \\ \hline Friduy & 3.00DM to 4:00PM & 96 & 65.69 \\ \hline Friday & 4:00 PM to 5:00 PM & 99 & 48.62 \\ \hline Friday & 500 PM to 6:00PM & 103 & 68.16 \\ \hline Friday & 6:00PM107:00PM & 105 & 67,79 \\ \hline Friday & 7.00PM to 8:00 PM & 104 & 62.79 \\ \hline Friduy & 8:00PM to 9:00PM & 10I & 70.16 \\ \hline Friday & 9:00PM. 10:00PM & 99 & 63.05 \\ \hline Saturday & 100PM to 2:00PM & 88 & 60.43 \\ \hline Sarurday & 2.00PM to 3:00PM & 90 & 63.78 \\ \hline Saturday & 3:00PM to 4:00 PM & 92 & 67.8 \\ \hline Saturday & 400 PM to 5:00 PM & 95 & 6953 \\ \hline Saturday & 5:00PM to 6:00 PM & 97 & 61.8 \\ \hline Saturday & 6.00PM to 7:00PM & 9 & 5792 \\ \hline Sarurday & 7,00PM108:00PM & 98 & 5397 \\ \hline Saturday & 8.00PM to 9:00PM & 95 & 7155 \\ \hline Saturday & 9:00 PM o 10:00 PM & 92: & 5793 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
