$4$:$16$

Back

Assignment $5.$docx

Switch To Dark Mode

Assignment $5$

This assignment contains $2$ parts. You need to address both parts to earn full credit.

Part a$.$ Find the attached Excel File: Assignment $5\_$Charts. 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.

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.

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.

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?

Based on the cols manufacturing data, conduct the $x-$bar chart and r chart. How to interpret the two charts?

Part b$.$ This part includes $3$ calculation questions regarding Chapter $4$ Forecasting. Show your steps to earn full credit. Note: You can either type your answer in this word file, or you can print it out, work on it$,$ and scan the file back in$.$ I$\text{'}$m fine with either option, and whatever the option you choose, it should be the second file you turn in for this assignment.

As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years:

$\backslash$table$[[$YEAR$,1,2,3,4,5,6],[$HEART TRANSPLANTS,$45,50,52,56,58,?$

Part a$.$ Find the attached Excel File: Assignment $5\_$Charts. 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.

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.

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.

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?

Based on the cols manufacturing data, conduct the $x-$bar chart and r chart. How to interpret the two charts?

Part b$.$ This part includes $3$ calculation questions regarding Chapter $4$ Forecasting. Show your steps to earn full credit. Note: You can either type your answer in this word file, or you can print it out, work on it$,$ and scan the file back in$.$ I$\text{'}$m fine with either option, and whatever the option you choose, it should be the second file you turn in for this assignment.

As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years:

$\backslash$table$[[$YEAR$,1,2,3,4,5,6],[$HEART TRANSPLANTS,$45,50,52,56,58,?$