Adjust the data types as necessary.

Aggregate the sum and then the average of all sales orders $($quantity$).$

Subtotal the sales orders by average across products.

Ask the Question: How do data types affect the way I can analyze data in Excel?

Master the Data: Save Excel file Lab $3-1$ Data.xIsx to somewhere on your computer that you Ean browse to$,$ you will need to connect to the saved file.

The dataset contains information about sales transactions to different customers. There are $132$ unique transactions, but $149$ rows. This is because some of the transactions had multiple products.

Software needed

Excel

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Lab $3-1$ Data. XIsx

Perform the Analysis: Refer to Lab $3-1$ in the text for instructions and steps for each of the lab parts.