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

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

1、929InstructionalTipsandSolutionsforDigitalCasesInstructionalTipsandSolutionsforDigitalCasesChapter2InstructionalTips1.StudentsshoulddevelopafrequencydistributionoftheMoreWinnersdataalongwithatleastonegraphsuchasahistogram,polygon,orcumulativepercentagepolygon.2.Oneobjectiveistohavestuden

2、tslookbeyondtheactualstatisticalresultsgeneratedtoevaluatetheclaimspresented.FortheMoreWinnersdata,thismightincludeacomparisonwithtablesandchartsdevelopedfortheentireMutualFundsdataset.Suchacomparisonwouldleadtotherealizationthatalleightfundsinthe“BigEight”arehigh-riskfundsthatmayhaveagr

3、eatdealofvariationintheirreturn.3.Thepresentationofinformationcanleadtodifferentperceptionsofabusiness.Thiscanbeseenintheaggressiveapproachtakeninthehomepage.Solutions1.Yes.Thereisabreathless,exaggeratedstyletothewritingandtheillustrationsareverybusyandcolorfulwithoutconveyingmuchinforma

4、tion.Thereisalsoacertainaggressivenessinexclamationsto“showmethedata.”Claimsaremade,butsupportingevidenceisscant.Thestyleisreminiscentofamisleadinginfommercial.Thegraphsonpages5and6havepoordesignthatobscurestheirmeaning,ifany.Also,nowhereinthedocumentdoesEndRundiscloseitsprincipalsandthe

5、addressofitsoperations,somethingthatareputablebusinesswouldsurelydo.Andatestimonialpageattheendismoresuitableforaninfommercialsellingaconsumerproductandnotsomethingonewouldexpecttoseefromareputablefinancialservicesfirm.2.Frequencies(Return(%))BinsFrequencyPercentageCumulative%Midpts-5000

6、.00%.00%----4013.45%3.45%-45-30310.34%13.79%-35-20413.79%27.59%-25-1026.90%34.48%-15-0.0113.45%37.93%-59.99931.03%68.97%520310.34%79.31%153026.90%86.21%2540310.34%96.55%355013.45%100.00%45Copyright©2014PearsonEducation,Inc.929InstructionalTipsandSolutionsforDigitalCasesAlthoughtheclaimis

7、literallytrue,thedatashowawiderangeofreturnsforthe29mutualfundsselectedbyEndRuninvestors.Although18fundshadpositivereturns,11hadnegativereturnsforthefiveyearperiod.Ofthefundshavingnegativereturns,manyhadlargelosses,with27.59%havingannualizedlossesof20%ormore.Manyoftheposi