How to convert a quarterly data to annual data
4 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
Mohammad Abouali
2015-11-23
编辑:Mohammad Abouali
2015-11-23
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 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Power and Energy Systems 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!