I need some help in creating an excel spreadsheet on this problem. Packages of a particular instant dry food are filled by a machine and weighed. The weights (in ounces) for 15 successive packages have been collected and are displayed in the table below. The engineer wishes to determine whether the filling process is indeed in control. Please select, produce values and charts in Excel, and analyze this process and assess the statistical stability using SPC chart(s) which is in the attached file.
The solution solves the problem on x-bar chart.