How to convert a quarterly data to annual data
8 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Nguyen Bao
am 22 Nov. 2015
Kommentiert: Mohammad Abouali
am 23 Nov. 2015
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 Kommentare
Akzeptierte Antwort
Mohammad Abouali
am 23 Nov. 2015
Bearbeitet: Mohammad Abouali
am 23 Nov. 2015
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,[]) );
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Power and Energy Systems finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!