Download the DJI Mavic Drone SKU dataset.

Required:

In Excel, calculate the gross margin $($Sales Price $-$ Cost$),$ and gross margin percentage $($Sales Price $-$ Cost$)/$Sales Price for each SKU $($product$).$ You may want to consider completing the Excel tutorial in Appendix A before completing this assignment.

Answer is not complete.

$\backslash$table$[[$Question$,$Answer$],[$a$.$ What is the SKU with the highest gross margin? Hint: Use $=$max$()$ function to calculate.,DJI$-$AIF$],[$b$.$ What is the SKU with the highest gross margin percentage? Hint: Use $=$max$()$ function to calculate.,DJI$-$MIN$],[$c$.$ What is the SKU with the lowest gross margin? Hint: Use $=$min$()$ function to calculate.,DJI$-$GBA$],[$d$.$ What is the SKU with the lowest gross margin percentage? Hint: Use $=$min$()$ function to calculate.,DJI$-$IFB$],[\backslash$table$[[$e$.$ What is the average gross margin of the SKUs offered for sale? Hint: Use $=$average$()$ function to$],[$calculate$.($Round to $2$ decimal places.$)]],291\mathrm{.}42],[\backslash$table$[[$e$.$ What is the median gross margin of the SKUs offered for sale? Hint: Use $=$median$()$ function to calculate.$],[($Round to $2$ decimal places.$)]],],[\backslash$table$[[$f$.$ What is the average gross margin percentage of the SKUs offered for sale? Hint: Use $=$average$()$ function$],[$to calculate. $($Round to $3$ decimal places.$)]],],[\backslash$table$[[$f$.$ What is the median gross margin percentage of the SKUs offered for sale? Hint: Use $=$median$()$ function to$],[$calculate$.($Round to $3$ decimal places.$)]],]]$