Solved: Required information [The following information applies to the questio

Question

Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx data set using your tool of choice. Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel. ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox, Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet. Required: 1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.50). Data: Alt Lab 1,3 Data.xlsx 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. Note: Round gross margin to 2 decimal places and gross margin percentage to 3 decimal places. Question 1. What is the gross margin (dollars) for SKU PED-T80? 2. What is the gross margin percentage for SKU PED-T80? 3. What was the highest gross margin percentage among all the SKU's? 4. How many total SKU's are there? 5. How many SKU's are in the 0.45-0.475 bin? Answer