Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started