Mathematics
Sheet1
| 2015 | -0.001 | 0 | -0.001 | -0.002 | 0 | 0.001 | 0.002 | 0.002 | 0 | 0.002 | 0.005 | 0.007 | 0.12% | 0.12% | 0.0012 |
| 2016 | 0.014 | 0.01 | 0.009 | 0.011 | 0.01 | 0.01 | 0.008 | 0.011 | 0.015 | 0.016 | 0.017 | 0.021 | 1.27% | 1.27% | 0.0127 |
| 2017 | 0.025 | 0.027 | 0.024 | 0.022 | 0.019 | 0.016 | 0.017 | 0.019 | 0.022 | 0.02 | 0.022 | 0.021 | 2.12% | 2.12% | 0.0212 |
| 2018 | 0.021 | 0.022 | 0.024 | 0.025 | 0.028 | 0.029 | 0.029 | 0.027 | 0.023 | 0.025 | 0.022 | 0.019 | 2.45% | 2.45% | 0.0245 |
| 2019 | 0.016 | 0.015 | 0.019 | 0.02 | 0.018 | 0.016 | 0.018 | 0.017 | 0.017 | 0.018 | 0.021 | 0.023 | 1.82% | 1.82% | 0.0182 |
| 2% |
Geometrical mean using mathematics formula
Geometrical mean using Excel integrated formula
GEOMETRICAL MEAN FOR THE 5 YEARS
I used these numbers in decimal just to get the values that i can use for the formula