P $1-8($LO $1\mathrm{.}5)$ Download the SkyDio Drone SKU data set. In Excel,...

Required:

Download the SkyDio 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 gross margin percentage to $3$ decimal places. Round average and median gross margin percentage to $1$ decimal place.

$\backslash$table$[[$Question$],[$a$.$ Which product SKU 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.$)],[\backslash$table$[[$d$.$ What is the gross margin percentage of the product SKU and description with the lowest gross margin percentage? $($Hint: Use$],[=$MIN$($ Excel function to calculate.$)]]],[$e$.$ What is the average gross margin percentage? $($Hint: Use $=$AVERAGE$()$ Excel function to calculate.$)],[$e$.$ What is the median gross margin percentage? $($Hint: Use $=$MEDIAN$()$ Excel function to calculate.$)]]$

$1$ SKU$2$ SK$2-$STK$3$ SK$2-$SPK$4$ SK$2-$CIK$5$ SK$2-$PRK$6$ SK$2-$CHG$7$ MEM$-1288$ MEM$-2569$ MEM$-641$ SK$2-$JOY$-2$ SK$2-$ADP$0$ SK$2-$BEA$3$ SK$2-$USB$4$ SKY$-$PLR$\mathrm{.}5$ PRK$-$CSE$6$ CAM$-$FIL$\mathrm{.}7$ SKY$-$BAT$\_8$ SKY$-$PLR$9$ SKY$-$STK$20$ SKY$-$SPK$1$ SKY$-$PRK$22$ SKY$-$CHG$3$ SKY$-$BAT$456$DescriptionSkydio $2$ Starter KitSkydio $2$ Sports KitSkydio $2$ Cinema KitSkydio $2$ Pro KitDual ChargerSanDisk $128$ GB MicroSD CarSanDisk $256$ GB MicroSD CarSanDisk $64$ GB MicroSD CardSkydio $2$ BeaconJloystick ControllerWall Adapter $65$WSkydio Controller USB$-$C to LiSkydio $1$ PropellersPro Hard CasePolarPro ND FiltersSkydio $1$ BatterySkydio $1$ PropellersSkydio $1$ Starter KitSkydio $1$ Sports KitSkydio $1$ Pro KitDual ChargerSkydio $1$ BatterySales Price Cost$94913991799259914959694921917934192922969\mathrm{.}991152579911992299129115541752106014868635403111410720111713340661446171812347765$