To Accompany Business Statistics A Decision Making Approach 8th Ed Chapter 10 Estimation and Hypothesis Testing for Two Population Parameters By Groebner Shannon Fry amp Smith PrenticeHall Publishing Company ID: 278984
Download Presentation The PPT/PDF document "Guide to Using Excel 2007 For Basic Stat..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Guide to Using Excel 2007 For Basic Statistical Applications
To AccompanyBusiness Statistics: A Decision Making Approach, 8th Ed.Chapter 10:Estimation and Hypothesis Testing for Two Population ParametersByGroebner, Shannon, Fry, & SmithPrentice-Hall Publishing CompanyCopyright, 2011Slide2
Chapter 10 Excel ExamplesHypothesis Tests – Two Means –
SUV Vehicle MileageHypothesis Testing – Two Proportions - Pomona FabricationsSlide3
Hypothesis Test – Two Means
SUV Vehicle MileageIssue: A national car rental agency wishes to test whether SUV vehicles have different mean city mileage versus highway mileage. The premise is that mean highway mileage will exceed mean city mileage Objective: Use Excel 2007 to help test the hypothesis for the difference in population means. Data file is Mileage.xlsSlide4
Hypothesis Test – SUV Vehicle Mileage
Open file Mileage.xlsThe null and hypothesis to be tested are:Slide5
Hypothesis Test – SUV Vehicle Mileage
Select the Data tabSelect Data AnalysisSelect Descriptive StatisticsOKSlide6
Hypothesis Test – SUV Vehicle Mileage
Input Range = A1:B26 Note- This range covers BOTH columnsGrouped by ColumnsLabels in First RowNew Worksheet Ply – DescriptiveSummary StatisticsOKSlide7
Hypothesis Test – SUV Vehicle Mileage
Sample Means, Standard Deviations and Variances are shown for each set of dataSlide8
Hypothesis Test – SUV Vehicle Mileage
Using PHStat’s Box and Whisker toolSet the Cell Range to A1:B26Select First cell contains labelSelect Multiple Groups – UnstackedOKSlide9
Hypothesis Test – SUV Vehicle Mileage
Producing this Box and Whisker PlotSlide10
Hypothesis Test – SUV Vehicle Mileage
Using the Data Analysis tool, Select t-test Two-Sample Assuming Equal VariancesSlide11
Hypothesis Test – SUV Vehicle Mileage
Variable 1 Range: A1:A26Variable 2 Range: B1:B26Hypothesized Mean Difference = 0Alpha = 0.05New Worksheet Ply = testSlide12
Hypothesis Test – SUV Vehicle Mileage
Resulting calculations: p value for one tailed test is .007 which is less than .05 so we reject the null hypothesis.Slide13
Issue:
The research and development department needs to determine whether the new, redesigned motor-heater is more reliable than the current unit. Objective: Use Excel (PHStat) 2007 to help construct a confidence interval estimate for the difference in population proportions. No data is required for this test.Hypothesis Test – Two Proportions - Pomona FabricationsSlide14
Hypothesis Test – Pomona Fabrications
Click on PHStat then Two-Sample Tests then Z Test for Difference in Two Proportions.Slide15
Hypothesis Test – Pomona Fabrications
Set Hypothesized Difference = 0Population1 Level of Significance = 0.05Number of Successes = 55Sample Size = 250Population 2 Level of Significance = 0.05Number of Successes = 75Sample Size = 250Lower Tail TestOKSlide16
Hypothesis Test – Pomona Fabrications
The Lower-Tail test shows that the Null Hypothesis should be rejected