(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. Use the descriptive statistics tool featured in Excel’s Analysis Toolpak (or relevant Excel functions) to compute the summary statistics to address the following questions. It may be helpful to perform this project after completing Lab 5-1.

Required:

1.

What is the average sales price for all items sold?

2.

What is the standard deviation of the sales price for all items sold?

3.

What is the range of costs for all items sold?

4.

What is the lowest cost for all items sold?