i have project

Assignment 1 & Help Sheet (40 Points)

Assignment:

You will complete an x-bar and R chart similar to the example shown in Chapter 6, figure 6.8, from our textbook “Statistical Process Control and quality Improvement”, starting from the provided Excel template. Two versions of the assignment template are provided; 1A is for the newer version of Excel: .xlsx, 1B is compatible for older versions of Excel: .xls. These templates are located in the Files section. You will enter the numerical data from the section below, and calculate all of the averages and ranges, then plot these numbers and add the connecting lines, in the appropriate chart sections. You will also calculate and plot the UCL_X, LCL_X, UCL_R, and LCL_R. The control limit formulas are on page 203 of the textbook. Be sure to include your upper and lower control limit calculations below the chart.

Numerical Data:

1	2	3	4	5	6	7	8	9	10	11	12	13	14
918	900	905	892	896	930	890	918	912	908	907	913	940	941
917	911	889	901	908	882	903	917	884	926	896	912	912	882
914	905	902	895	925	900	890	914	919	910	945	915	936	934
925	862	873	955	933	871	900	925	898	885	926	928	913	917
917	898	915	892	895	913	930	917	889	903	912	909	896	894

 

15	16	17	18	19	20	21	22	23	24	25
895	895	942	916	896	922	917	904	891	885	908
890	892	885	897	908	895	893	909	916	960	926
909	896	911	912	894	928	910	923	920	900	910
915	902	916	920	906	950	925	888	915	879	885
951	912	892	904	920	920	906	907	890	897	903

 

Formatting