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

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

1、SolutionstoEnd-of-SectionandChapterReviewProblems223CHAPTER55.1PHStatoutputforDistributionA:Probabilities&Outcomes:PXY0.500.210.1520.130.054StatisticsE(X)1E(Y)0Variance(X)1.5StandardDeviation(X)1.224745Variance(Y)0StandardDeviation(Y)0Covariance(XY)0Variance(X+Y)1.5StandardDeviation(X+

2、Y)1.224745PHStatoutputforDistributionB:Probabilities&Outcomes:PXY0.0500.110.1520.230.54StatisticsE(X)3E(Y)0Variance(X)1.5StandardDeviation(X)1.224745Variance(Y)0StandardDeviation(Y)0Covariance(XY)0Variance(X+Y)1.5StandardDeviation(X+Y)1.224745Copyright©2014PearsonEducation,Inc.Solution

3、stoEnd-of-SectionandChapterReviewProblems2235.1(a)DistributionADistributionBcont.XP(X)X*P(X)XP(X)X*P(X)00.500.0000.050.0010.200.2010.100.1020.150.3020.150.3030.100.3030.200.6040.050.2040.502.001.001.001.003.00=1.00=3.00(b)DistributionAX(X–)2P(X)(X–)2*P(X)0(–1)20.500.501(0)20.200.002(1)

4、20.150.153(2)20.100.404(3)20.050.452=1.50=1.22(b)DistributionBX(X–)2P(X)(X–)2*P(X)0(–3)20.050.451(–2)20.100.402(–1)20.150.153(0)20.200.004(1)20.500.502=1.50=1.22(c)Themeansaredifferentbutthevariancesarethesame.Copyright©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReview

5、Problems2235.2PHStatoutput:Probabilities&Outcomes:PX0.100.210.4520.1530.0540.055StatisticsE(X)2E(Y)0Variance(X)1.4StandardDeviation(X)1.183216Variance(Y)0StandardDeviation(Y)0Covariance(XY)0Variance(X+Y)1.4StandardDeviation(X+Y)1.183216(a)-(b)XP(x)X*P(X)(X-)2(X-)2*P(X)00.100.0040.4010.

6、200.2010.2020.450.9000.0030.150.4510.1540.050.2040.2050.050.2590.45(a)Mean=2.00Variance=1.40(b)Stdev=1.183215965.3(a)Basedonthefactthattheoddsofwinningareexpressedoutwithabaseof31,478,youwillthinkthattheautomobiledealershipsentout31,478fliers.(b)=$5.49(c)=$84.56(d)Thetotalcostofthepriz

7、esis$15,000+$500+31,476*$5=$172,880.Assumingthatthecostofproducingthefliersisnegligible,thecostofreachingasinglecustomeris$172,880/31478=$5.49.Theeffectivenessofthepromotionwilldependonhowmanycustomerswillshowupintheshowroom.5.4(a)XP(X)(b)XP(X)(c)XP(X)$–121/36$–121/36$–130/36$+115/36