To Accompany Business Statistics A Decision Making Approach 8th Ed Chapter 17 Introduction to Nonparametric Statistics By Groebner Shannon Fry amp Smith PrenticeHall Publishing Company ID: 207369
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 17:Introduction to Nonparametric StatisticsByGroebner, Shannon, Fry, & SmithPrentice-Hall Publishing CompanyCopyright, 2011Slide2
Chapter 17 Excel ExamplesMann-Whitney
U-Test - Large Samples Future-VisionKruskal-Wallis Test Amalgamated SugarSlide3
Mann-Whitney Test - Large Samples - Future Vision
Issue: The managers of a local TV station believe median household income for cable subscribers is less than the median for those who do not subscribe. Objective: Use Excel 2007 to perform the appropriate nonparametric statistical test. Date file is Future-Vision.xlsRank file is Future-Vision-Ranks.xlsSlide4
Large Sample Mann-Whitney Test – Future Vision
Open the Excel file FutureVision.xls to view the actual data. Income data must be converted to ranks. Slide5
Large Sample Mann-Whitney Test – Future Vision
Open the Excel file Future-Vision-Ranks.xls to view the ranked data separated into Non Cable and Cable columns.Hypothesis will be:Ho: Medc > MedncHa: Medc
<
Med
nc
Slide6
Large Sample Mann-Whitney Test – Future Vision
Sum the ranks of each column to compute the U-value.Using equations 17.2 and 17.3 respectively, U(noncable) = 27,412U(cable) =30,764Need to look at the alternative hypothesis to decide which is UU(noncable) = U = 27,412Using Equations 17.4 and 17.5μ = 29,088; σ = 1,631.43Using Equation 17-6 z = -1.027Using α = -1.645
Do not reject the null hypothesis and conclude that noncable families having higher median incomes than cable families is not supportedSlide7
Kruskal-Wallis Test - Amalgamated Sugar
Issue: The company is interested in determining whether there is a difference in down-time between its three operational shifts.Objective: Use Excel 2007 to determine whether there is a statistically significant difference in downtime between the three shifts. Data file is Amalgamated.xlsSlide8
Kruskal-Wallis Test – Amalgamated Sugar
Open the file Amalgamated.xlsSlide9
Kruskal-Wallis Test – Amalgamated Sugar
Select Add-InsSelect PHStatSelect Multiple-Sample TestsSelect Kruskal-Wallis Rank TestSlide10
Kruskal-Wallis Test – Amalgamated Sugar
Define the Level of Significance and the Data RangeSlide11
Kruskal-Wallis Test – Amalgamated Sugar
The output presents:The H Test StatisticThe p-ValueThe correct Decision