TwoSampleTestsofHypothesisand

AnalysisofVarianceinExcel

Dr.RickJerz

© 2017 rjerz.com1

FormatofHypotheses

• Thehypothesesforcomparingtwoindependentpopulationmeansμ1 andμ2 are:

© 2017 rjerz.com2

PossibleScenarios

1. Populationσ2’sareknown2. Populationσ2’sareunknown

1. Areσ2’sequal?2. Areσ2’sunequal?

© 2017 rjerz.com3

ComparingTwoVariances– FStatistic

• Formatofhypotheses• Totestwhethertwopopulationmeansareequal,wemayalsoneedtotestwhethertwopopulationvariancesareequal.

• Thehypothesesmaybestatedas

© 2017 rjerz.com4

“Special”TestStatistics10-5

© 2017 rjerz.com5

AlternativeExcelMethod–DataAnalysisAdd-in

• Excel:Data|DataAnalysis

© 2017 rjerz.com6

ExcelModelOverview

© 2017 rjerz.com7

TextbookProblem,Ch11

© 2017 rjerz.com8

TextbookProblem Answer

© 2017 rjerz.com9

TextbookProblem,Ch11

© 2017 rjerz.com10

TextbookProblem,Answer(a)

© 2017 rjerz.com11

TextbookProblem,Answer(b)

© 2017 rjerz.com12

TextbookProblem,Ch11

© 2017 rjerz.com13

TextbookProblem,Answer

© 2017 rjerz.com14

TextbookProblem,Ch12

© 2017 rjerz.com15

TextbookProblem,Answer

© 2017 rjerz.com16