90.2K

Verified Solution

Link Copied!

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 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 In each case the is the lowest value while the is most susceptible to outliers while the is the highest This is because the is least susceptible to outliers 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Gender Hours online week Friends 1 female 2 male 3 female 4 female 5 female 6 male 7 male 8 female 9 female 10 female 11 male 12 male 13 female 14 female Student 15 female 16 female 17 male 18 female 19 male 20 female 21 male 7 15 10 13 12 11 5 9 9 6 4 5 3 4 5 6 4 5 6 4 6 90 500 400 110 380 450 250 260 100 240 50 70 50 150 70 80 120 60 150 280 90

Answer & Explanation Solved by verified expert

See Answer