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

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

1、SolutionstoEnd-of-SectionandChapterReviewProblems645CHAPTER1515.1(a)(b)with22degreesoffreedom.RejectH0.Thequadratictermissignificant.(c)with22degreesoffreedom.DonotrejectH0.Thequadratictermisnotsignificant.(d)15.2(a)GPAPredictedHOCSGPAPredictedHOCS22.860033.99002.13.0342

2、3.14.02822.23.19483.24.05282.33.34183.34.06382.43.47523.44.06122.53.59503.54.04502.63.70123.64.01522.73.79383.73.97182.83.87283.83.91482.93.93823.93.844243.7600(b)(c)ThecurvilinearrelationshipsuggeststhatHOCSincreasesatadecreasingrate.Itreachesitsmaximumvalueof4.0638atGP

3、A=3.3anddeclinesafterthatasGPAcontinuestoincrease.(d)Anr2of0.07andanadjustedr2of0.06tellyouthatGPAhasverylowexplanatorypowerinexplainingthevariationinHOCS.YoucantellthattheindividualHOCSscoreswillhavescatteredquitewidelyaroundthecurvilinearrelationshipplottedin(b)anddisc

4、ussedin(c).Copyright©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReviewProblems64515.3(a)(b)(c)$6.86307thousands(d)Theresidualsplotdoesnotrevealanynon-linearity.Thenormalprobabilityplotdoesnotindicateanydeparturefromthenormalityassumption.(e)H0:H1:Atleast

5、oneisnot0.FSTAT=58.4906withap-valueofvirtuallyzero.RejectH0.Theoverallquadraticrelationshipissignificant.Copyright©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReviewProblems64515.3(f)H0:0H1:0cont.tSTAT=-2.9403withap-value=0.0091<0.05.RejectH0.Atthe0.05lev

6、elofsignificance,thequadraticmodelisbetterthanthelinearmodel.(g)0.8731.So,87.31%ofthevariationinsalescanbeexplainedbythequadraticrelationshipbetweensalesandnewspaperadvertising.(h)0.858215.4(a)Exceloutput:,whereX1=Alcohol%andX2=Carbohydrates.(b)Exceloutput:,whereX1=Alcoh

7、ol%andX2=Carbohydrates.Copyright©2014PearsonEducation,Inc.SolutionstoEnd-of-SectionandChapterReviewProblems64515.4(c)H0:0H1:Notall=0forj=3,4cont.FSTAT==4.5935with2numeratorand145denominatordegreesoffreedom.Fcrit=3.0585.Thep-valueis0.0116.Sincethep-value=0.0116<0.05,rejec

8、tH0.At5%levelofsignificance,thequadratictermsaresignificanttogether.Hence,themodelin(b)isbetter.H0:0vs.