Skip main navigation

Time Series Forecasting

.

Our second approach to forecasting is called Time Series Analysis, and we’re going to use this when we have time-series data.

Time series data is simply historical data that’s date and time stamped at regular intervals. We can look at trends over time and then we can infer that those trends are likely to continue.

Example of a table of time-series data for births in a certain city from 1946 to 1959

In the above image, we have time-series data from 1946 – 1959 of the average births per month in a certain city.

We’re able to plot these births on a graph:

Graph of time-series data for births in a certain city from 1946 to 1959

We can clearly see an overall trend of births increasing year-by-year, but we can also see seasonal trends within each year.

We can decompose this time-series graph in several different ways, for example, the initial data, the overall trend, the seasonal trend and random noise:

4 graphs showing a decomposed view of time-series data for births in a certain city from 1946 to 1959

This helps us to project our trends into the future like this:

Graph of projection of time-series data for births in a certain city from 1946 to 1959 with uncertainty shown in purple shaded area

Note the purple shaded area shows some uncertainty based on the difference between the random noise and the trend line.

This article is from the free online

Essential Mathematics for Data Analysis in Microsoft Excel

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now