Pivot tables are a valuable data summarization and analysis tool. Pivot tables allow you to easily aggregate

multiple rows of data $($e$.$g$.,$ corresponding to a product$)$ and calculate summary statistics $($e$.$g$.,$ sales totals,

counts of orders, or maximum order value$).$ This in turn serves as the foundation of data analyses and decision$-$

making $($e$.$g$.,$ to find out which are the growing or better performing market segments$).$ Before we can analyze

the data, we need to prepare it$.$ This is because real world data often requires pre$-$processing or $$cleaning$$

before it can be satisfactorily used. Therefore, this assignment covers both data pre$-$processing and pivot tables.

Many of the Excel functions you work with will be useful in a variety of contexts.