4a.33 The following question is taken from the July to December 2015 exam period.
The following spreadsheet shows part of a time series analysis of a company’s sales.
Year Quarter Sales (unit) Four quarter moving total (unit)
2014 1 1,100
2 1,700
7,000
3 1,900
9,000
4 2,300
11,000
2015 1 3,100
13,200
2 3,700
3 4,100
What is the four quarter centred moving average of sales units for quarter 4, 2014?
? 2,500
? 5,025
? 5,000
? 10,000
hi can u please explain me how to solve this i couldn't understand the answer explained in the book
Ask the Tutor ACCA MA
moving average
3y ago#1Have you watched my free lectures on time series analysis? (The lectures are a complete free course for Paper MA and cover everything needed to be able to pass the exam well.)
yesn sir i did but i wasnt able to solve this if u can please explain this question to me
3y ago#3Take the average of quarters 2, 3, 4 of 2014 and quarter 1 of 2015.
Take the average of quarters 3,4 of 2014 and quarters 1, 2 of 2015.
The take the average of those two averages.
Just as I show in my lecture.
(Your printed answer might have calculated it in a different way, but the end result will be the same (and the way I show in the lecture is the most logical and understandable way)).
how do we know which quarters do we take why dont we take 1 2 3 4 of 2014 or any other
my question is how exactly do we know which ones to take
3y ago#5You take each 4 quarters in order, just as I do in my lectures.
Sign into reply to this topic.