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 UCLX, LCLX, UCLR, and LCLR.  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:

 

1234567

011121314

908

895

9208908

95

930890895895

8

92896

902

900905902900890909896

928920895

900915902906

91589

3

932

891
	933		911		889		882		903				890				892			908						895			916	901				909
	897			898				915			913		930	940						912				920			928			904				902
		885				900		905					896	922	918			906
	894			925	872			932
879	862	873	871			926	893	927

 

1516171819202122232425893909885897912882896912926

906

892904896894912909903917889

917904

916932

907913908918912

911912

928915910

925

916920913917926928885925898

			917	884
	907
942	941
	910	923	936	934	914	919
888

 

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

  

2

>Asgnmt

1

Number

1 2

Sample

	Sample	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25
Measurements
Average
Range
Chart of Averages
Chart of Ranges
UCLX=
LCLX=
UCLR=
LCLR=

2

>Asgnmt

1

Number

1 2

Sample

																										Sample	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25
Measurements
Average
Range
Chart of Averages
Chart of Ranges
UCLX=
LCLX=
UCLR=
LCLR=