Hogs & Dawgs is an ice cream parlor on the border of north-central Louisiana and southern Arkansas that serves 43 flavors of ice creams, sherbets, frozen yoghurts, and sorbets. During the summer Hogs & Dawgs is open from 1:00 P.M. to 10:00 P.M. on Monday through Saturday, and the owner believes that sales change systematically from hour to hour throughout the day. She also believes her sales increase as the outdoor temperature increases. Hourly sales and the outside temperature at the start of each hour for the last week are provided in the DATAfileIceCreamSales.

Monday	1:00 P.M. to 2:00 P.M.	82	55.49
Monday	2:00 P.M. to 3:00 P.M.	83	61.89
Monday	3:00 P.M. to 4:00 P.M.	87	44.79
Monday	4:00 P.M. to 5:00 P.M.	93	68.62
Monday	5:00 P.M. to 6:00 P.M.	95	58.82
Monday	6:00 P.M. to 7:00 P.M.	96	51.85
Monday	7:00 P.M. to 8:00 P.M.	93	66.2
Monday	8:00 P.M. to 9:00 P.M.	89	52.89
Monday	9:00 P.M. to 10:00 P.M.	86	61.95
Tuesday	1:00 P.M. to 2:00 P.M.	86	59.55
Tuesday	2:00 P.M. to 3:00 P.M.	90	47.07
Tuesday	3:00 P.M. to 4:00 P.M.	92	53.29
Tuesday	4:00 P.M. to 5:00 P.M.	96	47.42
Tuesday	5:00 P.M. to 6:00 P.M.	99	60.52
Tuesday	6:00 P.M. to 7:00 P.M.	100	71.98
Tuesday	7:00 P.M. to 8:00 P.M.	97	55.71
Tuesday	8:00 P.M. to 9:00 P.M.	94	64.95
Tuesday	9:00 P.M. to 10:00 P.M.	93	60.12
Wednesday	1:00 P.M. to 2:00 P.M.	90	48.72
Wednesday	2:00 P.M. to 3:00 P.M.	94	66.41
Wednesday	3:00 P.M. to 4:00 P.M.	96	65.27
Wednesday	4:00 P.M. to 5:00 P.M.	98	54.76
Wednesday	5:00 P.M. to 6:00 P.M.	100	48.08
Wednesday	6:00 P.M. to 7:00 P.M.	103	53.59
Wednesday	7:00 P.M. to 8:00 P.M.	101	62.99
Wednesday	8:00 P.M. to 9:00 P.M.	98	66.35
Wednesday	9:00 P.M. to 10:00 P.M.	95	67.92
Thursday	1:00 P.M. to 2:00 P.M.	88	47.85
Thursday	2:00 P.M. to 3:00 P.M.	90	56.62
Thursday	3:00 P.M. to 4:00 P.M.	92	46.05
Thursday	4:00 P.M. to 5:00 P.M.	95	56.72
Thursday	5:00 P.M. to 6:00 P.M.	99	69.94
Thursday	6:00 P.M. to 7:00 P.M.	99	65.72
Thursday	7:00 P.M. to 8:00 P.M.	97	51.01
Thursday	8:00 P.M. to 9:00 P.M.	94	73.51
Thursday	9:00 P.M. to 10:00 P.M.	92	65.57
Friday	1:00 P.M. to 2:00 P.M.	90	63.26
Friday	2:00 P.M. to 3:00 P.M.	93	44.09
Friday	3:00 P.M. to 4:00 P.M.	96	65.69
Friday	4:00 P.M. to 5:00 P.M.	99	48.62
Friday	5:00 P.M. to 6:00 P.M.	103	68.16
Friday	6:00 P.M. to 7:00 P.M.	105	67.79
Friday	7:00 P.M. to 8:00 P.M.	104	62.79
Friday	8:00 P.M. to 9:00 P.M.	101	70.16
Friday	9:00 P.M. to 10:00 P.M.	99	68.05
Saturday	1:00 P.M. to 2:00 P.M.	88	60.43
Saturday	2:00 P.M. to 3:00 P.M.	90	63.78
Saturday	3:00 P.M. to 4:00 P.M.	92	67.8
Saturday	4:00 P.M. to 5:00 P.M.	95	69.53
Saturday	5:00 P.M. to 6:00 P.M.	97	61.8
Saturday	6:00 P.M. to 7:00 P.M.	99	57.92
Saturday	7:00 P.M. to 8:00 P.M.	98	53.97
Saturday	8:00 P.M. to 9:00 P.M.	95	71.55
Saturday	9:00 P.M. to 10:00 P.M.	92	57.93

What types of relationships exist in the data?

- Select your answer -Moderate Positive relationshipModerate Negative relationshipPositive relationshipNegative relationshipItem 3

(b)

Use a simple regression model with outside temperature as the causal variable to develop an equation to account for the relationship between outside temperature and hourly sales in the data.

If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Do not round intermediate calculation.

=+Temperature

Based on this model, compute an estimate of hourly sales for today from 2:00 P.M. to 3:00 P.M. if the temperature at 2:00 P.M. is 93^oF.

If required, round your answers to two decimal places.

$

(c)

Use a multiple linear regression model with the causal variable outside temperature and dummy variables as follows to develop an equation to account for both seasonal effects and the relationship between outside temperature and hourly sales in the data in the data:

Hour1 = 1 if the sales were recorded between 1:00 P.M. and 2:00 P.M., 0 otherwise;

Hour2 = 1 if the sales were recorded between 2:00 P.M. and 3:00 P.M., 0 otherwise;

.

.

.

Hour8 = 1 if the sales were recorded between 8:00 P.M. and 9:00 P.M., 0 otherwise.

Note that when the values of the 8 dummy variables are equal to 0, the observation corresponds to the 9:00 P.M. to 10:00 P.M. hour.

If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Do not round intermediate calculation.

=+Temperature +Hour1 +Hour2 +Hour3 +Hour4 +Hour5 +Hour6 +Hour7 +Hour8

Based on this model, compute an estimate of hourly sales for today from 2:00 P.M. to 3:00 P.M. if the temperature at 2:00 P.M. is 93^oF.

If required, round your answers to two decimal places.

$

(d)

Calculate the MSE for the regression models developed in parts (b) and (d). If required, round your answers to three decimal places.

If required, round your answers to three decimal places.

	Model developed in part (b)	Model developed in part (c)
MSE

Is the model you developed in part (b) or the model you developed in part (c) more effective?

The model developed in- Select your answer -part (b)part (c)Item 20is more effective because it has the- Select your answer -largersmallerItem 21MSE.