Sub-totals

Carrying out quick calculations of numerical values within our dataset is a great way to sense-check that things are in order and ready for much deeper analysis later on. We don't even need to start creating formulas by hand - Excel provides us with features that make it easy for us to check our data.

The management team would like to understand whether there is a significant difference between each country's order to the delivery period. In this exercise, we'll use Sub-Totals to work this out.

If you lost progress, close any open reports and load 2_2_sub_totals.xlsx from the Workbooks folder.