Statistics for Managers Using Microsoft Excel 7E - Levine - SM levine_smume7_ism_17

《Statistics for Managers Using Microsoft Excel 7E - Levine - SM levine_smume7_ism_17》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、SolutionstoEnd-of-SectionandChapterReviewProblems791CHAPTER1717.1Outputforthesummarystatisticsfortheprocessingtime:PlantAPlantBMean9.38211.3535StandardError0.8939023261.146243355Median8.51511.96Mode#N/A#N/AStandardDeviation3.9976527325.126156121SampleVariance15.9812273726.2774

2、7658Kurtosis3.8483924012.177017715Skewness1.6949505380.798989226Range17.223.42Minimum4.422.33Maximum21.6225.75Sum187.64227.07Count2020Ifyouassumethatthe20booksfromthetwoproductionplantsarenotmatchedand,hence,theprocessingtimefromthetwoproductionplantsareindependent,youcanuseei

3、therthepooled-variancettestortheseparatevariancettestforthedifferenceintwomeansifthedistributionofthetimeisnormalinbothplants.Copyright©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReviewProblems79117.1Investigatingthenormalprobabilityplots,theprocessingtimeappe

4、arstoberight-skewed.cont.Butbothttestsarequiterobusttothedeparturefromnormality.Nevertheless,aWilcoxonranksumtestmightbemoreappropriate.Fromthetableofsummarystatistics,theprocessingtimeofplantAislessdispersedaboutthemeanthanprocessingtimeofplantB.PerformtheFtestforthedifferenc

5、esintwovariances.vsOutputfortheFtestforthedifferencesintwovariances:FTestforDifferencesinTwoVariancesDataLevelofSignificance0.05Larger-VarianceSampleSampleSize20SampleStandardDeviation5.126156Smaller-VarianceSampleSampleSize20SampleStandardDeviation3.997653IntermediateCalculat

6、ionsFTestStatistic1.644271Population1SampleDegreesofFreedom19Population2SampleDegreesofFreedom19Two-TailTestUpperCriticalValue2.526451p-Value0.287188DonotrejectthenullhypothesisSincethep-value=0.2872islargerthan0.05,donotrejectH0.Thereisnotenoughevidenceofadifferenceinthetwopo

7、pulationvariances.Apooled-variancettestisperformedfirst.Copyright©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReviewProblems79117.1vscont.Pooled-VariancetTestfortheDifferenceBetweenTwoMeans(assumesequalpopulationvariances)DataHypothesizedDifference0.05LevelofSi

8、gnificance0.05Population1SampleSampleSize20SampleMean9.382Sam