Question: table [ [ SKU , Description,Sales Price,Cost ] , [ FLI - 1 6 H , T 1 6 0 0 M FCS Hotas,
tableSKUDescription,Sales Price,CostFLIHTM FCS Hotas,FLITMXTMX Force Feedback Racing,FLIHOX,TFlight Hotas X Flight Stick,FLIHOTFlight Hotas Flight Stick,PEDFCSTM FCSFLIHOTFlight Hotas One,COMFCSTM FCS Flight Pack,PEDTFRTFRP Rudder,WHLTMXTMX Pro Racing Wheel,PEDTT Ferrari GTB Edition,PEDTPFB TPAPro Pedal AddOIPCGHOW,Hotas Warthog PCPEDFER,Ferrari Racing Wheel Red LPEDTATPA AddOnFLIMT M Space SIM Duo StWHLTTRS Officially Licensed PFLIUSB,USB Joystick,PEDTPRTPR Pedals Windows,WHLTSVG TRS Racing Wheel SFLITHRTWCS Throttle,FLISTXTFlight Stick X PSWHLTGTTGT Racing Wheel PSPCWHLTPTRS Racing Wheel,
Required information
The following information applies to the questions displayed below.
Lab Insight: Complete the Alt Lab by using steps similar to original Lab in the text. Open Excel, Tableau or Power BI and connect to Excel File AltLabData.xlsx below. Thrustmaster sells game controllers, joysticks, and steering wheels for PC XBox, Nintendo, and Playstation consoles. A summary of the company's sales is included in the dataset.
Required:
Calculate gross margin by customer.
Create a histogram showing relatively frequency in the dataset of the gross margin percentages using bins of size, beginning at to
Data: Alt Lab Data.xIsx
Perform the Analysis: Refer to Lab in the text for your software version instructions and steps for each of the lab parts.
Answer the following questions based the details provided.
tableQuestionAnswer What is the gross margin dollars for SKU WHLTPEnter with decimal places.$
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
