Gretl Tutorial 6: Modeling and Forecasting Time Series Data

Gretl Tutorial 6: Modeling and Forecasting Time Series Data


In this video we run a linear regression on a time series dataset with time trend and seasonality dummies. Then, we perform and evaluate the accuracy of an in-sample forecast, as well as perform an out-of-sample (i.e., into the future) forecast.

TABLE OF CONTENTS:
00:00 Introduction
00:12 What we will do in this Video
00:40 Data
01:14 Glimpse Data in Excel
01:46 Load Data in Gretl
03:20 Plot Time Series
03:54 Create Additional Variables
04:38 Run Model with All Data
05:34 In-Sample Forecast
06:40 Evaluating Quality of In-Sample Forecast
10:37 Out-of-Sample Forecast

Video Length: 12:20
Uploaded By: dataminingincae
Published: 9/20/2014
View Count: 80,214

Related Software Products
Regression Analysis and Forecasting
Regression Analysis and Forecasting

Published By:
Business Spreadsheets

Description:
The Multiple Regression Analysis and Forecasting model provides a solid basis for identifying value drivers and forecasting business plan data. While it utilizes a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies. The intuitive step-by-step usage flow enables you to develop strong forecasts for ...


Related Videos
Excel - Time Series Forecasting - Part 1 of 3
Excel - Time Series Forecasting - Part 1 of 3

Video Length: 18:06
Uploaded By: Jalayer Academy (4/18/2013)
View Count: 1,592,935

Forecasting in Excel Using Simple Linear Regression
Forecasting in Excel Using Simple Linear Regression

Video Length: 08:00
Uploaded By: scmprofrutgers (2/14/2012)
View Count: 292,990

Video 8: Logistic Regression - Interpretation of Coefficients and Forecasting
Video 8: Logistic Regression - Interpretation of Coefficients and Forecasting

Video Length: 16:45
Uploaded By: dataminingincae (9/17/2014)
View Count: 274,578

Forecasting - Linear regression - Example 1 - Part 1
Forecasting - Linear regression - Example 1 - Part 1

Video Length: 24:05
Uploaded By: maxus knowledge (2/24/2014)
View Count: 192,040

How to Make Predictions from a Multiple Regression Analysis
How to Make Predictions from a Multiple Regression Analysis

Video Length: 10:11
Uploaded By: ProfTDub (11/12/2010)
View Count: 173,757

Forecasting Trend and Seasonality
Forecasting Trend and Seasonality

Video Length: 09:07
Uploaded By: profMattDean (7/30/2013)
View Count: 169,979

Multiple Linear Regression using Excel Data Analysis Toolpak
Multiple Linear Regression using Excel Data Analysis Toolpak

Video Length: 09:14
Uploaded By: Learn Analytics (2/2/2014)
View Count: 141,447

Mod-02 Lec-03 Forecasting -- Linear Models, Regression, Holt's , seasonality
Mod-02 Lec-03 Forecasting -- Linear Models, Regression, Holt's , seasonality

Video Length: 53:40
Uploaded By: nptelhrd (6/25/2012)
View Count: 106,720

Basic Excel Business Analytics #56: Forecasting with Linear Regression: Trend & Seasonal Pattern
Basic Excel Business Analytics #56: Forecasting with Linear Regression: Trend & Seasonal Pattern

Video Length: 25:22
Uploaded By: ExcelIsFun (12/3/2015)
View Count: 106,081

Forecasting with Linear Regression in Excel: Tutorial Part 1
Forecasting with Linear Regression in Excel: Tutorial Part 1

Video Length: 05:01
Uploaded By: barthoki (11/1/2010)
View Count: 25,808

Copyright © 2026, Ivertech. All rights reserved.