(LO 1-3, 1-5) Download the Skydio Drone SKU dataset. Note the sales price and cost of each...
Question:
(LO 1-3, 1-5) Download the Skydio Drone SKU dataset. Note the sales price and cost of each SKU (product). Use Excel to complete address the following questions. You may want to consider completing the Excel tutorial in Appendix A before completing this assignment.
a. What is the SKU with the highest sales price? (Hint: Use =max() function to calculate)
b. What is the highest cost of any SKU? (Hint: Use =max() function to calculate)
c. What is the SKU with the lowest sales price? (Hint: Use =min() function to calculate)
d. What is the lowest cost of any SKU? (Hint: Use =min() function to calculate)
e. What is the average sales price of the SKUs offered for sale (round to two digits)?
(Hint: Use =average() functions to calculate)
f. What is the median cost of the SKUs offered for sale (round to two digits)? (Hint: Use
=median() functions to calculate)
Step by Step Answer:
Introduction To Data Analytics For Accounting
ISBN: 9781266358234
2nd Edition
Authors: Vernon Richardson, Katie Terrell And Ryan Teeter