Question

Required: 1. Create calculated fields for the gross margin and gross margin percentage. 2. Create a histogram to visualize the distribution of gross margin percentage across SKUs. 3. Adjust the automated bin size to 0.025. 4. Create a list of SKUs in the highest bin. Data: Lab 1.3 Data.xlsx Specify the Question: Which products (SKUs) are the most profitable to sell? Obtain the Data: Fancy Fruits is a fictitious mail-order business that sells exotic fruit from around the world to customers throughout the United States. The company keeps a price list for each product. We will work from this price list to find the items that are most profitable per dollar of sales. Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps. Answer the following questions based on the details computed. Question 1. What is the size of each bin? 2. Is this dataset negatively (left) or positively (right) skewed? 3. Which gross margin percentage bin does the FRT-COU SKU fit in? 4. How many products (SKUS) have gross margin percentages in the 0.325-0.35 range? 5. How many products (SKUS) have gross margin percentages in the 0.35 -0.375 range? AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 Α' Α' = Wrap Text Paste BI U V A Merge & Center H5 × ✓ fx ' . A " • • AV LIP 175 19 961 175 M 17 17 JAL IM 101 941 181 17 104 204 LH 834 141 211 3 201 152 18 241 1 110 M 181 LIN in SH M IM IN 941 652 19 19 33 L 71 645 IM 10 IN 957 EAT 18 AA 201 Answer IM 147 FRT HAR M 061 12 30 106 118 AT 134 995 1.75 IM 106 *** 181 LOP 11 S IM 181 L 671 206 1.34 131 937 FRY-PLY P 21 1.36 337 134 45 943 101 101 843 23 152 314 11 2 "M M WH 24 144 959 Sheet1 08 301 947 821 31 15 23 + Lab_1_3_Data General $ % 9 ✓ W .

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile