版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领
文档简介
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. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2024出租土地建厂房合同
- 2024房屋贷款合同丢了办理
- 2024新版农民工劳动合同书范本
- 2024年企业培训与人才发展合同：含员工培训和职业生涯规划
- 2024格式合同样本范文
- 2024汽车修理厂劳动合同
- 2024弱电分包合同范本
- 2024年企业并购合同（金融服务行业）
- 2024吉林省木材购销合同
- 2024年大型客机零部件供应合同
- 成都麓湖生态城案例详解
- 2024年小升初数学模拟试卷
- 员工工伤事故报告（2篇）
- 广东省深圳市2023年中考英语试题(含答案与解析)
- 一片叶子落下来课件
- 手术室停水的应急预案
- 附件：9智能视镜
- 日常费用支出明细表
- 4.3 积极践行社会主义核心价值观
- 2023年初级出版资格证考试：初级出版理论与实务历年真题汇编（共476题）
- 乒乓球竞赛规则、规程与裁判法
评论
0/150
提交评论