1,

A researcher was interested in the relationship between annual electricity bills ($000) of an office, average outside temperatureoC and office size (square metres). A random sample was selected, and data collected. EXCEL was used to create a multiple linear regression, with a portion of the output provided here:

Regression statistics
Multiple R	0.68
R square	0.4624
Observations	94
	Coefficients	p-value	Lower 95%	Upper 95%
Intercept	1.23	3.25	0.17	3.99
Temperature	{tem}	0.04	0.19	1.26
Office size	3.01	0.02	2.79	5.05

What is the upper confidence limit for a 95% confidence interval for the coefficient of Office Size? Please give your answer correct to two decimal places and do NOT include units in your answer.

2.

Is there a relationship between weekly sales revenue ($000) of a coffee shop and the size of the coffee shop (square metres), the number of chairs in the coffee shop and the number of hours, per week, a competitor coffee shop is open? A random sample of coffee shops was selected, data collected on these variables and EXCEL then used to create a regression.

Part of the regression output is provided here:

	Coefficients	Standard error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	15433.76	6610.97	2.33	0.03	1844.72	29022.8
Size	28.92	11.2	2.58	0.02	5.9	51.94
Chairs	172.22	119	1.45	0.16	72.38	416.82
Hours	-5.39	1.85	-2.92	0.01	-9.19	-1.59

Which of the following best describes the coefficient (or slope) of Hours?

Holding the variables Chairs and Size constant, we estimate weekly sales revenue to decrease by an average of $5,390 for every extra hour a nearby competitor coffee shop is open.

Holding the variables Chairs and Size constant, we estimate weekly sales revenue to decrease by an average of $1000 for every extra 5.39 hours a nearby competitor coffee shop is open.

None of these choices is correct

.

Holding the variables Chairs and Size constant, we estimate the weekly sales revenue to increase by an average of $1000 for every extra 5.39 hours a nearby competitor coffee shop is open.

Holding the variables Chairs and Size constant, we estimate weekly sales revenue to increase by an average of $5,390 for every extra hour a nearby competitor coffee shop is open.