1 Student Gender Hours online/week Friends 2 1 female 7 90 For the Facebook data provided, find the mean, median, and midrange for hours online/week and number of friends in the sample using the appropriate Excel function or formulas. Compare these measures of location. Click the icon to view the data. 3 2 male 15 500 4 3 female 10 400 5 4 female 13 110 6 5 female 12 380 7 6 male 11 450 8 7 male 5 250 9 8 female 9 260 The mean for the number of hours online per week is 7.09 (Type an integer or a decimal rounded to two decimal places as needed.) The median for the number of hours online per week is 6 (Type an integer or a decimal rounded to two decimal places as needed.) The midrange for the number of hours online per week is 9 (Type an integer or a decimal rounded to two decimal places as needed.) The mean for the number of friends is 188.10 (Type an integer or a decimal rounded to two decimal places as needed.) The median for the number of friends is 120 (Type an integer or a decimal rounded to two decimal places as needed.) The midrange for the number of friends is 275. (Type an integer or a decimal rounded to two decimal places as needed.) Compare the measures of location for each data set. 10 9 female 9 100 11 10 female 6 240 12 11 male 4. 50 13 12 male 5 70 14 13 female 3 50 15 14 female 4 150 16 15 female 5 70 17 16 female 6 80 18 17 male 4 120 19 18 female 5 60 20 19 male 6 150 21 20 female 4 280 22 21 male 6 90 23 24 25 26 In each case, the is the lowest value, while the is the highest. This is because the 27 is most susceptible to outliers, while the is least susceptible to outliers. 28 29 30