> 76 \pAuthorized User Ba==<[,#8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1QTahoma1Arial1$Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_)
0.0000.0000"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ 2]\ #,##0.00_);[Red]\([$ 2]\ #,##0.00\) + ) , *
" ! ! @ H @ @ ( H (x@@ (p@ (p @ )x@@ (x@ (x @ `z test"fNf8@ZR3A@@
@P1Cost Data Integrity Project3Critical Defect No. 2  Timesheets Entered into PMS5Critical Defect No. 1  Vendor Invoices Posted to PMSPMS: Project Management System Sample n1Observation Sample n2 pNull Hypothsis: Number of Vendor Invoices not entered is the same regardless of reconciliation control procedurerAlternative Hyposis: Number of Vendor Invoices not entered is higher when reconciliation procedure is not followedH0: p1 = p2H1: p1 > p2Average (u)VarianceConfidence Level =>;You should reject the Null Hypothesis if the Test Statisticis higher than the Decision Cut Off Value of:Calculate the Test Statistic:In1: population of projects that have no reconciliation procedure in placeKn2: population of projects that do have a reconciliation procedure in placed1d2%d: number of defects found per sample
Std Deviation5Reject the Null Hypothesis and Accept the AlternativeConclusion:mNull Hypothsis: Number of Timesheets entered is the same regardless if Managers review and approve timesheetsrAlternative Hyposis: Number of Timesheets not entered is higher when Managers do not review and approve timesheetsAlpha or Sign Level =>Decision Cut Off =>Why the Z Test was selected? z: test statistic for the Z TestD1. Type of Data = Attribute data (either defective or not defective)Two Proportion Z Test2. Parameter involved = Proportion of defects93. Samples = Two samples from two independent populationsV4. Objective = Measure with statistics the difference in defects between two processes"n: number of total items in samplePn1: sample timesheets on those projects where Managers do not approve timesheetsLn2: sample timesheets on those projects where Managers do approve timesheetsSize =>"1. Proportion of defects (d1 / n1)"2. Proportion of defects (d2 / n2)23. Overall Proportion of defects (d1+d2) / (n1+n2)#4. Calculate the Test Statistic (z),Test Statistic of 11.98 is higher than 2.326+Test Statistic of 6.00 is higher than 2.326Analyze Two Critical Processes
Total Defects:
_T
'?4ccZ
E!G+1,
dMbP?_*+%#&R&PMHP Color LaserJet 2600nJ4
oXX??????
ȑ
SDDMHP Color LaserJet 2600nd"dX??U}}}
}}$}$}
}
}
E
h
h
h
@
!
/
#
"
#
$
#
(!a@!O@
""~
X@
""Gz? D
""! 0F\@DA(A?(@@@&@?
@ @?
0F\@D@"@@@
$%%%&@&@?
))ƟH8y?%%D@$@
*)c1Ƹ?%D @"@?
+1dy*?%%A~
#@#@
%B#?
%B
,McJB@27DDDDDDA
Bn۶m۶@l,$$$$$$$$B.B?,$$$$$$$$B.
Bs?,$$$$$$$$BB;f?,$$$$$$$$B
'((():444****JeY*I<WW_
!
$
%
&
'
(
)
*
+
,

.
/
0 1 2 3 4 5 6 7 8 9 : ; < =
0# @S@
%# @
%
.
!
!
!!
$#$ %
&
&
'
'
(&
)'*
*"*"~
*X@
+(+!@{@!s@
+"+"+Gz?, D*
,
,
,
,","!, 0F\@/D+A(A

.?:@@
./@3@@
// 0F\@;D,0@6@@1@9@@
1$1%%%&2@2@@
2))2uF*Vg?3%.9D+3@;@@
3*)3ii?4%.9D+4@7@@
4+14u^?5%.9%++w5 @8@@
5,M5H'@:7D2D3D4D4D+D+A6"@6@@7$@9@@
7'7((()8&@5@@
889(@:@@
99
:#:*7@:
%.9B#:UUUUUU@<
%.9B
;
V;]6dM @@$.$/$0$1$2$3$4$5$6$7$8$9B.V;/?;@$.$/$0$1$2$3$4$5$6$7$8$9B.
<V<>7@<@$.$/$0$1$2$3$4$5$6$7$8$9BV<
Ͷ_?+@$.$/$0$1$2$3$4$5$6$7$8$9B
<
=0#=`q@
%.9#=N@=
%.9< <*
0_g*I<WW_{<<<\@ABCD
@
A%
B
C
DP
(
Bw
XPP?ii]4@w %
8f2@
<Sample taken from all projects over an eight month period (each month = 1 observation). Invoices are randomly selected to ensure independence. <
tS
B}
2<3Enter the total number that was actually sampled. <
2~~
<`w XPP?)i ]4
@`w %
5SG;w5
O<PWhat level of confidence do you want in stating your conclusion from this test?<
zO
Bĭw
XPP?*i
.]4@ĭw "%
FV4J
<The significance level (alpha) is set in relation to the confidence level; i.e. very low risk requires a very high confidence level. <
X
B(w
XPP?+i
p/]4@(w "%
1n(
MI]f
<Once you make a choice about confidence level and risk, you establish your decision criteria for accepting or rejecting the hypothesis. <
E~~
<w XPP?,i0]4
@w P#%
,jmhF'?X
M<NDefects (timesheets not entered) should be listed below for each observation.<
wMt8~~
<w XPP?,i.0]4@w %%
?}2&RK(&)
M<NDefects (timesheets not entered) should be listed below for each observation.<
wMt8~~
<Tw XPP?i`]4@Tw &%
S&I
2<3Enter the total number that was actually sampled. <
2~~
<w XPP?i]4@w '%
SGHy.
R<SDefects (vendor invoices not entered) should be listed below for each observation.<
Rt8~~
<H?w XPP?i.]4@H?w (%
@YNեGx
R<SDefects (vendor invoices not entered) should be listed below for each observation.<
Rt8
B5w
XPP? i]4@5w )%
vO˻j
}<~The Test Statistic measures the difference between what is expected vs. what is actually observed under the Null Hypothesis. <
a}~~
<6w XPP?i ]4@6w 8*%
k})oN9x9
O<PWhat level of confidence do you want in stating your conclusion from this test?<
zO
B6w
XPP?i
]4@6w *%
.u7JJs
<The significance level (alpha) is set in relation to the confidence level; i.e. very low risk requires a very high confidence level. <
X
B6w
XPP?i
p]4@6w x,%
UmDD`m
<Once you make a choice about confidence level and risk, you establish your decision criteria for accepting or rejecting the hypothesis. <
EAuthorized UseroAuthorized UseroAuthorized UseroAuthorized UseroAuthorized UseroAuthorized UseroAuthorized UseroAuthorized UseroAuthorized UseroAuthorized Usero*
Authorized Usero+ Authorized Usero+Authorized Usero,Authorized Usero,Authorized Usero,Authorized Usero,Authorized Usero
Authorized UseroAuthorized Usero1Authorized Usero>@>>>R
1177**++,, 7
Oh+'0
X`p
Z Test Six Sigma Green Belt ProjectMatt EvansAuthorized UserMicrosoft Excel@1@1@+2՜.+,0 PXlt
exinfm.comz testWorksheets
!"#$%'()*+,/012345Root Entry FԾSgWorkbookKSummaryInformation(&DocumentSummaryInformation8.