There is a critical piece of info missing from this. That is MWh used per month. These are 2021 data. Using this will allow you to get to electrical cost per person per month compared to income.
Hopefully I did the math right, if this-> =(E2*C2)/(B2*12)*100 is wrong as a formula for calculating energy cost as a percentage of net income, please disregard this data.
The link you sent didn’t have data for all the countries in my original list, so I supplemented with 2014 data (in yellow cells) from worldpopulationreview.com/…
There is a critical piece of info missing from this. That is MWh used per month. These are 2021 data. Using this will allow you to get to electrical cost per person per month compared to income.
Hopefully I did the math right, if this->
=(E2*C2)/(B2*12)*100is wrong as a formula for calculating energy cost as a percentage of net income, please disregard this data.The link you sent didn’t have data for all the countries in my original list, so I supplemented with 2014 data (in yellow cells) from worldpopulationreview.com/…
Nice work. The formula is absolutely right. Crazy that some need to spend a full third of their take home pay on electricity.