You are a Buyer for Ray & Johnson buying house, and you have been tasked with finding the markup percentage for the category of the products. To find the appropriate markup percentage, you have decided to calculate the average, the range (max, min), the mean and median of the markup%. Replicate the Figure below in Excel as you complete this exercise. Complete the blank spaces. Use formula's where ever applicable. Category Product Cost Markup Retail % Cost % Markup % on retail Average Max Min Mean Retail Price $49.99 Median 40% $14.49 35% Women's Activewear $51.45 75% $18.89 50% Hoodies Vests Sweatshirts Sport Bras Bootcut Skinny Flare A line $119.99 39% Women's Jeans $44.99 60% 35% $139.99 $199.99 32.5% 28.89% Pencil $31.67 Women's Skirts Pleated $151.99 80% Slit $28.69 62% $19.99 27% Camisole Hoodie Tank Top $14.14 45% Women's Top $21.99 71% 65% Tunic $8.29