Question

AutoSave Alt Lab 1.3 Data Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) Paste BIU AA A- Wrap Text Morge & Center 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. A1 xfx SKU A Description Sales Price Cost 2 FU-16H T1600M FCS Hotas 97.3 52.53 3 FU-TMX TMX Force Feedback Racing 159.84 87.3 4 FLI-HOX T-Flight Hotas X Flight Stick 39.99 20.53 5 FU-H04 T-Flight Hotas 4 Flight Stick 34.65 19.76 6 PED-FCS T16000M FCS 39.19 23.36 7 FU-H01 T-Flight Hotas One 59.99 30.17 8 COM-FCS T16000M FCS Flight Pack 172.35 89.15 9 PED-TFR TFRP Rudder 69.99 41.18 10 WHL-TMX TMX Pro Racing Wheel 249.99 147.62 11 PED-T80 T80 Ferrari 488 GTB Edition F 94.99 52.58 12 PED-T3P FB T3PA-Pro 3-Pedal Add-Or 129.99 66.14 13 PCG-HOW Hotas Warthog PC 462.81 266.04 14 PED-FER Ferrari Racing Wheel Red Leg 79.99 43.51 15 PED-T3A T3PA Add-On 69.99 36.4 16 FU-16M T16000M Space SIM Duo St 117.83 69.36 17 WHL-T30 T300RS Officially Licensed PS 319.99 170.61 18 FL-USB USB Joystick 21.99 12.06 19 PED-TPR TPR Pedals Windows 497.38 284.93 Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format. 1. Take a screenshot of your detailed listing of fruit products sold from the 0.4 to 0.425 gross margin percentage range, paste it into a Word document named "Alt Lab 1.3 Submission.docx", and label the screenshot Submission 1. 22 FLI-STX 20 WHL-T3S VG T300RS Racing Wheel Ser 159.99 92.63 21 FU-THR TWCS Throttle 59.99 35.18 T-Flight Stick X PS3 39.99 21.04 23 WHL-TGT T-GT Racing Wheel (PS4/PC) 614.91 354.66 24 WHL-T3P T300RS Racing Wheel 426.41 231.54 25 26 28 29 2. Take a screenshot of your histogram as a pivot chart, paste it into the same Word document, and label the screenshot Submission 2. Sheet1 + Ready Accessibility: Good to go General 5-%9 +88 Conditional Format Cell Formatting as Table Sty Insert Delete Format H Share Q Comments Σ v 0. Sort 5 Find & Fiber Select Analyze Date 125%

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile