内容文稿教案学校homework week3lecture descriptives_第1页
内容文稿教案学校homework week3lecture descriptives_第2页
内容文稿教案学校homework week3lecture descriptives_第3页
内容文稿教案学校homework week3lecture descriptives_第4页
内容文稿教案学校homework week3lecture descriptives_第5页
已阅读5页，还剩25页未读， 继续免费阅读

下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

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. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

最新文档

评论

0/150

提交评论