资源描述：
《Statistics for Managers Using Microsoft Excel 7E - Levine - SM levine_smume7_ism_03》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、SolutionstoEnd-of-SectionandChapterReviewProblems167CHAPTER33.1(a)Exceloutput:XMean6Median7Mode#N/AStandardDeviation2.915476SampleVariance8.5Range7Minimum2Maximum9Sum30Count5FirstQuartile3ThirdQuartile8.5InterquartileRange5.5CoefficientofVariation48.5913%Mean=6Median=7Thereisnomode.(b)Range
2、=7Variance=8.5Standarddeviation=2.9Coefficientofvariation=(2.915/6)•100%=48.6%(c)Zscores:0.343,-0.686,1.029,0.686,-1.372NoneoftheZscoresislargerthan3.0orsmallerthan-3.0.Thereisnooutlier.(d)Sincethemeanislessthanthemedian,thedistributionisleft-skewed.3.2(a)Exceloutput:XMean7Median7Mode7Stand
3、ardDeviation3.286335SampleVariance10.8Range9Minimum3Maximum12Sum42Count6FirstQuartile4ThirdQuartile9InterquartileRange5CoefficientofVariation46.9476%Mean=7Median=7Mode=7(b)Range=9Variance=10.8Standarddeviation=3.286Coefficientofvariation=(3.286/7)•100%=46.948%Copyright©2014PearsonEducation,
4、Inc.SolutionstoEnd-of-SectionandChapterReviewProblems1673.2(c)Zscores:0,-0.913,0.609,0,-1.217,1.522cont.NoneoftheZscoresislargerthan3.0orsmallerthan-3.0.Thereisnooutlier.(d)Sincethemeanequalsthemedian,thedistributionissymmetrical.3.3(a)Exceloutput:XMean6Median7Mode7StandardDeviation4SampleV
5、ariance16Kurtosis-0.34688Minimum0Maximum12Sum42Count7FirstQuartile3ThirdQuartile9InterquartileRange6CoefficientofVariation66.6667%Mean=6Median=7Mode=7(b)Range=12Variance=16Standarddeviation=4Coefficientofvariation=(4/6)•100%=66.67%(c)Zscores:1.5,0.25,-0.5,0.75,-1.5,0.25,-0.75.Thereisnooutli
6、er.(d)Sincethemeanislessthanthemedian,thedistributionisleft-skewed.3.4Exceloutput:XMean2Median7Mode7StandardDeviation7.874007874SampleVariance62Range17Minimum-8Maximum9Sum10Count5FirstQuartile-6.5ThirdQuartile8InterquartileRange14.5CoefficientofVariation393.7004%(a)Mean=2Median=7Mode=7Copyr
7、ight©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReviewProblems1673.4(b)Range=17Variance=62cont.Standarddeviation=7.874Coefficientofvariation=(7.874/2)•100%=393.7%(c)Zscores:0.635,-0.889,-1.270,0.635,0.889.Nooutliers.(d)Sincethemeanisless
