# Time Series analysis

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

## 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?

(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?

#### 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)

#### 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)

(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

(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.