> JI \pAuthorized User Ba==<[,#8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1QTahoma1Arial"$"#,##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\);_(* ""??_);_(@_) + ) , * " @ H H D* + `WanovatimesheetsSBanovainvoices ;A ;B "fVf@ @bZ 3A@@
1MeanVariance
Difference
F Ratio =>Variance of MeansDegrees of Freedom (numerator) Degrees of Freedom (denominator)9<            Projects            >F Distribution (Critical Value)Cost Data Integrity Project,Various New Treatments to Improve TimesheetsWhat is the purpose of ANOVA?*Various New Treatments to Improve Invoices*Test the Treatments against Four Projects:\Each Project is managed differently and tends to introduce some variation, now block out theZvariation introduced by each project and recalculate the F Ratio and F Distribution Value: TreatmentUTreatment 1  All Project Managers review and approve timesheets with each pay cycle.QTreatment 2  All new employees must complete timesheet training within two weeks_Treatment 3  Employees not submitting timesheets receive an email notification within 24 hoursNumber of TreatmentsySeveral different treatments or procedures can help improve the current critical process. In order to implement immediateKresults with minimal change, which of the following treatments is the best?QC02LB02VM01GS02 Reduce for Estimating ErrorInput for F Distribution Value$Risk in Relation to Confidence Level%Analysis of Variance (ANOVA)  F TestqANOVA helps assess the impact of different treatments for improving a critical process. In this test, we will usepthe F Test to determine if differences in treatments is due to random chance or is it statistically significant?OConclusion regarding ANOVA  F Test for Treatments to Improve Timesheet ProcessCompareANOVA  F Test with BlockingNumber of Projects SampledFewer Degrees of FreedomvWithout blocking for each project, we would wrongly conclude that there is significant differences between each of thesthree treatments for improving timesheet processing. When we block out variation between projects, we conclude thatqthere really isn't that much difference since the F Ratio of 3.79 is lower than the F Distribution Value of 5.14.XTreatment 1  All projects are receiving copies of vendor invoices for entering into PMS^Treatment 2  All projects have a reconciliation / review procedure against the General LedgerXTreatment 3  All projects have at least one person trained in posting invoices into PMSPConclusion regarding ANOVA  F Test for Treatments to Improve Invoice Processing~Without blocking for each project, we would wrongly conclude that there is no real significant differences between each of thewthree treatments for improving invoice processing. When we block out variation between projects, we conclude that therewis a difference between the three treatments since the F Ratio of 7.75 is higher than the F Distribution Value of 5.14.:w
qys
3
cc*
Ar# .~.
dMbP?_*+%96&LCost Data Integrity Project&C&P&RF Test  TimesheetsM^Canon MP800 Series Printer߁
odXLetterBJDM0VT$m,`Oj,`OjVT$m,v`Oj,v,v`OjXXDRAFTSample 1'dVT$mVT$m@
VT$m
Canon MP800 Series Printer߁
odLetter=8b"UX??U}A
h
h
h
!
$?@?@#?
%B.?$$$$B.$@@@@@#
@
%B.UUUUUU?$$$$B.$@??@#?
%B.UUUUUU?$$$$B.
@
B@???UUUUUU?
!?DD!PUUUUU?DD!пDD!пDD
)TUUUUU?$$$B.
'؉؉@DDD
~
@
~
?
!@!DD
%~
@
'"@DDD
:444*@bO9A&
!
%
&
'
(
)
*
+
,

.
/
0
1
2
3
4
5
6
7
8
9
<
>
?
~
@
!(!卦@$D DDA
!#!
%%
&&
'$
(
)
)
)
)
)
)
)~
*?!*UUUUUU?3DD!*VUUUUU?+DD!*
@+DD!*?+DD#*?+
%**B.*Kh/?+$*$*$*$*B.~
+@!+@,DD!+VUUUUU@,DD!+@,DD!+
@,DD#+
@,
%++B.+ %?,$+$+$+$+B.~
,@!,?*DD!,VUUUUU?*DD!,?*DD!,@*DD#,?/
%,,B.,{ %?0$,$,$,$,B.
#?.
%*,B#?.
%*,B#?.
%*,B#?
%*,B#?.
%*,B'88?+%*,
.!.DD!.DD!.DD!.DD
.
//)/TUUUUU?*$*$+$,B.
0'0CjV@D4D/D
1~
1@
2~
2?
3!3@5D1D2
3
4%~
4@4
5
5'5"@*D1D4D1
5
6&~
6@
6
7~
7@
7
8/8Gఒ@D7D3D5D6A
8#8
9
<"<
>'
?(8p
*R**bO9A&U**Y*@
@)"8 )^F(
BX&
XPP?piP]4@X&
r2H!P5
<F Ratio is a statistic that is used to compare against an F Distribution value. If the F Ratio is higher than the F Distribution value, then there is a significant difference between the various treatments. <~~
<&XPP?i ]4@&
RU;`H]
X<YDegrees of Freedom for the Numerator is usually the number of levels less a factor of 1.<X
B '
XPP?iP"]4@ '
nAC.C;S
< Degrees of Freedom for the Denominator is the sum of all data points in the Design of Experiment less Degrees of Freedom in the Numerator. </
B'
XPP?i#]4@'`
7'.O *e
<What sigificance level or risk are you willing to accept. This relates to your confidence level, such as 90%, 95%, or 99%. In our example, we want to be 95% confident about our conclusion. </ldB
s*D@< ]`ldB
@
s*D@`!!] `ldB
s*D@1<7]
`ldB
@
s*D@`88]`
B(
XPP?/i3]4@(
͞!BbB0>
<F Ratio is a statistic that is used to compare against an F Distribution value. If the F Ratio is higher than the F Distribution value, then there is a significant difference between the various treatments. <~~
<(XPP?2i6]4
@(
fr3Hs~(%
X<YDegrees of Freedom for the Numerator is usually the number of levels less a factor of 1.<X
BP)
XPP?4iP8]4@P)H
X@Gl@*J
< Degrees of Freedom for the Denominator is the sum of all data points in the Design of Experiment less Degrees of Freedom in the Numerator. </
B)
XPP?6i:]4@)(
nVN!=Hg
<What sigificance level or risk are you willing to accept. This relates to your confidence level, such as 90%, 95%, or 99%. In our example, we want to be 95% confident about our conclusion. </~~
<*XPP?,i
0]4@*
WG%DID"zi3F
W<XThis formula has changed to remove blocking effects compared to the formula used above.<W
B*
XPP?5i9]4@*
U#u9!UG[a
s<tWith blocking, we lost a few degrees of freedom with each blocked mean. 4 less 1 in the original = 3 degrees lost.
<,s Authorized UserfAuthorized UserfAuthorized Userf Authorized UserfAuthorized Userf0Authorized Userf3
Authorized Userf5Authorized Userf6Authorized Userf7Authorized Userf>@!!887ggh/h
AIlR]x]
dMbP?_*+%74&LCost Data Integrity Project&C&P&RF Test  InvoicesM^Canon MP800 Series Printer߁
odXLetterBJDM0VT$m,`Oj,`OjVT$m,v`Oj,v,v`OjXXDRAFTSample 1'dVT$mVT$m@
VT$m
Canon MP800 Series Printer߁
odLetter<8_"UX??U}A
h
h
h
*
+
,
!
$?@@?@#
@
%B.@$$$$B.$@@?#?
%B.UUUUUU?$$$$B.$@@@@@#@
%B.UUUUUU@$$$$B.
@
B@?@@qq@
!UUUUUU@DD!DD!VUUUUUDD!пDD
)@$$$B.
'!@DDD
~
@
~
?
!@DD
%~
@
'"@!DDD
:444*@bO9A&
!
%
&
'
(
)
*
+
,

