MAT312 Excel Lab #2 – Measuring Quality with Control Charts
NOTE: You need to use the Excel functions/tools for any calculations rather than just typing numbers into the cells. Along with the Excel tutorial videos presented each week, examples in Chapter 7, section 7 work through similar problems, so please review these before attempting the lab.
Excel Lab #2 Data File
For this assignment, you have been asked to conduct quality control for a manufacturing company. One of their products is paint, sold in 4-liter cans. While the cans are filled on an assembly line with an automatic valve, there were some reports of significant variation in the amounts. While some variation is expected, you have been tasked to see if this is just by chance, or if the machine is operating outside of normal quality control limits.
The Excel Lab #2 Data File has the results of the 4 random samples taken each day over the course of 25 days. First, you will need to use Excel functions to complete the four columns necessary to generate an x-bar chart. Then, use Excel to generate the x-bar chart itself.
Your completed Excel file will be submitted to Canvas through the assignment link.
For part 2 of the assignment, you will need to write up a brief report to submit to the executive board. This should include a copy of your x-bar chart and the conclusions that you were able to make from your analysis.
This should be written as if you were writing a professional report to your employer, not an outline of tasks you did for a project in stat class. Let your instructor know if you are not sure of this difference. You can find a sample report on page 276 in the textbook to see how a statistical report can look.
Submit both your Excel file, and your report (as a PDF) through the assignment link here in Canvas.