<p>I've seen them summed somewhere but I cannot exactly remember where. Ultimately I don't think that it makes much difference. The quarterly sum is just the average multiplied by three. Since local projections are just a bunch of OLS - one for each horizon, this is how you can think about the issue:</p>
<p>If <span class="math-container">$y_{t+h} = \alpha^h + \beta_h news\_shock_t + \sum_{j=1}^{L}\delta_j^hx_{t-j} + \dots + \sum_{j=1}^{L}\gamma_j^hy_{t-j} + \epsilon^h$</span> is the OLS for the h-th horizon, adding the shocks up is going to yield a <span class="math-container">$\beta_h$</span> that is exactly three times smaller than the <span class="math-container">$\beta_h$</span> you will obtain by averaging. The statistical significance will not be affected.</p>
<p>Since the units of the news shock most likely don't have any particular meaning both regressions yield exactly the same information.</p>
<p>A different approach instead of aggregating the news shocks up is to use industrial production data, which is usually available on monthly basis to disaggregate the GDP series down to monthly levels using Chow-Lin interpolation. A recent paper using this method would be <a href="http://dx.doi.org/10.1016/j.jimonfin.2017.02.008" rel="nofollow noreferrer">Anaya et. al.</a>.</p>

CC BY-SA 4.0
2021-04-05T23:25:34.257Z
2021-04-07T05:36:14.183Z
2021-04-07T05:36:14.183Z
Grada Gukovic
<p>I have monthly shock series, which I want to convert to quarterly form. I have seen several methods like taking average of 3 months or summing 3 months for making a quarter. I would like to know how I can know which method is useful for me. Taking average or summing? Or is it something about personal choice in research methodology?</p>
<p>More details:</p>
<p>I intend to get impulse responses of real GDP to news shocks (which are already available). My GDP series are in quarterly form and my shock series in monthly form. So I need to convert shock series to quarterly form and do local projections.</p>

CC BY-SA 4.0
2021-04-04T20:36:02.173Z
Hi, could you please provide a bit more details and clarity in your Q about the problem? This will be different for different variables. If we are talking about total units of good Q produced by company X summing then would be appropriate, if we are talking about growth it would be more appropriate to do average and so on... choice on how to aggregate data is not a la carte but it depends on situation and context
1muflon1
CC BY-SA 4.0
2021-04-04T20:48:28.167Z
@1muflon1 Thanks. I have edited my question.
festakonik
<time-series><paneldata><empirical-methods><data><methodology>
Converting monthly data to quarterly
festakonik
# Converting monthly data to quarterly

(Asked by: username_0 on 2021-04-04)

I have monthly shock series, which I want to convert to quarterly form. I have seen several methods like taking average of 3 months or summing 3 months for making a quarter. I would like to know how I can know which method is useful for me. Taking average or summing? Or is it something about personal choice in research methodology?

More details:

I intend to get impulse responses of real GDP to news shocks (which are already available). My GDP series are in quarterly form and my shock series in monthly form. So I need to convert shock series to quarterly form and do local projections.

**Tags:** time-series, paneldata, empirical-methods, data, methodology

> **Comments:**
> **username_1**: Hi, could you please provide a bit more details and clarity in your Q about the problem? This will be different for different variables. If we are talking about total units of good Q produced by company X summing then would be appropriate, if we are talking about growth it would be more appropriate to do average and so on... choice on how to aggregate data is not a la carte but it depends on situation and context  
> **username_0**: @username_1 Thanks. I have edited my question.  

---

## 1 answers

### Answer by username_2 on 2021-04-05. Score: 3 | Accepted answer

I've seen them summed somewhere but I cannot exactly remember where. Ultimately I don't think that it makes much difference. The quarterly sum is just the average multiplied by three. Since local projections are just a bunch of OLS - one for each horizon, this is how you can think about the issue:

If $y\_{t+h} = \alpha^h + \beta\_h news\\_shock\_t + \sum\_{j=1}^{L}\delta\_j^hx\_{t-j} + \dots + \sum\_{j=1}^{L}\gamma\_j^hy\_{t-j} + \epsilon^h$ is the OLS for the h-th horizon, adding the shocks up is going to yield a $\beta\_h$ that is exactly three times smaller than the $\beta\_h$ you will obtain by averaging. The statistical significance will not be affected.

Since the units of the news shock most likely don't have any particular meaning both regressions yield exactly the same information.

A different approach instead of aggregating the news shocks up is to use industrial production data, which is usually available on monthly basis to disaggregate the GDP series down to monthly levels using Chow-Lin interpolation. A recent paper using this method would be [Anaya et. al.](http://dx.doi.org/10.1016/j.jimonfin.2017.02.008).


---

