Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com...

16
Two Sample Tests of Hypothesis and Analysis of Variance in Excel Dr. Rick Jerz © 2017 rjerz.com 1

Transcript of Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com...

Page 1: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TwoSampleTestsofHypothesisand

AnalysisofVarianceinExcel

Dr.RickJerz

© 2017 rjerz.com1

Page 2: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

FormatofHypotheses

• Thehypothesesforcomparingtwoindependentpopulationmeansμ1 andμ2 are:

© 2017 rjerz.com2

Page 3: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

PossibleScenarios

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

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

© 2017 rjerz.com3

Page 4: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

ComparingTwoVariances– FStatistic

• Formatofhypotheses• Totestwhethertwopopulationmeansareequal,wemayalsoneedtotestwhethertwopopulationvariancesareequal.

• Thehypothesesmaybestatedas

© 2017 rjerz.com4

Page 5: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

“Special”TestStatistics10-5

© 2017 rjerz.com5

Page 6: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

AlternativeExcelMethod–DataAnalysisAdd-in

• Excel:Data|DataAnalysis

© 2017 rjerz.com6

Page 7: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

ExcelModelOverview

© 2017 rjerz.com7

Page 8: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Ch11

© 2017 rjerz.com8

Page 9: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem Answer

© 2017 rjerz.com9

Page 10: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Ch11

© 2017 rjerz.com10

Page 11: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Answer(a)

© 2017 rjerz.com11

Page 12: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Answer(b)

© 2017 rjerz.com12

Page 13: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Ch11

© 2017 rjerz.com13

Page 14: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Answer

© 2017 rjerz.com14

Page 15: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Ch12

© 2017 rjerz.com15

Page 16: Ch11 and Ch12 -Excel Two-Sample Tests of … othes about two independent samples, 02015 rjerz.com rated "RAW DATA- and 26288 2 Sample Comparison Distribution (for Variances) Standans

TextbookProblem,Answer

© 2017 rjerz.com16


EGR 252 Ch. 9 Lecture1 JMB 2014 9th edition Slide 1 Chapter 9: One- and Two- Sample Estimation Statistical Inference Estimation Tests of hypotheses.

EGR 252 Ch. 9 Lecture1 JMB 2014 9th edition Slide 1 Chapter 9: One- and Two- Sample Estimation Statistical Inference Estimation Tests of hypotheses.

sample of ephimerida

sample of ephimerida

Sample css

Sample css

Louloudia sample

Louloudia sample

Inferences for Proportions and Count Data - …€¦ ·  · 2017-04-29Replace zα by zα 2 for two-sided test sample size. 12 . ... δ ⎥⎦ 13 . Comparing Two Proportions: Independent

Inferences for Proportions and Count Data - …€¦ ·  · 2017-04-29Replace zα by zα 2 for two-sided test sample size. 12 . ... δ ⎥⎦ 13 . Comparing Two Proportions: Independent

Sports sample

Sports sample

EGR 252 Ch. 9 Lecture1 JMB Fall 2011 9th edition Slide 1 Chapter 9: One- and Two- Sample Estimation Statistical Inference Estimation Tests of hypotheses.

EGR 252 Ch. 9 Lecture1 JMB Fall 2011 9th edition Slide 1 Chapter 9: One- and Two- Sample Estimation Statistical Inference Estimation Tests of hypotheses.

4. Basic probability theory - Tietoverkkolaboratorio - · PDF file3 4. Basic probability theory Sample space, sample points, events • Sample spaceΩ is the set of all possible sample

4. Basic probability theory - Tietoverkkolaboratorio - · PDF file3 4. Basic probability theory Sample space, sample points, events • Sample spaceΩ is the set of all possible sample

NOx Analyzer | ENO-30 - Amuza IncAS-700 INSIGHT Autosampler › Robust mechanism for greater reliability › Fits two standard microtiter plates › Zero sample loss injection methods

NOx Analyzer | ENO-30 - Amuza IncAS-700 INSIGHT Autosampler › Robust mechanism for greater reliability › Fits two standard microtiter plates › Zero sample loss injection methods

Sample Premiere

Sample Premiere

Sample illustrator

Sample illustrator

Analysis of Variance(ANOVA) - GitHub Pages · Analysis of Variance(ANOVA) ... More than two sample case:Fisher’s one-way ANOVA Weight loss ... two-way ANOVA. More than one factor:

Analysis of Variance(ANOVA) - GitHub Pages · Analysis of Variance(ANOVA) ... More than two sample case:Fisher’s one-way ANOVA Weight loss ... two-way ANOVA. More than one factor:

Sample ArchiCAD

Sample ArchiCAD

Grignard reagents act as nucleophiles toward the carbonyl groupchemconnections.org/.../Ch12-Alcohols-Grignard.pdf · 2008-03-23 · Synthesis of Alcohols Using Grignard Reagents Grignard

Grignard reagents act as nucleophiles toward the carbonyl groupchemconnections.org/.../Ch12-Alcohols-Grignard.pdf · 2008-03-23 · Synthesis of Alcohols Using Grignard Reagents Grignard

Sample of Forecasting

Sample of Forecasting

EAS 2.6 Sample

EAS 2.6 Sample

Sample Flash

Sample Flash

One-way ANOVA Model Assumptionshomepage.divms.uiowa.edu/~rdecook/stat5201/notes/2-11_Assumptio… · One-way ANOVA: Model Assumptions ... (we’ll explore this for the two-sample

One-way ANOVA Model Assumptionshomepage.divms.uiowa.edu/~rdecook/stat5201/notes/2-11_Assumptio… · One-way ANOVA: Model Assumptions ... (we’ll explore this for the two-sample

Book Panelcad Sample

Book Panelcad Sample

The Two-Sample t-Test - Furman Universitymath.furman.edu/~dcs/courses/math47/lectures/lecture-31.pdf · The Two-Sample t-Test Mathematics 47: Lecture 30 Dan Sloughter Furman University

The Two-Sample t-Test - Furman Universitymath.furman.edu/~dcs/courses/math47/lectures/lecture-31.pdf · The Two-Sample t-Test Mathematics 47: Lecture 30 Dan Sloughter Furman University