How much ice cream can you get for an average salary and how has that changed from 1972 to today?
A simple comparison of the price of a product or service over time can give some insight to the real cost of things. Similar comparisons have been done for real estate prices, for a Bic Mac and other things. But this is ice cream!
The ice cream prices can be found here. This is not a case of simply scraping structured data from the website. These prices are stored in ice cream charts served as bitmaps. The ice cream charts contains the complete ice cream selection from Diplom Is for several years ranging from 1972 to 2022.
https://www.diplom-is.no/var-iskrem/tidligere-iskart
I am interested in the ice cream cone (Krone is) because it has been available every year in the charts. First I have to mak a new google spreadsheet to fill in the ice cream prices. When making a dataset use the top line for variable names. You can see this has the variables year, averageIncome and iceCreamPrice. The table will have this format but I need to fill in the data:
| year | averageIncome | iceCreamPrice |
| 1972 | 1.25 | |
Att SSB I found this table:
https://www.ssb.no/statbank/table/09786/tableViewLayout1
Combining the data form the Ice cream charts with the average yearly salary I get the following table. Note that not all years have ice cream data (some ice cream charts did not list the prices) so I can go ahead with the years with data and leave the others out.
https://docs.google.com/spreadsheets/d/1Rrq57wAJ7JF-VSzo2Ib7m1IPX-ZLYV0B0lma2Xo-7mU/edit?usp=sharing
The Viz:
