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

采纳的回答

Mohammad Abouali
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 CenterFile Exchange 中查找有关 Power and Energy Systems 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by