Calculate measures of variability in Excel from a group of raw scores.Data:A sample of likes per post on Facebook: 45, 789, 16, 5, 486, 1, 87, 18, 48, 1

Instructions:Complete the following steps:

1. InstallthedataanalyticspackageinExcel.
2. oIfyouareunsureabouthowtodothis,visitLoadtheAnalysisToolpakinMicrosoft Excel,which has tutorials for both Windows and Mac. Used with permission from Microsoft.
3. EnterthedataaboveintoExcelusingthevariablenameData.IncellA1,typetheword "Data." Then, enter the data above in cells A2 to A11.
4. In theToolbar, clickData Analysis, SelectDescriptive Statistics, then clickOk.
5. Nexttoinputrangetype:$A$2:$A$11
6. Doublecheckthatsummarystatisticshasachecknexttoit.
7. ClickOK. A new sheet will appear to the right with your data.
8. Copyandpastethedescriptivestatisticstablebelow.
9. Highlight the range, mean, and standard deviation.