a)

Regression was used to model quarterly electricity costs ($) for a household.

Estimated Electricity Cost = 154.69+ 9.13t + 37.66 Q1 ? 4.74Q2 +17.97Q4

With t is in quarters and the origin is att = 0 June 2020

Q1, Q2, Q4 are dummy variables for March, June and December, respectively.

Q3 is the dummy variable for the September quarter and is the benchmark for this model.

What is the value that measures the seasonal variation of electricity cost of this household for the March quarter?Please give your answer correctly rounded to two decimal places.

b)

The following model forecasts the volume ofproducts sold by a company, per quarter, where t = 0 in the March quarter of 2017:

Estimated VolumeSold= 114.73 + 23.96t + 15.94Q₁?26.2Q₃+ 12.23Q₄

Q₁, Q₃and Q₄are dummy variables for the March quarter, September quarter and December quarter, respectively.

Q₂is the dummy variable for June quarter and is the benchmark for this model.

Forecast the number of products sold by this company for the March quarter of 2025.Please give your answer correctly rounded to two decimal places.

c)

Regression was used to model quarterly profits ($000's) of a company.

Estimated Profits = 3.82+ 2.5t + 3.93 Q1 + 6.28Q2 - 2.43Q4

Where t is in quarters and the origin is att = 0 June 2018.

Q1, Q2, Q4 are dummy variables for the quarters of March, June and December, respectively.

Q3 is the dummy variable for the September quarter and is the benchmark for this model.

What is the value that measures the trend component per quarter?Please give your answer correctly rounded to two decimal places.

d)

Regression was used to model the number of visitors to a DVD store, per quarter.

Estimated Number of visitors = 151.05? 4.06t ? 59.19 Q1 ? 5.78Q2 + 29.5Q4

With t is in quarters and the origin is att = 0 June March 2010

Q1, Q2, Q4 are dummy variables for March, June and December, respectively.

Q3 is the dummy variable for the September quarter and is the benchmark for this model.

Which of the following is the correct interpretation of the coefficient of t?

A) The number of visitors to this DVD store is trending downwards and decrease by 155.11 per quarter.

B) The number of visitors to this DVD store is trending upwards and increase by 155.11 per quarter.

C) The number of visitors to this DVD store is trending upwards and increase by 4.06 per quarter.

D) The number of visitors to this DVD store is trending downwards and decrease by 4.06 per quarter

E) The number of visitors to this DVD store does not change, per quarter.

e)

EXCEL was used to create the following regression output for the number of orders received per month, by a store.Part of the regression output is provided below:

Variable Coefficient Standard error of coefficient Intercept 16.29 0.96 t 16.75 0.1 February 7.97 0.12 March 10.47 0.68 April -5.49 0.99 May 7.52 0.16 June 27.79 0.79 July -1.92 0.63 August 2.97 0.81 September 21.63 0.41 October 4.41 0.16 November 6.75 0.7 December 36.56 0.74