How to convert a quarterly data to annual data

2015 11 22
1 个回答
回答已采纳
更新时间：2015 11 23
4 次查看（30 天）

0 个投票

Hello, I am working on quarterly time-series data, got some results and now I would like to convert them to annual series. For example, 2013q1 2013q2 2013q3 2013q4 2014q1 2014q2 2014q3 2014q4 ...now I would see the series: 2013 and 2014 where 2013 = sum{2013q1 2013q2 2013q3 2013q4}... I tries "convertto" but it did not work. Thanks you very much.
Bao

请先登录，再回答此问题。

 采纳的回答

Mohammad Abouali
Mohammad Abouali 2015-11-23
编辑：Mohammad Abouali 2015-11-23

0 个投票

Assuming all years have all 4 quarters (no missing quarter) in row or column vector, i.e.:
quarterlyData=[2013q1 2013q2 2013q3 2013q4 2014q1 2014q2 2014q3 2014q4 ....]
or
quarterlyData=[2013q1; 2013q2; 2013q3; 2013q4; 2014q1; 2014q2; 2014q3; 2014q4; ....]
then you can calculate yearly as follow:
yearlyData= sum( reshape(quarterlyData,4,[]) );

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by