RMB Monthly Mini Challenge #1: Nowcast April
'%3e%3cpath fill='%23001489' d='M0 0v6h9V0z'/%3e%3cpath fill='%23e03c31' d='M0 0v3h9V0z'/%3e%3cg stroke='%23fff' stroke-width='2'%3e%3cpath id='d' d='m0 0 4.5 3L0 6m4.5-3H9'/%3e%3cuse xlink:href='%23b' stroke='%23ffb81c' clip-path='url(%23c)'/%3e%3c/g%3e%3cuse xlink:href='%23d' fill='none' stroke='%23007749' stroke-width='1.2'/%3e%3c/g%3e%3c/svg%3e)
There is some discrepancy between the last column "Percentage Change (From Prior Month)" in the table "CPI_Historic_Values_Zindi" and the same values calculated from the column "Value" as a difference between the current and previous month for the corresponding category of CPI.
There are 23 rows with a deviation. Just a few examples:
Category Value Percentage Change (From Prior Month) Delta Value
2023-01-31 Food and non-alcoholic beverages 114.4 1.8 2.0
2023-01-31 Transport 109.9 -3.5 -4.0
2023-01-31 Restaurants and hotels 106.8 -0.9 -1.0
2022-12-31 Food and non-alcoholic beverages 112.4 0.4 0.5
2022-12-31 Transport 113.9 0.7 0.8
2022-11-30 Food and non-alcoholic beverages 111.9 0.5 0.6
The last column "Delta Value" is calculated by me as a difference between the current and previous month for the corresponding category of CPI. It should be the same as the second last column "Percentage Change (From Prior Month)".
I guess the %change calculated as
(Current - previous)/previous * 100
Hi @ihar. I noticed that as well. We've taken it from stats SA reports. There could a rounding error. Given that you'll be scored on the value (109.9, 113.9, etc), happy if you think its a good idea to make changes and recalculate the deltas.