Important note: Using MS Excel is not mandatory. You only have to write the formula for each question. The final result is not required. Product No. Manufacturing Quantity Cost (5) (units) Selling Price per Unit (S) Revenue Profit (5) (S) 1 2.0 2,3 1,8 23 3,4 1,3 1,7 2,3 2 BT96 3 B177 4 BT41 5 BT312 6 BT153 7 BT139 & BT146 9 B1179 10 BT123 11 BT71 12 BT230 13 BT188 14 BT151 15 BT45 16 B178 17 BT144 18 BT23 19 BT222 20 BT149 5 8 3 6 2 6 8 8 2 1 7 3 40 7,5078 9,4760 4,5008 17,9644 6,2565 18,5367 12,7458 17,0138 11,3587 11,6885 4,0061 5,3059 10,6894 5,5678 2.5899 17.7607 8,4002 8.8949 16,1602 + 1.8 3,5 1,9 1,1 3,3 3.6 6 5 8 3 6 9 4.0 3,3 A sales engineer collected data for the manufacturing cost, quantity sold and selling price for the products offered by the company to monitor profits. You are requested to prepare an analysis report for these collected data. [10p] [10p] Question 1 (20 points) a. Find the median for Manufacturing Cost and place it in cell H5. b. Find the standard deviation for Quantity and place it in cell H9. Question 2 (20 points) c. Find the total number for all data in column D and place it in cell K7. d. Find the average Selling price per unit and place it in cell K8. Question 3 (30 points) [10p] [10p] [10 p] e. Compute the Revenue for cell "E10" using the formula: Revenue = Quantity* Selling price per unit f. Compute the Profit for cell "F16" using the formula: Profit=Selling price per unit - Manufacturing Cost g. Find the minimum of Profit ($) and place it in cell G9. [10p] [10p] Rectangular Snip Question 4 (30 points) h. Find the maximum of Selling Price per Unit (S) and place it in cell G10. i. Describe the steps to highlight the Selling Price per Unit less than $11,000. j. Describe the steps how to sort Product Number from Largest to Smallest. [10p] [10p] [10p]