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
View Count: 23,477

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

Part 2: http://www.youtube.com/watch?v=5C012e... Part 3: http://www.youtube.com/watch?v=kcfiu-... This is Part 1 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Parts 2 and 3 upon completing Part 1. The links for 2 and 3 are in the video as well as above. hr / bClosed Caption:/b hi guys i'm going to show you how to deal with time series data in excel so we're going to jump right into an examplebr ...
Video Length: 18:06
Uploaded By: Jalayer Academy
View Count: 425,039

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

Get you Master of Science in Supply Chain Management online in as little as one year. Please visit: business.rutgers.edu/scmonline. hr / bClosed Caption:/b ok in this video I'm going to show you how to run a regret forecast based on a linear regression a simple linear regression and the idea is basically that we have data with some kind of a growth component in it and it's moving upwards so we're going to guesstimate anbr ...
Video Length: 08:00
Uploaded By: scmprofrutgers
View Count: 113,077

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

From an existing multiple regression output produced with Excel 2007, I show you how to make point predictions and approximate 95% prediction intervals. The basic package of Excel does not have a routine for making predictions intervals, so I suggest a method of inflating the residual standard deviation statistic by 10% to get an approximate standard error of prediction. hr / bClosed Caption:/b hello and welcome back to a video series on doing multiple regression in ...
Video Length: 10:11
Uploaded By: ProfTDub
View Count: 85,098

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

This video discusses the interpretation of a logistic regression's coefficients and, more specifically, the slope of the independent variables when all other variables are held at their means. We also show evidence of the non-linear relationship between the independent variables and the dependent variable. TABLE OF CONTENTS: 00:00 Introduction 00:21 Recap of Logistic Regression 01:10 Leveraging the Similarities with Linear Models 02:15 What changed? 03:06 ...
Video Length: 16:45
Uploaded By: dataminingincae
View Count: 71,216

Forecasting Trend and Seasonality
Forecasting Trend and Seasonality

Using dummy variables and multiple linear regression to forecast trend and seasonality hr / bClosed Caption:/b so the final models that we're going to look at within time series forecasting are seasonality and trend i'm going to go ahead and just jump straight to one that has both trend and seasonality in it here we have terry's tire shop we've already determined that they have three seasons a Christmas season like ...
Video Length: 09:07
Uploaded By: profMattDean
View Count: 44,942

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

Operations and Supply Chain Management by Prof. G. Srinivasan , Department of Management Studies, IIT Madras. For more details on NPTEL visit http://nptel.iitm.ac.in hr / bClosed Caption:/b We continue our discussion on Forecasting Models. In the last lecture, we developed forecasting models for this data. This data we assumed represented a constant model and we looked at forecasting models for this data, we looked at simple average, weighted ...
Video Length: 53:40
Uploaded By: nptelhrd
View Count: 32,948

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

LearnAnalytics demonstrates use of Multiple Linear Regression on Excel 2010. (Data Analysis Toolpak). Data set referenced in video can be downloaded at www.learnanalytics.in/blog/wp-content/uploads/2014/02/car_sales.xlsx hr / bClosed Caption:/b alright so in this segment we're going to cover how to monitor the patient's only accept on some of you with no and excited we have dances to back which allows him to do a bit of skin analysisbr ...
Video Length: 09:14
Uploaded By: Learn Analytics
View Count: 30,479

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

Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm Learn: 1) (00:11) Forecasting using Regression when we see a trend and belief the trend will extend into the future. Will will predict outside the Experimental Region with the Assumption is that trend continues into future. 2) (00:53) Forecast a Trend using Simple Liner Regression. We use the Data Analysis Regression Feature. 3) (03:22) Learn how to use FORECAST ...
Video Length: 25:22
Uploaded By: ExcelIsFun
View Count: 24,044

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

Forecasting with Linear Regression, Trendlines, and the TREND function Part 1 hr / bClosed Caption:/b hi this is Kim brittania i fat I would am create a screencast four-year tear help TV stand information on how to create different types have line charts and to forecast financial information based on previous years history information and using the linear regression technique in Alsace simple average she ...
Video Length: 05:01
Uploaded By: barthoki
View Count: 23,245

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

In this video, you will learn how to find the demand forecast using linear regression. hr / bClosed Caption:/b let's look at an example of forecasting font color="#E5E5E5"using the linear regression analysis/font font color="#CCCCCC"maxis sales corporation is in the/font business of selling laptops they realized the advantages of forecasting font color="#E5E5E5"very early in their business they also/font realized that in ...
Video Length: 24:05
Uploaded By: maxus knowledge
View Count: 20,460

Copyright © 2025, Ivertech. All rights reserved.