need help (Exel)

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. 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
933	911	889	882	903	890	892	908	895	916	901	908	909	895
897	898	915	913	930	940	912	920	920	890	892	895	904	902
885	900	905	930	890	895	895	896	922	891	892	896	906	902
900	905	902	900	890	909	896	894	928	920	895	925	872	932
879	862	873	871	900	915	902	906	926	915	898	933	927	932

 

15	16	17	18	19	20	21	22	23	24	25
893	909	885	897	912	882	896	912	926	917	884
906	907	892	904	896	894	912	909	903	917	889
917	904	942	916	932	941	907	913	908	918	912
910	923	911	912	936	934	928	915	910	914	919
925	888	916	920	913	917	926	928	885	925	898

 

Formatting:

 

Text Size: All of the text in this assignment has been preset to the individual cells.

 

Margins: The margins have been preset in this assignment. If you file doesn’t display correctly, you will need to change the page setup. The top, bottom, and right side are set for ¼’ (0.25) margins. The left margin is set to ½” (0.5”).  The view is set to normal; the page is set to US Legal, landscape, and fit to page.

 

Name Block: Place the name block in the upper left corner of the page, in cells A1 through A3. Put your name first, then the class title and then the due date, as per the example:

 

Your Name

TECH 458 Quality Assurance

May 6, 2013