Required:

Download the DJI Mavic Drone SKU data set. In Excel, calculate the gross margin $($Sales Price $-$ Cost$)$ and gross margin percentage $[($Sales Price $-$ Cost$)/$Sales Price$]$ for each SKU $($product$).($This problem may require a review of Excel skills, which you will find in Appendix $A$ at the back of this book.$)$

Note: Round average and median gross margin to $2$ decimal places.

$\backslash$table$[[$Question$,],[$a$.$ Which product has the highest gross margin? $($Hint: Use $=$MAX$()$ Excel function to calculate.$),],[$b$.$ Which product has the highest gross margin percentage? $($Hint: Use $=$MAX$()$ Excel function to calculate.$),],[$c$.$ Which product has the lowest gross margin? $($Hint: Use $=$MIN$()$ Excel function to calculate.$),],[$d$.$ Which product has the lowest gross margin percentage? $($Hint: Use $=$MIN$()$ Excel function to calculate.$),],[$e$.$ What is the average gross margin? $($Hint: Use $=$AVERAGE$()$ Excel function to calculate.$),$DJI$-2$PC$],[$e$.$ What is the median gross margin? $($Hint: Use $=$MEDIAN$()$ Excel function to calculate.$),]]$