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:

 

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

 

 
 
Looking for solution of this Assignment?

WHY CHOOSE US?

We deliver quality original papers

Our experts write quality original papers using academic databases.  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay