How has consumer product pricing changed in 2022?
Grades 6 - 12
According to recent headlines (e.g. this CBC article), grocery prices in Canada are soaring. Is there any correlation between this surge in food prices and the Covid-19 pandemic?
In this exercise, we investigated the monthly average retail price of common grocery store products in Canada from 2017 to 2022. We also analyzed provincial grocery price trends.
To answer our question we:
- Used monthly average retail price data (2017-2022) for selected products across the country * from Statistics Canada
- Used historical product price data (1995-2022) for Canada, also from Statistics Canada
- Created a series of line graphs
* Note: The prices for Northwest Territories, Nunavut, and Yukon were not found in the Statistics Canada dataset.
First, we plotted the prices of different products over recent years in each Canadian province. In this interactive plot (below), you can select specific products from the dropdown menu. You can also toggle the province and territory names to turn on/off the respective data graphs.
Notice that the plot for each product is “normalized,” which means that the prices are shown relative to the Canadian average. For example, the average price of two litres of apple juice in Canada was $2.80 in January 2017. We divided the price of apple juice in each month by 2.8 to rescale them. The rescaling set the price index (normalized price) for Canadian average in January 2017 to 1.0. Now, we can easily compare data points on the plots to this price index.
For instance, the apple juice price index in Alberta in June 2017 was 1.1. This means the price was 10% higher (1.1/1.0 x 100%) than the Canadian average in January 2017. We can easily calculate the actual price by multiplying the price indices by the same factor of 2.8. The actual price of apple juice in Alberta in June 2017 was $2.8 x 1.1 = $3.08.
Note that rescaling the data points does not change the shape of our plots, it just makes it easier for us to compare the different data points.
In this line graph visualization, you can see that while the price of two litres of apple juice in Alberta has increased steadily (~ 20%) since 2017, the price of oranges has increased by almost 80%. Try clicking on the province names to focus on the province of interest.
Next, we plotted the current prices (as of May 2022) of different products on a regional map. This plot allows you to visualize variations in price across geographical regions.
As you can see, the lowest prices for two litres of apple juice are in Ontario, and the highest prices are in the adjacent province of Quebec. The lowest price for a kilogram of beef sirloin is in Newfoundland and Labrador, and the highest is in Quebec. There is not much variation in the price of a kilogram of beef sirloin across the prairie provinces.
Overall, we observed a fixed pattern in the change in prices for seasonal products, such as apples, pears, and cabbages. In May 2022, the price of most grocery store products increased substantially across Canada. While this price hike affected some provinces more than others, the overall trend was a general increase in prices across all Canadian provinces.
What do you notice in this data visualization? Can you think of some factors contributing to this price hike?
Reflect on what you see
Look and interact with the data visualizations above. When you hover your mouse over the plots, you’ll notice that more information appears. You can also use the legend to make plots appear and disappear.
Think about the following questions.
- What do you notice about these graphs?
- What do you wonder about the data?
Use the fill-in-the-blank prompts to summarize your thoughts.
- “I used to think _______”
- “Now I think _______”
- “I wish I knew more about _______”
- “These data visualizations remind me of _______”
- "I really like _______”
Share your reflections
Below are some ways to share your thoughts about the data visualizations. If you want to publish your reflections online, make sure you check in with your teacher or guardian
- Blogging (there are many free blogging tools)
- Creating Videos (How to Create YouTube Videos)
- Drawings (Google Drawings is one tool you could explore)
Consider adding @callysto_canada to your reflections if you decide to share them on social media.
Learn how we visualized the data
Go to our walk-through (in Jupyter notebook format) to see how the data science process was applied to creating these graphs from formulating a question, gathering the data, and analyzing the data with code to creating the graph.