.
/
0
1
2
3
4
5
6
7
8
9
<
>
?
~
@
!(!卦@*D DDA
!#!
%%
&&
'$
(
)
)
)
)
)
)
)~
*?!*@*DD!*@*DD!*@*DD!*@*DD#*
@*
%**B.*UUUUUU?+$*$*$*$*B.~
+@!+ڿ+DD!+?+DD!+VUUUUU?+DD!+?+DD#+?+
%++B.+88?,$+$+$+$+B.~
,@!,VUUUUU@,DD!,VUUUUU@,DD!,@,DD!,@,DD#,@,
%,,B.,88?$,$,$,$,B.
#@
%*,B#@
%*,B#@
%*,B#@
%*,B#@
%*,B'SUUUUU?.%*,
.!..DD!..DD!..DD!./DD
.
//)/@0$*$+$,B.
0'0@3D4D/D
1~
1@
2~
2?
3!3@5D1D2
3
4%~
4@4
5
5'5"@8D1D4D1
5
6&~
6@
6
7~
7@
7
8/8Gఒ@2D7D3D5D6A
8#8
9
<<
>.
?/8p
*R**bO9A&U**Y*@
@0"88 0^ F(
BC
XPP?piP]4@CT
6CXB^
<F Ratio is a statistic that is used to compare against an F Distribution value. If the F Ratio is higher than the F Distribution value, then there is a significant difference between the various treatments. <~~
<CXPP?i ]4@C
k&ik0,Cnȍ0=]
X<YDegrees of Freedom for the Numerator is usually the number of levels less a factor of 1.<X
BC
XPP?iP"]4@C
AȆINMC1
< Degrees of Freedom for the Denominator is the sum of all data points in the Design of Experiment less Degrees of Freedom in the Numerator. </
BDD
XPP?i#]4@DD
58L2>5'
<What sigificance level or risk are you willing to accept. This relates to your confidence level, such as 90%, 95%, or 99%. In our example, we want to be 95% confident about our conclusion. </ldB
s*D@< ]`TldB
@
s*D@`!!]`<ldB
s*D@1<7]`ldB
@
s*D@`88]`
BHE
XPP?/i3]4 @HE
Z@7{ZAa
<F Ratio is a statistic that is used to compare against an F Distribution value. If the F Ratio is higher than the F Distribution value, then there is a significant difference between the various treatments. <~~
<EXPP?2i6]4
@E
ǴCFL.<[
X<YDegrees of Freedom for the Numerator is usually the number of levels less a factor of 1.<X
BF
XPP?4iP8]4@FT!
5#Eg̤v
< Degrees of Freedom for the Denominator is the sum of all data points in the Design of Experiment less Degrees of Freedom in the Numerator. </
BtF
XPP?6i:]4@tF4#
)F4JOyވm
<What sigificance level or risk are you willing to accept. This relates to your confidence level, such as 90%, 95%, or 99%. In our example, we want to be 95% confident about our conclusion. </~~
<FXPP?,i
0]4
@F#
hyצ]Oxռ
W<XThis formula has changed to remove blocking effects compared to the formula used above.<W
B@A !!887ggh'h
Oh+'0
X`
Analysis of Variances Six Sigma Green Belt ProjectMatt H. EvansMatt EvansMicrosoft Excel@=6@]1@@,6՜.+,0H PXlt
exinfm.comanovatimesheetsanovainvoices'anovainvoices'!Print_Area'anovatimesheets'!Print_AreaWorksheets
Named Ranges
!"#$%&'()*+,./012345678:;<=>?@BCDEFGHRoot Entry FfuWorkbookEqSummaryInformation(9DocumentSummaryInformation8A