Time Series analysis




About this tutorial:

Video duration: 11:38
Watch this brief (10 minutes or so!!) video tutorial on how to do all the calculations required for a Time Series analysis of data on Microsoft Excel.

Try and do your best to put up with the pommie accent. The data for this video can be accessed at

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

28 thoughts on “Time Series analysis

    Likawunt Samuel

    (February 1, 2019 - 2:13 pm)

    Videos make statistical analysis easy and understandable. It is a great support. Kind regards,

    Chelle Cabison

    (February 1, 2019 - 2:13 pm)

    hi sir i just want to ask, what if the time is yearly what am i going to do?

    asad saham

    (February 1, 2019 - 2:13 pm)

    kindly guide me how to put data in eviews / game theory model

    nahom abraham

    (February 1, 2019 - 2:13 pm)

    what is the purpose of the centre moving means?

    Alps P

    (February 1, 2019 - 2:13 pm)

    Can u use this method for daily data

    jpaokx

    (February 1, 2019 - 2:13 pm)

    Why do you use 6 values

    Packz

    (February 1, 2019 - 2:13 pm)

    I love you so much for making this thanks bro

    Crochet LouLou

    (February 1, 2019 - 2:13 pm)

    PLEASE REPLY! I have 4 years under each year i have for example 9 firms specific data related to this firm is gathered. how i write the years in spss? firms year1, year2, year3, year4
    A 1 0 0 0
    B 0 1 0 0
    C 0 0 1 0
    D 0 0 0 1
    and so on this is the way i wrote them and after that i wrote for example YEARS
    FIRMS YEARS
    A 1
    B 1
    C 1
    D 1
    A 2
    B 2
    C 2
    D 2
    A 3
    B 3
    C 3
    D 3
    A 4
    B 4
    C 4
    D 4
    Is this the right way to do it in spss?
    please answer!

    Samir Bitar

    (February 1, 2019 - 2:13 pm)

    Hi, your's is a very helpful explanation/demonstration. Thank you! I also, have a question: I work at a museum. we have years of visitation data. we have an upcoming exhibition that we expect to draw a record # of visitors. I have modeled a forecast on your description but I don't have time series 1 – 50; instead I have time series 2011-8 through 2016-20. this number makes for a rather odd forecast number. any ideas?

    Fakhri Alam

    (February 1, 2019 - 2:13 pm)

    i have long term daily rainfall data tell me the exact procedure of time series analysis for the data. thnx

    Katie Boyles

    (February 1, 2019 - 2:13 pm)

    data link not working 🙁

    Mr

    (February 1, 2019 - 2:13 pm)

    another question. what if i only got yearly data, can still be effective to use time series analysis ? thx

    Mr

    (February 1, 2019 - 2:13 pm)

    may i ask if the trend is downward sloping or R square is not close to one, will time series analysis still be effective? thx

    Beautiful world

    (February 1, 2019 - 2:13 pm)

    Why do you use 6 values to calculate moving mean please? Can you not use any less or any more for that matter? Thanks

    Shannen McLaren

    (February 1, 2019 - 2:13 pm)

    This was sooo helpful 🙂

    Mihir Gada

    (February 1, 2019 - 2:13 pm)

    Why do we center moving averages?
    Why do we use centered moving averages for seasonal effects?

    Melantis Obtrusis

    (February 1, 2019 - 2:13 pm)

    How to create predicted time series?

    aJUFsd

    (February 1, 2019 - 2:13 pm)

    Excellent one..; you can save more time by using more excel options though. 

    Charles Sutton

    (February 1, 2019 - 2:13 pm)

    This really set me up to better understand the logic behind exponential smoothing. Thanks for the instruction.

    yoga1freak

    (February 1, 2019 - 2:13 pm)

    Extremely helpful video! Thanks a lot!

    Nikita Hockenhull

    (February 1, 2019 - 2:13 pm)

    This video is super helpful (: thanks x

    Ruvimbo Gwarada

    (February 1, 2019 - 2:13 pm)

    excellent example good job!!!

    Serge Aurubin

    (February 1, 2019 - 2:13 pm)

    This is completely awesome!

    Saalha

    (February 1, 2019 - 2:13 pm)

    blimey this is superb, tx!

    Amanda McNaughton

    (February 1, 2019 - 2:13 pm)

    What else would you need to do to get excellence in this topic? Great video, thanks.

    sidkings

    (February 1, 2019 - 2:13 pm)

    Excellent. Thank you very much indeed.

    ehab elaraby

    (February 1, 2019 - 2:13 pm)

    great job thanks alot

    Chris Maunsell

    (February 1, 2019 - 2:13 pm)

    Thanks hoops, real helpful to work through it with that in the background.

Leave a Reply

Your email address will not be published. Required fields are marked *