(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)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Introduction To Data Analytics For Accounting

ISBN: 9781266358234

2nd Edition

Authors: Vernon Richardson, Katie Terrell And Ryan Teeter

Question Posted: