During my stint of work experience at Guardian Data the British Medical Journal found that supermarket ready meals are often healthier than the meals in TV chefs’ recipe books. It was covered in the Guardian and elsewhere as a news story. We decided to do a data angle on the story.
The important point about the data we had was the different serving sizes between supermarket ready meals and recipes from Jamie Oliver and the other celebrities. Supermarket ready meals are usually designed for one, whereas the chefs’ recipes are usually for three or four people. We had to divide the servings of salt, sugar, saturated fat and so on by the number of servings if there was more than one serving.
After that, we took the median averages, copied the values only into a new sheet and visualised the data using Google charts.
We found that the saturated fat content, for example, of the celebrity chefs was higher than the supermarket ready meals, which appeared to back up the main news story.