Plot Time Series Data Using Econometric Modeler App
These examples show how to plot univariate and multivariate time series data by using the Econometric Modeler app. After plotting time series, you can interact with the plots.
Plot Univariate Time Series Data
This example shows how to plot univariate time series data, then overlay recession bands in the plot. The data set contains the quarterly US gross domestic product (GDP) prices from 1947 through 2005.
At the command line, load the Data_GDP.mat
data
set.
load Data_GDP
Data
contains the time series, and
dates
contains the sampling times as serial date
numbers.
Convert the sampling times to a datetime
vector. Remove
the hours, minutes, and seconds from the datetime vector.
dates = datetime(dates,'ConvertFrom','datenum','Format',"yyyy-MM-dd");
Create a timetable containing the data and associate each row with the
corresponding sampling time in dates
.
DataTable = timetable(Data,'RowTimes',dates,'VariableNames',"GDP");
At the command line, open the Econometric Modeler app.
econometricModeler
Alternatively, open the app from the apps gallery (see Econometric Modeler).
Import DataTable
into the app:
On the Econometric Modeler tab, in the Import section, click
.
In the Import Data dialog box, in the Import? column, select the check box for the
DataTable
variable.Click Import.
The variable GDP
appears in the Time
Series pane, and its time series plot appears in the
Time Series Plot(GDP) figure window.
Overlay recession bands by right-clicking the plot and figure window, then selecting Show Recessions.
Overlay a grid by pausing on the plot and clicking .
Focus on the GDP from 1970 to the end of the sampling period:
Pause on the plot, then click
.
Position the cross hair at (1970,12000), then drag the cross hair to (2005,3500).
The GDP appears flat or decreasing before and during periods of recession.
Plot Multivariate Time Series and Correlations
This example shows how to plot multiple series on the same
time series plot, interact with the resulting plot, and plot the correlations
among the variables. The data set, stored in Data_Canada
,
contains annual Canadian inflation and interest rates from 1954 through
1994.
At the command line, load the Data_Canada.mat
data
set.
load Data_Canada
Convert the table DataTable
to a timetable:
Clear the row names of
DataTable
.Convert the sampling years to a
datetime
vector.Convert the table to a timetable by associating the rows with the sampling times in
dates
.
DataTable.Properties.RowNames = {}; dates = datetime(dates,12,31,'Format','yyyy'); DataTable = table2timetable(DataTable,'RowTimes',dates);
At the command line, open the Econometric Modeler app.
econometricModeler
Alternatively, open the app from the apps gallery (see Econometric Modeler).
Import DataTable
into the app:
On the Econometric Modeler tab, in the Import section, click
.
In the Import Data dialog box, in the Import? column, select the check box for the
DataTable
variable.Click Import.
The Canadian interest and inflation rate variables appear in the Time Series pane, and a time series plot containing all the series appears in the Time Series Plot(INF_C) figure window.
Overlay recession bands by right-clicking the plot and selecting Show Recessions.
Overlay a grid by pausing on the plot and clicking .
Remove the inflation rates (INF_C
and
INF_G
) from the time series plot:
Right-click the plot.
Point to Show Time Series, then clear INF_C.
Repeat steps 1 and 2, but clear INF_G instead.
Generate a correlation plot for all variables:
Select all variables in the Time Series pane.
Click the Plots tab, then click Correlations.
A correlations plot appears in the Correlations(INF_C) figure window.
Remove the inflation rate based on GDP (INF_G
)
from the correlations plot:
Right-click the plot.
Point to Show Time Series, then clear INF_G.
All variables appear to be skewed to the right. According to the Pearson correlation coefficients (top-left of the off-diagonal plots):
The inflation rate explains at least 70% of the variability in the interest rates (when used as a predictor in a linear regression).
The interest rates are highly correlated; each explains at least 94% of the variability in another series.