Question: Part a . Find the attached Excel File: Assignment 2 _ Part a . There are 4 excel worksheets in the excel file. Based on

Part a. Find the attached Excel File: Assignment 2_Part a. There are 4 excel worksheets in the excel file. Based on the instruction in each worksheet, create the following chart and provide explanation. Note: Editing the Excel file, and submit the complete excel file as the first document for this assignment. 1. Create a histogram about the inside diameter of metal sleeves (Hint: the histogram needs to include all 100 observations). Provide your explanation about the histogram chart. 2. Create a scatter plot with a trend line to show the relationship between disposable income and life insurance coverage. Reach your conclusion about the two variables. 3. Create a Pareto Chart regarding the data about types of error in a printing company (Hint: the pareto chart need to be created based on the total cost, only unit costs is given currently). Discuss the results found based on the pareto chart: if management has monthly allocation of $18,000, which areas should they tackle? 4. Based on the cols manufacturing data, conduct the x-bar chart and r chart. How to interpret the two charts?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!