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. F.E.9.656.67xSubscription Required to Edit and Save Start your free one mA1fx StudentC.Hours online/weekD.FriendsB.1.StudentGender1male150002 female12103 female4 female5.095.5 female9.6.6 female1707.7 male8 male4.4069 male10 female11 female12 male250131413 female3401514 female15015 male4509616 female42801717 female1238018.18 female21302019 male1806.20 male3.2221 male06232425272831

Answered: For the Facebook data provided, find…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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.

F.
E.
9.
65
6.
67
xSubscription Required to Edit and Save Start your free one m
A1
fx Student
C.
Hours online/week
D.
Friends
B.
1.
Student
Gender
1male
15
000
2 female
12
10
3 female
4 female
5.
09
5.
5 female
9.
6.
6 female
170
7.
7 male
8 male
4.
4
06
9 male
10 female
11 female
12 male
250
13
14
13 female
340
15
14 female
150
15 male
450
96
16 female
4
280
17
17 female
12
380
18.
18 female
21
30
20
19 male
180
6.
20 male
3.
22
21 male
06
23
24
25
27
28
31

Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.

Expert Solution