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:

TECH 458 Quality Assurance

May 6, 2013

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