<p>Let's say <span class="math-container">$D_t$</span> is the stock of debt at time <span class="math-container">$t$</span>.</p>

<p>The first difference is <span class="math-container">$D_t - D_{t-1}$</span>.</p>

<p>The second difference is <span class="math-container">$(D_t - D_{t-1}) - (D_{t-1}-D_{t-2}) = D_t - 2D_{t-1} + D_{t-2}$</span>.</p>

<p>The [4-period] moving average is then given by</p>

<p><span class="math-container">\begin{align*}
&amp;= \frac 1 4 (D_t-2D_{t-1}+D_{t-2}+D_{t-1}-2D_{t-2}+D_{t-3}\\
&amp;\qquad+D_{t-2}-2D_{t-3}+D_{t-4}+D_{t-3}-2D_{t-4}+D_{t-5})\\
&amp;= \frac 1 4 (D_t - D_{t-1} - D_{t-4} + D_{t-5})\\
&amp;= \frac 1 4 ((D_t - D_{t-4}) - (D_{t-1} - D_{t-5}))
\end{align*}</span></p>

<p>Which would be the yearly increase in the stock of debt this period compared to the same thing a quarter ago. Only you could tell if this is what you want in your regression. Something to consider is only to use the first difference: <span class="math-container">$D_t - D_{t-4}$</span>.</p>

CC BY-SA 4.0
2019-12-17T07:01:53.387Z
2019-12-17T07:01:53.387Z
Art
<p>The word "noise" implies that there is error in the measurement of household debt, but there is no good reason to believe this is so. In fact, I argue that a finer time period would give you more detail, and a more accurate measurement of the correlation between two variables. You don't want to find a moving average because that throws away valuable variation in the data.</p>

<p>What you should be more concerned about is which lag is most correlated with the current unemployment rate, and you can find those coefficients by including multiple degrees of lag in the multivariate regression.</p>

<p>Overall, no, it is not a common technique in econometrics. Don't do it. Rather use the standard errors to determine how accurate your estimates are.</p>

CC BY-SA 4.0
2019-12-27T05:13:50.303Z
2019-12-27T05:13:50.303Z
ahorn
<p>I'm trying to use acceleration of quarterly data on household debt (the difference in the difference in debt) in a regression on unemployment (only concerned with correlation) but quarterly data is much noisier than annual data, which may weaken the correlation. I was wondering if transforming the already differenced (twice) data as a moving average would change my coefficients at all and if they would be more accurate. Is this a common technique in econometrics?</p>

<econometrics><labor-economics><regression><applied-econometrics><time-series>
Can you take the moving average of quarterly data of an explanatory variable in a regression to smoothen noise and get more accurate coefficients?
User 313
# Can you take the moving average of quarterly data of an explanatory variable in a regression to smoothen noise and get more accurate coefficients?

(Asked by: username_0 on 2019-12-17)

I'm trying to use acceleration of quarterly data on household debt (the difference in the difference in debt) in a regression on unemployment (only concerned with correlation) but quarterly data is much noisier than annual data, which may weaken the correlation. I was wondering if transforming the already differenced (twice) data as a moving average would change my coefficients at all and if they would be more accurate. Is this a common technique in econometrics?

**Tags:** econometrics, labor-economics, regression, applied-econometrics, time-series

---

## 2 answers

### Answer by username_1 on 2019-12-17. Score: 1 | Accepted answer

Let's say $D\_t$ is the stock of debt at time $t$.

The first difference is $D\_t - D\_{t-1}$.

The second difference is $(D\_t - D\_{t-1}) - (D\_{t-1}-D\_{t-2}) = D\_t - 2D\_{t-1} + D\_{t-2}$.

The [4-period] moving average is then given by

\begin{align\*}
&= \frac 1 4 (D\_t-2D\_{t-1}+D\_{t-2}+D\_{t-1}-2D\_{t-2}+D\_{t-3}\\
&\qquad+D\_{t-2}-2D\_{t-3}+D\_{t-4}+D\_{t-3}-2D\_{t-4}+D\_{t-5})\\
&= \frac 1 4 (D\_t - D\_{t-1} - D\_{t-4} + D\_{t-5})\\
&= \frac 1 4 ((D\_t - D\_{t-4}) - (D\_{t-1} - D\_{t-5}))
\end{align\*}

Which would be the yearly increase in the stock of debt this period compared to the same thing a quarter ago. Only you could tell if this is what you want in your regression. Something to consider is only to use the first difference: $D\_t - D\_{t-4}$.


---

### Answer by username_2 on 2019-12-27. Score: 1

The word "noise" implies that there is error in the measurement of household debt, but there is no good reason to believe this is so. In fact, I argue that a finer time period would give you more detail, and a more accurate measurement of the correlation between two variables. You don't want to find a moving average because that throws away valuable variation in the data.

What you should be more concerned about is which lag is most correlated with the current unemployment rate, and you can find those coefficients by including multiple degrees of lag in the multivariate regression.

Overall, no, it is not a common technique in econometrics. Don't do it. Rather use the standard errors to determine how accurate your estimates are.


---

