The numerical measures can be processed easily using any scientific or graphical calculator withstatistical functions. Refer to the manual of your calculator to determine how to get the mean and thestandarddeviation(bothforasampleorapopulation).SomestatisticalsoftwarepackageslikePHStat,Statistica,Statistical package forSocial sciences(SPSS),Statistical AnalysisSystem (SAS),orJeffreys'sAmazingStatisticalProgram(JASP)canalsobeusedtoprocessthesenumericalmeasures.

ThisactivitywillletyouobtainnumericalmeasuresusingMicrosoftExcel.TakenotethatthestepsareforMicrosoft Windows 7.Makesurethatthe Analysis ToolPakis enabled.

Step1: Inputthelabeland thenumericaldatasetbelowin thefirstcolumn ofablankworksheet.

Scoresof30Students

64	72	81	84	89	95
66	73	82	86	91	96
66	76	83	87	92	98
67	78	83	88	93	98
69	79	83	88	95	99

Step 2: Click theData tab, thenData Analysis.When the data Analysis dialog box appears, drag themouseonthedatasettoletitappearintheInputRange:box.SelectGroupby:Columns.Putacheckin theLabels in First Rowcheckbox. Then put a check in theSummary statisticscheckbox. Clickok.Theexpectedoutputwill appearonanothersheet.

Step 3:To make a graphical presentation of data, make sure to have a tally of your information (Scores,Frequency). Drag on the data set and click theInserttab then choose any type of graph. Design andformatyourgraphby clickingtheDesignorFormattab.

Step4:CopyandpastetheexpectedoutputfromMSExceltoMSWord.Makesuretohaveagraphicalpresentationofdatatogetherwithitsnumericalmeasures(mean,median,mode,range,variance,etc.)inMSword.

Step5:Giveaninterpretationof thedataset anditsnumericalmeasures.