Excel homework

TECH 458 Quality Assurance

Department of Engineering and Design

Eastern Washington University

Spring Quarter 2013

Assignment 1 & Help Sheet (30 Points)

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
908	900	905	892	896	930	890	918	912	908	907	913	940	941
926	911	889	901	908	882	903	917	884	926	896	912	912	882
910	905	902	895	925	900	890	914	919	910	945	915	936	934
885	862	873	955	933	871	900	925	898	885	926	928	913	917
903	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	918
890	892	885	897	908	895	893	909	916	960	917
909	896	911	912	894	928	910	923	920	900	914
915	902	916	920	906	950	925	888	915	879	925
951	912	892	904	920	920	906	907	890	897	917

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:

Your Name

TECH 458 Quality Assurance

May 9, 2013

Saving/Naming Your File:

When you save your file make sure that your name and the project number are included in it.

Example: YourName458Asgnmt1

Because of problems with Blackboard, use only letters and numbers in the file name.

Due Date: May 9, 2013

Revised 4/29/2013 TG Page 1