USA: +1(669)289-8683 
Sign in
see the files (1111- 2222-3333) are example of the homework.. and the other three file are the homework.. and please be carefull with numbers because last time I lost some pont because of wrong numbers
TECH
4
5
8
Quality Assurance
Department of Engineering and Design
Eastern Washington University
Spring Quarter
2
0
1
3
Assignment 2 & Help Sheet (30 Points)
Assignment:
You will complete a p chart similar to the example shown in Chapter 9, section 9.2, figure 9.1 & 9.2, from our textbook “Statistical Process Control and quality Improvement”, starting from the provided Excel template. Two versions of the assignment template are provided; 2A is for the newer version of Excel: “.xlsx”, 2B is compatible for older versions of Excel: “.xls”. You will enter the numerical data from the section below, and calculate all of the p, p – bar, then plot these numbers and add the connecting lines, in the appropriate chart sections. You will also calculate and plot the UCLP, LCLp. The control limit formulas are on page 3
6
5 of the textbook; the formulas to complete the control limits are illustrated on pages 36
7
& 368, example 9.1 take you through the steps to do the calculations. Be sure to
include
your p, p – bar, related steps, 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 |
|||||||||||||||||||||||
|
150 |
||||||||||||||||||||||||||||||||||||
| 0 |
|
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
Formatting:
Calculations: On merged cells, use only the left side for use in formulas. If your formulas span two columns, you may add some numbers twice.
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 20, 2013
Saving/Naming Your File:
When you save your file make sure that your name and the project number are included in it.
Example: YourName458Asgnmt2
Because of problems with Blackboard, use only letters and numbers in the file name.
Due Date: May 20, 2013
Revised 5/7/2013 TG Page 1
<<
>p
>A
sg
mt
1
D
ate
C
hecker
p
1
2
3
4
5
6
7
8
9
10
A
B
C
D
E
F
G
(Sample)
n
np
p
3
1
2
>Asg mt le)
1 2 pn
1
(Sam
p
3
4
5
6
7
8
9
1
0
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Date
Checker
n
np
p
0
