• Skip to primary navigation
  • Skip to main content
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
    • BT
    • MA
    • FA
    • LW
    • PM
    • TX-UK
    • FR
    • AA
    • FM
    • SBL
    • SBR
    • AAA
    • AFM
    • APM
    • ATX
    • Dates
    • What is ACCA

June 2025 ACCA Exams

How was your exam? Comments & Instant poll >>

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for September 2025 exams.
Get your discount code >>

ACCA F2 Time Series Analysis

VIVA

ACCA F2 / FIA FMA lectures Download ACCA F2 notes


Reader Interactions

Comments

  1. haddock says

    July 11, 2018 at 2:36 pm

    Sir, am I correct in understanding that the trend line calculated using moving averages is not a linear trend and that is why a line of best fit must be estimated?

    Log in to Reply
    • John Moffat says

      July 12, 2018 at 10:15 am

      Correct 🙂

      Log in to Reply
  2. haddock says

    June 14, 2018 at 1:34 pm

    Sir, why must the average seasonal variations cancel each other out? (add up to 0) What if they were all positive variations?

    Log in to Reply
    • John Moffat says

      June 14, 2018 at 5:01 pm

      Given that they are all variations about the average then automatically they must add up to zero (some are below average and some are above average). They cannot possibly all be positive!!!

      Log in to Reply
      • haddock says

        June 14, 2018 at 5:37 pm

        Thank you. I find your lectures very clear and informative

      • John Moffat says

        June 15, 2018 at 6:46 am

        You are welcome 🙂

  3. msk29 says

    April 20, 2018 at 12:44 pm

    In the multiplicative model, I understood where you take the total of average figures for each quarter. But where did 400.00 come from?

    In additive model, to make the total of seasonal variations “zero” we deducted the same figure,isn’t it? And then took the average so as to distribute among the 4 quarters.

    Kindly explain me about the 400 part.

    Thank you.

    Log in to Reply
    • John Moffat says

      April 20, 2018 at 3:26 pm

      Each season is a bit more or a bit less than 100% – if there was no seasonality then they would all equal 100%. So since there are 4 of them, they should add up to 4 x 100 = 400%

      Log in to Reply
  4. mango1991 says

    April 1, 2018 at 1:04 pm

    Sir will they be telling us in the exam to calculate the trend based on how many periods/ months/ seasons moving average ?

    For example – will they be mentioning like this – ‘calculate the trend line based on a three month moving average’

    If not, how will we know how many periods to take ?

    Log in to Reply
    • John Moffat says

      April 1, 2018 at 5:27 pm

      It will be made clear in the exam 🙂

      Log in to Reply
  5. etiamm says

    March 7, 2018 at 5:26 pm

    Hi,
    Just wondering why is the average of 84.75 right in the middle of Q2 and Q3 ? could it not be between Q1 and Q2 also ?

    Thanks

    Log in to Reply
    • John Moffat says

      March 7, 2018 at 5:28 pm

      No. We averaged Q’s 1 to 4, and the ‘middle’ of those 4 is effectively the ‘middle’ of Q’s 2 & 3.

      Log in to Reply
      • etiamm says

        March 8, 2018 at 7:33 pm

        Perfect thanks

      • John Moffat says

        March 9, 2018 at 8:10 am

        You are welcome 🙂

  6. malikabdullah0666066 says

    January 21, 2018 at 1:28 pm

    hello,
    in quater 3 (time 24:31) why you took 0.18 and how?

    Log in to Reply
    • John Moffat says

      January 22, 2018 at 9:47 am

      It was quarter 4, not quarter 3. I divided 0.69 by 4, which strictly means subtracting 0.1725 from each quarter. However to stick to 2 decimal places I subtracted 0.17 from 3 of them and 0.18 from the other.

      Log in to Reply
  7. Joseph says

    February 23, 2017 at 6:53 pm

    Multiplicative Q3 Table .. it was 95.35% , in the table u wrote 91.35 and solve it for 91.35%

    im really benefiting from ur lectures but this one is a bit too long , would be better if u hinted out at the question areas

    Thanks alot

    Log in to Reply
  8. akhalid93 says

    January 17, 2017 at 10:32 pm

    Mr. John, the lecture was delivered very well.

    I want to clear my doubt why you have shown the final result zero in the additive model?

    What is the advantage of using Multiplicative model over the additive model and how we would come to know which methods is feasible to use?

    Thank you

    Log in to Reply
  9. keshav11 says

    December 12, 2016 at 10:21 am

    very thankful to you sir.. now i am able able to understand it well

    Log in to Reply
    • John Moffat says

      December 12, 2016 at 11:05 am

      Thank you for the comment 🙂

      Log in to Reply
      • keshav11 says

        December 17, 2016 at 6:26 am

        welcome 🙂

  10. mubezi1 says

    January 12, 2016 at 2:47 pm

    great thanks sir i really understand now

    Log in to Reply
    • John Moffat says

      January 13, 2016 at 8:23 am

      I am pleased 🙂

      Log in to Reply
  11. winters says

    December 4, 2014 at 12:17 am

    Sir i really do not understand the averaging part, i am trying so hard to see what point am i missing but i do not, why do not we find the average of each year individually instead for example we are taking the second quarter of the first year and the first quarter of second year and finding their average and so on…
    Also the moving average part.

    Log in to Reply
  12. lordlawrence79 says

    August 23, 2014 at 9:10 pm

    now I am getting there thank you Lecturer

    Log in to Reply
  13. tijani says

    October 8, 2013 at 6:16 am

    why didnt we find the next 4 moving average of the moving averages to find the Trend but rather find the average of 2 moving averages.
    If the trend find is to be plotted on a graph, the line is not perfectly straight, so can one continue to average the and if yes will it be average of 2 of the trend figures or what?. I realised that if the sales is averaged on every 4 sales basis throughout until two point are gotten, the line will be straight. Can it be done practically and academically?

    Log in to Reply
    • John Moffat says

      October 8, 2013 at 9:18 am

      The 4 quarter moving average was to get the average sales per quarter.
      The only reason for centering it is because the middle quarter did not coincide with any one actual quarter. After centering it, we can then compare the actual sales in a quarter with the ‘average’ sales in the quarter.

      There would be no point in keep averaging. The only point is to average out the seasonality. In practice, the trend may be a smooth pattern (either linear or curved) and would be easier then to forecast than the actual sales which keep going up and down because of the seasonality.

      Log in to Reply
      • kittygr says

        June 6, 2017 at 7:59 am

        This Q&A also solved my problem, thanks a lot.

      • John Moffat says

        June 6, 2017 at 1:37 pm

        You are welcome 🙂

  14. issack says

    August 22, 2013 at 8:32 am

    thank you sir,i realy loved your lecture.very clear and easy to understand,

    Log in to Reply
  15. Mohammad Ibrahim says

    June 11, 2013 at 11:11 am

    Also why are the first two left out?

    Log in to Reply
    • John Moffat says

      June 12, 2013 at 7:45 am

      Because there is no average to compare them to.
      (They are not left out in calculating the moving averages)

      Log in to Reply
  16. Mohammad Ibrahim says

    June 11, 2013 at 11:11 am

    How do know that the centered average is for a certain month in case of even or odd number of total periods?

    Log in to Reply
    • John Moffat says

      June 12, 2013 at 7:45 am

      You only need to centre the average if it is an even number of periods. If it is an odd number of periods then the moving average already corresponds to one of the periods.

      Log in to Reply
  17. M. Osman Kamran says

    November 12, 2012 at 12:45 pm

    I am really thanksfull for Opentition.com site for real free accounting resources.

    Log in to Reply
  18. mvgino says

    November 10, 2012 at 11:21 pm

    very helpful!

    Log in to Reply
  19. hassita says

    August 15, 2012 at 12:09 pm

    Great!

    Log in to Reply
  20. zaidh11 says

    July 9, 2012 at 4:33 am

    Impressive!

    Log in to Reply
Newer Comments »

Leave a Reply Cancel reply

You must be logged in to post a comment.

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in