• 100% Satisfaction Guarantee
linda_us, Master's Degree
Category: Multiple Problems
Satisfied Customers: 1402
Experience:  A tutor for Business, Finance, Accounts and other related topics.
19873544
Type Your Multiple Problems Question Here...
linda_us is online now

# I have a question to something you have published about 2

### Customer Question

Hi, I have a question to something you have published about 2 years ago but cannot find the answer anymore. I have following case:
The following table gives average UK household electricity demand in kilowatt hours (kWh) over some years. Quarter 1 represents Spring, Quarter 2 represents Summer etc.
Year Q1 Q2 Q3 Q4
2005 4.5 4.1 4.4 5.1
2006 4.9 4.6 4.6 5.3
2007 5.0 4.7 4.8 5.5
2008 5.2 5.0 5.1 5.6
2009 5.3 5.1 5.2 5.7
i. State two features about household electricity demand that are apparent from these data.
ii. Show that the 4-point centred moving average for Quarter 3 in 2007 is 5.025.
iii. Calculate the ratio-to-moving-average (R2MA) for Quarter 3 in 2007.
iv. Compute the four seasonal indices using the following table of R2MA
Season Autumn Winter Spring Summer
0.961749 1.088000 1.026178 0.953368
0.946015 1.084399 1.015228 0.944724
? 1.081081 1.007264 0.959233
0.973747 1.064133 1.002364 0.960000
Seasonal averages * 1.079403 1.012759 0.954331
v. The estimated trend line is found to be:
y = 4.461 + 0.050x
where x is the Quarter number (Q1 of 2005 corresponds to x = 1).
where x is the Quarter number (Q1 of 2005 corresponds to x = 1).
Provide a forecast, to three decimal places, for average UK household electricity demand for the summer of 2015. Comment briefly on this forecast.
Submitted: 1 year ago.
Category: Multiple Problems
Customer: replied 1 year ago.
Hi I want to cancel that question. Already did it myself so I do NOT need solution. Thanks
Expert:  Mr. Gregory White replied 1 year ago.

Thanks for the update. I will let the moderator know. Sorry we were not able to assist this time and hope you will consider us in the future.