Question: Lab Insight: Complete the Alt Lab by using steps similar to original Lab 2-3 in the text. Open Excel, Tableau or Power BI, and connect


Lab Insight: Complete the Alt Lab by using steps similar to original Lab 2-3 in the text. Open Excel, Tableau or Power BI, and connect to Excel File Alt_Lab_2-3_Data.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: 1. Calculate gross margin by customer. 2. Create a histogram (showing relatively frequency in the dataset) of the gross margin percentages using bins of 0.025 size, beginning at 0.425 to 0.525. Data: Alt Lab 2-3 Data.xlsx Perform the Analysis: Refer to Lab 2-3 in the text for your software version instructions and steps for each of the lab parts. Upload the Word or PDF document containing your Lab screenshots 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. To prevent uploading issues avoid using special characters in your file attachment name. 1. Take a screenshot of your histogram, paste it into a Word document named "Alt Lab 2-3 SS.doc", and label the screenshot Submission 1. 2. Take a screenshot of your detailed listing of fruit products sold from the 0.475 to 0.50 gross margin percentage range, paste it into your Word document named "Alt Lab 2-3 SS.doc", and label the screenshot Submission 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
