*Using Excel*

Based on the instruction in each worksheet, create the following chart and provide explanation.

1. Formulate 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. Formulate 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. Formulate 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?