Category: Econometrics

How to Load Excel Data into GAUSS

Loading data is often the first step to your data analysis in GAUSS. In this video, you’ll learn how to save time and avoid data loading errors when working with Excel files. Our video demonstration shows just how quick and easy it can be to load time series, categorical and numeric variables from Excel files into GAUSS. You’ll learn how to:
  • Interactively load Excel data files.
  • Perform advanced loading steps, Such as loading specific sheets, or specifying values as missing values.
  • Use autogenerated code in a program file.
  • Change variable names
  • Set up categoical labels and and base cases.

Getting to Know Your Data With GAUSS 22

There is no getting around the fact that data wrangling, cleaning, and exploring plays an important role in any empirical research. Data management can be time-consuming, error-prone, and can make or break results. GAUSS 22 is built to take the pain out of dealing with your data and to let you move seamlessly towards tackling your important research questions. In today’s blog, we walk through how to efficiently prepare and explore real-world data before modeling or estimation. We’ll look at:
  • Loading and merging data.
  • Cleaning data to eliminate misentries, missing values, and more.
  • Exploring data.

The Quantile Autoregressive-Distributed Lag Parameter Estimation and Interpretation in GAUSS

The QARDL model has grown increasingly popular in time series analysis. It is a convenient model for addressing autocorrelation, disentangling long-term and short-term relationships, and addressing asymmetric relationships. In today’s blog, we look at the basics of the QARDL model including:
  1. The intuition behind the QARDL model.
  2. How to estimate the QARDL model in GAUSS.
  3. How to interpret the QARDL results.

The Structural VAR Model at Work: Analyzing Monetary Policy

In today’s blog, we put the building blocks of the structural vector autoregressive (SVAR) model to work in a practical application. We’ll use one of the most common applications of SVAR models, monetary policy analysis, to see the SVAR in action. After this blog, you should have a stronger understanding of:
  • How to use Granger causality testing to inform model selection.
  • How to implement short-run identification restrictions.
  • How to conduct and interpret structural VAR analysis.
Tagged in

Introduction to Handling Missing Values

Handling missing values is an important step in data cleaning that can impact model validity and reliability. Despite this, it can be difficult to find examples and resources about how to deal with missing values. This blog helps to fill that void and covers:
  • Types of missing values.
  • Dealing with missing values.
  • Missing values in practice.

Understanding and Solving the Structural Vector Autoregressive Identification Problem

The structural vector autoregressive model is a crucial time series model used to understand and predict economic impacts and outcomes. In this blog, we look closely at the identification problem posed by structural vector autoregressive models and its solution. In particular, we cover:
  • What is the structural VAR model and what is the reduced form VAR?
  • What is the relationship between structural VAR and reduced form VAR models?
  • What is the structural VAR identification problem?
  • What are common solutions to the structural VAR identification problem?
Tagged in

Introduction to Granger Causality

Multivariate time series analysis turns to VAR models not only for understanding the relationships between variables but also for forecasting. In today’s blog, we look at how to improve VAR model selection and achieve better forecasts using Granger-causality. We explore the questions:
  1. What is Granger-causality?
  2. When to use Granger causality?
  3. How to use Granger causality?

Dates and Times Made Easy

Working with dates in data analysis software can be tedious and error-prone. The new GAUSS date type, introduced in GAUSS 21, can save you time and prevent frustration and errors. The date data type is part of the GAUSS dataframe alongside the category, string, and numeric type. In this blog, we will explore the advantages the date type has to offer, including:
  1. Loading and viewing dates side-by-side with other data types.
  2. Viewing and displaying dates in easy-to-read formats.
  3. Easily changing the date format.
  4. Using familiar date formats for filtering data.

Have a Specific Question?

Get a real answer from a real person

Need Support?

Get help from our friendly experts.

Try GAUSS for 14 days for FREE

See what GAUSS can do for your data

© Aptech Systems, Inc. All rights reserved.

Privacy Policy