$!$

Required information

$[$The following information applies to the questions displayed below.$]$

Lab Insight: Apply the same steps in Lab $1\mathrm{.}3$ Excel $($or Lab $1\mathrm{.}3$ Tableau or Lab $1\mathrm{.}3$ Power BI$)$ to the Alt Lab $1\mathrm{.}3$ Data.xIsx data set using your tool of choice.

Open Excel file Alt Lab $1\mathrm{.}3$ Data.xIsx and follow similar directions to those in Lab $1\mathrm{.}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:

Draw a histogram of the gross margin percentages using bins of $0\mathrm{.}025$ size. Use bins $0\mathrm{.}425,0\mathrm{.}45,0\mathrm{.}475,0\mathrm{.}5.$

Get a list of SKUs in the highest $0\mathrm{.}025$ bin $($from $0\mathrm{.}475$ to $0\mathrm{.}50).$

Data: Alt Lab $1\mathrm{.}3$ Data.xIsx

Analyze the Data: Refer to lab $1\mathrm{.}3$ in your text for additional instructions and steps.

Answer the following questions based on the details computed.

Prev

$2$ of $2$

Next