Skip to Content
Last modified by Artur K. on 2026/05/29 14:28
From version 2.7
edited by Helena K.
on 2026/01/27 13:41
Change comment: There is no comment for this version
To version 2.11
edited by Helena K.
on 2026/01/27 13:46
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -88,40 +88,40 @@
88 88  
89 89  The formula for a simple annual growth rate can be expressed as follows:{{footnote}}Note: often growth rates are expressed as percentage growth, in which case the value is multiplied with 100%. This is however not relevant for this guideline and is left out for simplicity.{{/footnote}}
90 90  
91 -//GT= VT-VT-PVT-P//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png]]
91 +[[image:1769510529532-579.png]]
92 92  
93 -à A growth rate over P years in year T is the difference between the current year value and the value P years ago related to the value P years ago; with G being the growth rate, V being the absolute value, T being the time (year) and P the number of periods.
93 +A growth rate over P years in year T is the difference between the current year value and the value P years ago related to the value P years ago; with G being the growth rate, V being the absolute value, T being the time (year) and P the number of periods.
94 94  
95 95  The growth rate formula can be expressed in VTL and linked to transformation type G. The year T is linked to the respective year in the time series and the parameter P is linked to the transformation period concept.
96 96  
97 97  **Example:**
98 98  
99 -|**Year à**|**2010**|**2011**|**2012**|**2013**
100 -|**GDP Level**|500|505|510|505
101 -|**Growth rate,
102 -period on period**| |0.0100|0.0099|-0.0098
103 -|**Formula**| |//GT= V2011-V2011-1V2011-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image002.png]]|//GT= V2012-V2012-1V2012-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image003.png]]|//GT= V2013-V2013-1V2013-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image004.png]]
104 -|**Growth rate,
105 -over 2 periods**| | |0.0200|0.0000
106 -|**Formula**| | |//GT= V2012-V2012-2V2012-2//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image005.png]]|//GT= V2013-V2013-2V2013-2//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image006.png]]
99 +|(% style="width:427px" %)**Year à**|(% style="width:230px" %)**2010**|(% style="width:365px" %)**2011**|(% style="width:386px" %)**2012**|(% style="width:322px" %)**2013**
100 +|(% style="width:427px" %)**GDP Level**|(% style="width:230px" %)500|(% style="width:365px" %)505|(% style="width:386px" %)510|(% style="width:322px" %)505
101 +|(% style="width:427px" %)**Growth rate,
102 +period on period**|(% style="width:230px" %) |(% style="width:365px" %)0.0100|(% style="width:386px" %)0.0099|(% style="width:322px" %)-0.0098
103 +|(% style="width:427px" %)**Formula**|(% style="width:230px" %) |(% style="width:365px" %)[[image:1769510625588-573.png]]|(% style="width:386px" %)[[image:1769510654674-828.png]]|(% style="width:322px" %)[[image:1769510676535-250.png]]
104 +|(% style="width:427px" %)**Growth rate,
105 +over 2 periods**|(% style="width:230px" %) |(% style="width:365px" %) |(% style="width:386px" %)0.0200|(% style="width:322px" %)0.0000
106 +|(% style="width:427px" %)**Formula**|(% style="width:230px" %) |(% style="width:365px" %) |(% style="width:386px" %)[[image:1769510701118-480.png]]|(% style="width:322px" %)[[image:1769510718908-350.png]]
107 107  
108 108  When looking at the formulas, you can see that the same parameters that are used to call a transformation service can be used to code the resulting series, which makes it very easy for data processing systems to ensure consistency between calculations and coding of results:
109 109  
110 -|**Year à**|2011|(% rowspan="4" %)(((
110 +|**Year **→|2011|(% rowspan="4" %)(((
111 111  **Transformed series:**
112 112  
113 -REF_YEAR à 2011
113 +REF_YEAR → 2011
114 114  
115 -OBS_VALUE à 0.0100
115 +OBS_VALUE → 0.0100
116 116  
117 -TRANS_TYPE à G (Formula / VTL function)
117 +TRANS_TYPE → G (Formula / VTL function)
118 118  
119 -TRANS_PER à 1
119 +TRANS_PER → 1
120 120  )))
121 121  |**GDP Level**|505
122 122  |**Growth rate,
123 123  period on period**|0.0100
124 -|**Formula**|//GT= V2011-V2011-1V2011-1//[[image:file:///C:/Users/axyli/AppData/Local/Temp/msohtmlclip1/01/clip_image007.png]]
124 +|**Formula**|[[image:1769510755278-324.png]]
125 125  
126 126  This is especially useful when only transformed series should be exchanged and level series or transformations are not subject to exchange. An example could be GDP growth rates, where for early estimates often level series are still under embargo, whereas growth rates are publishable.
127 127  
1769510529532-579.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.8 KB
Content
1769510625588-573.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.9 KB
Content
1769510654674-828.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.9 KB
Content
1769510676535-250.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +2.0 KB
Content
1769510701118-480.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.8 KB
Content
1769510718908-350.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +2.0 KB
Content
1769510755278-324.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.9 KB
Content
© Semantic R&D Group, 2026