NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:

Required:

1. do the calculated fields for gross margin and gross margin percentage.

2. do the histogram of the gross margin percentages.

3. Change the default bin size to 0.025.

4. Get a list of SKUs in the highest 0.025 bin.

Ask the Question:Which products are the most profitable?

Master the Data:Open Excel File Lab 2-6 Alt Data.xlsx, and follow similar directions to those provided in the preceding discussion. Thrustmaster sells game controllers, joysticks, and steering wheels for PC, XBox, Nintendo, and Playstation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet.

Software needed

• Tableau
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Data:Lab 2-6 Alt data is given below

\f