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

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

1、SolutionstoEnd-of-SectionandChapterReviewProblems539CHAPTER1313.1(a)WhenX=0,theestimatedexpectedvalueofYis2.(b)ForeachincreaseinthevalueXby1unit,youcanexpectanincreasebyanestimated5unitsinthevalueofY.(c)13.2(a)yes,(b)no,(c)no,(d)yes13.3(a)WhenX=0,theestimatedexpectedvalueofYis16.(b)Foreachinc

2、reaseinthevalueXby1unit,youcanexpectadecreaseinanestimated0.5unitsinthevalueofY.(c)13.4(a)Thescatterplotshowsapositivelinearrelationship.(b)Foreachincreaseinshelfspaceofanadditionalfoot,thereisanexpectedincreaseinweeklysalesofanestimated$7.40.(c)=$204.20Copyright©2014PearsonEducation,Inc.Solu

3、tionstoEnd-of-SectionandChapterReviewProblems53913.5(a)(b)Exceloutput:(c)Foreachadditionalunitincreaseinsummatedrating,themeanpricewillincreasebyanestimated$1.47.Literalinterpretationofisnotmeaningfulbecauseasummatedratingof0isimpossibleinthesetup.(d).Copyright©2014PearsonEducation,Inc.Soluti

4、onstoEnd-of-SectionandChapterReviewProblems53913.6(a)(b)PartialExceloutput:CoefficientsStandardErrortStatP-valueIntercept-2.36972.0733-1.14300.2610Feet0.05010.003016.52230.0000(c)Theestimatedmeanamountoflaborwillincreaseby0.05hourforeachadditionalcubicfootmoved.(d)13.7(a)(b)(c)Foreachincrease

5、ofoneadditionalplategap,theestimatedmeantearratingwillincreaseby0.5.(d)Copyright©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReviewProblems53913.8(a)(b)PartialPHStatoutput:(c)Foreachadditionalmilliondollarsincreaseinrevenue,themeanannualvaluewillincreasebyanestimated5.1961mill

6、iondollars.Literalinterpretationofisnotmeaningfulbecauseanoperatingfranchisecannothavezerorevenue.(d)283.1143milliondollars13.9(a)(b)(c)Foreachincreaseof1squarefootinspace,theexpectedmonthlyrentalisestimatedtoincreaseby$1.0651.SinceXcannotbezero,theintercept1177.1208hasnopracticalinterpretati

7、on.(d)=$2242.2647(e)Anapartmentwith500squarefeetisoutsidetherelevantrangefortheindependentvariable.(f)Theapartmentwith1200squarefeethasthemorefavorablerentrelativetosize.Basedontheregressionequation,a1200squarefootapartmentwouldhaveanestimate