欢迎来到天天文库
浏览记录
ID:7942081
大小:2.36 MB
页数:63页
时间:2018-03-02
《excel for statistics外语英文电子书》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、SECTION2-EXCELFORSTATISTICSTABLEOFCONTENTS1USINGEXCELFORSTATISTICALANALYSIS22SETTINGUPEXCELFORSTATISTICALANALYSIS33OPENINGUPANONEXCELFILEINEXCEL64CALCULATINGMEAN,MEDIAN,MODEANDCONFIDENCELEVEL105RANKANDPERCENTILE146GENERATINGARANDOMSAMPLE177TABULATINGDATAINTOINTERVALS198GRAPHINGTHEDATA249BIN
2、OMIALDISTRIBUTION3110HYPOTHESISTESTING-ONEPOPULATION3611TWOPOPULATIONMEANSHYPOTHESISTESTING4012HYPOTHESISTESTING-TWOPOPULATIONS(SMALLSAMPLES,UNEQUALOREQUALVARIANCES,PAIRED)4313CHI-SQUARE4914CORRELATIONANDLINEARREGRESSION53Page2-11UsingExcelforStatisticalAnalysisIntheworkenvironment,youwillb
3、eanalyzinglargedatabasesusingthestatisticalprocedureswelearnedinclass.Forthemostpart,youwillbeusingsoftwareprogramstoperformtheanalysis.Excelhasbeenselectedforthisclassbecauseitisthemostcommonlyusedanalysispackageinbusiness.TheobjectiveofusingExcelinourassignmentsisto:Analyzelargeandrealdat
4、abases.WewillbeusinganumberofsourcesincludingtheCensus,theFederalReserveandthestockmarket.Becomeskilledatthemechanicsofusingthesoftware(Thesimplestpartofthewholeexercise)Analyzeandinterprettheoutput(Themostimportantpartoftheexercise)Commonerrorstoavoid:Notunderstandingwhattherawdatais:Looka
5、tandunderstandyourdata.Youshouldunderstandwhatisbeingmeasured,whattheunitofmeasurementisandtheshortcomingsofthemeasure.Readfootnotesandglossaries.RecalculatingwhatExcelhasalreadydone:Don'trecalculate.Excelisdoingtheworkforyou.Itisimportantthatyouinputtherightdata.Notsavinganalysis:Computers
6、havebeenknowntogodown.Saveyouranalysiseveryfivetotenminutestosaveaggravation.Page2-22SettingUpExcelforStatisticalAnalysisOpenExcelandClickonToolsIfyouhaveDataAnalysisasaselectionthengoontotheanalysisIfyoudon't,clickonAdd-InsSettingupExcelforStatisticalAnalysisPage2-3SelectAnalysisToolPakfro
7、mtheselectionofAdd-InsClickonOKSettingupExcelforStatisticalAnalysisPage2-4SelectToolsagainandthenSelectDataAnalysisSettingupExcelforStatisticalAnalysisPage2-53OpeningUpaNonExcelFileinExcelFileFormattedtoExcelYouhavegonetothetheinternetandsavedthefileinyo
此文档下载收益归作者所有