Excel homework

There is a link which has the steps of how to do the homework

   http://speedy.sh/ecQea/QA-458-1st-Assignment.rar

Also, please read the files direction carfully 

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:

908

908

926

896

912

912

882

905

900

890

910

900

925

885

926

913

917

898

915

892

895

913

930

917

889

903

912

896

895

896

917

885

918

892

885

908

895

909

916

917

896

911

912

894

928

910

900

914

902

916

920

925

915

925

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

2

>Asgnmt

Number

1 2

2

>Asgnmt

Number

1 2