Excel

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 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

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:

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 does not 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:

 

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.

WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?