(LO 5-3, LO 5-8) Download the “DJI Mavic Drone Sales Journal” dataset in Excel. Note the sales price and cost of each sale. In Excel, calculate the gross margin (Sales Price –

Cost) for each sale (or row in the sales journal). Use the descriptive statistics tool featured in Excel’s Analysis Toolpak (or relevant Excel functions) to compute the summary statistics to help determine the following. It may be helpful to perform this project after completing Lab 5-1.
Required:

1.

What is the median gross margin for all items sold?

2.

What is the standard deviation of the gross margin for all items sold?

3.

What is the range of gross margin for all items sold?

4.

What is the highest gross margin for all items sold?

5.

What is the count of sales transactions in the dataset?