




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
UsingFunctionsinexcelClickintocellb8andtype=ClickonthefunctioniconSelectStatisticalfromdropdownbox
Nowhighlightaverage(sameasmean)ClickOKSelectthedatausingrediconOkAnswer=4ThereareManyOTHERusefulstatisticalfunctionsinExcelSTDEV=standarddeviationMax=maximumvalueMin-minimumCorrel=correlation(forlaterinthismodule)Count=numberofcellscontainingdata-Tryusingsomeofthese-5minutesUsingExceltogenerateadvanceddescriptivestatsDescriptivestatisticsusingExcelLoadthedescriptivestatsworkbookandselectthevariabilityworksheetThisrequirestheDataanalysistoolpakTheanalysistoolpakisanexceladd-in.Ithelpswitharangeofstatisticalfunctions.AtYorkSt.Johnitisnotautomaticallyinstalled–butItcanbefoundasdetailedonnextslidesDataAnalysisToolpakIfitisnotinstalledperformthefollowing:File>options>addins>HighlightanalysisToolpakandthenselectGonotOKFinallySelectcheckboxanalysistoolpakclickokSelecttheDataTab&DATAAnalysisnowappears-thismeansthetoolpakhasbeenaddedDataTabDataAnalysisTheverybadnewsisatYSJyouwillhavetoinstallthiseverytimeyouwanttousedataanalysistools-athomeoronyourowncomputeritstaysadded!!!DescriptivestatisticsusingthedataanalysistoolpakSelectthedataanalysisandthenchoosedescriptivestatisticsClickokLoadtheFiledescriptivestatsworkbookweek3SelectthevariabilityworksheettabClickDataAnalysisSelectDescriptivestatsClickredbuttonHighlightthedataClickonredbuttonagainSelectcheckboxlabelsinfirstrowSelectsummarystatsClickonoutputrangeandselectviaredbuttonwheregraphshouldappearDescriptivestatisticsforproductAWhatoutputyouwantLabelinrowAProductAdataWheretheanswergoesWhatoutputyouwantDescriptivestatisticsforproductAAMean4StandardError0Median4Mode4StandardDeviation0SampleVariance0Kurtosis#DIV/0!Skewness#DIV/0!Range0Minimum4Maximum4Sum20Count5Meanmodeandmedianarethesame!!NovariationsorangeandSD=0Count=5numberofdataincolumnExercisesCheckyouranswersUsethedataanalysistoolpaktocalculatedescriptivestatisticsforproductsBandCandcheckyouranswersChangesomeofthenumbers/dataandcheckimpactonmean,medianandstandarddeviation.Usethedataanalysistoolpaktocalculatedescriptivestatisticsforthedatainthechocolateworksheet.FrequencydistributionsAfrequencydistributionisamethodoftallyingandrepresentinghowoftencertainscoresoccur.Scoresareusuallygroupedintoclassintervalsorrangesofnumbers.Frequencydistribution4830504846645852343052526252904854563842366046684076403052366274485058606636545470365480466444505248547062604064626644547872564244486662406052726240586862684870664452626254543648383846724662663474643844743270383430
4272585448563266
3240584848586486
4076565048504488
ThefollowingscoreswereobtainedbystudentsinanassessmentChooseintervalsandgroupdataAnintervalof5markshasbeenchosenUsebetween10and20intervalsStartwiththelowestandincludethehighestTallymarkscanbeusedtopreparedatamanuallyThedatawillnowlooklike….FrequencydistributionRangeTallymarksFrequency26-301111431-3511111636-401111
1111
1111111741-4511111111946-501111
1111
1111
111112151-551111
1111
1111111756-601111
111111111461-651111
1111
11111566-701111
11111111371-75111111776-801111481-85
0FrequencychartGotofrequencyworksheet.ThisshowsthesamerangeandfrequencyHighlightthedatayouwanttousetocreatethechart(A1:B15)Clicktheinserttabandinthechartsgroup,selectcolumnandchoosethefirst2Dcolumnchart.FrequencychartHistogramAfrequencychartneedsthedatatobesummarisedAhistogramcanworkwiththeoriginaldataSimilartoabarchartexcept:ThebarsmaynotallbethesamewidthTheareaofeachbarisimportantPreparinghistogramsOpenhistogramworksheet.ThiscontainsthesamerawdataandtherangesrequiredExcelcallsintervals‘bins’(e.g.26-30,31-35etc.)–(whenanalysingyourowndatayouhavetodecideonthebinrangesandtypetheseintoexcelastheexampleweareusing)SpecifiedusingthehighestvalueofeachintervalBinsshouldbeinascendingorder.Enterthetitle‘Interval’incellD1Enterthebins30,35throughto95incellsD2:D15SelectDataTab,dataanalysis,histogramOriginaldataBinrangeTherearelabelsOutputrangeTicktheseHistogramBinFrequencyCumulative%3043.05%3567.63%401720.61%45927.48%502244.27%551757.25%601467.94%651579.39%701389.31%75794.66%80497.71%85097.71%903100.00%950100.00%More0100.00%HistogramThechartshowscolumnsforfrequencyandalinegraphforcumulativefrequency.ThecumulativefrequencyaddsallthepreviousitemsThereisacategorycalledmoreforanyitemswhichfalloutsidethespecifiedrange.ExerciseUseExceltocalculatedescriptivestatisticsforthedatainthehistogramworksheetCommentonyouranswerFurtherexamplesOpenRunforallworksheetCalculatedescriptivestatisticsPreparehistogramsusingdifferentbinrangesSortandpreparehistogramsformenandwomenseparatelyCommento
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 【正版授权】 IEC 60335-2-78:2021+AMD1:2025 CSV EN Household and similar electrical appliances - Safety - Part 2-78: Particular requirements for outdoor barbecues
- 个人股份转让协议书
- 劳务合同到期不续签
- 信息管理系统建设及维护合同
- 石油钻井服务合同
- 房屋委托租赁居间服务合同
- 大型挖掘机买卖合同
- 综合办公服务合同
- 双11策划活动方案模板
- 公司内部借款协议
- 贵州省教育科学规划课题申请书
- 火针疗法课件
- 学校行政领导夜间值班制度
- 托莱西单抗注射液 (CXSS2200059)说明书
- 合同移交登记表
- 南方医科大学深圳医院核技术利用扩建项目项目环境影响报告表
- C++面向对象的程序设计课件
- 保险产说会(养老主题)课件
- 风景园林工程初步设计文件编制深度规定
- 六年级心理健康导学案-10真正的朋友 |大象版
- 大专建筑工程毕业论文6000字
评论
0/150
提交评论