Question

Student	Gender	Hours online/week	Friends
1	Female	9	100
2	Female	5	60
3	Female	2	50
4	female	12	110
5	male	4	50
6	female	2	80
7	male	10	450
8	female	7	90
9	female	2	30
10	female	4	150
11	female	12	380
12	male	7	120
13	female	6	80
14	male	3	200
15	male	8	430
16	female	7	170
17	male	4	90
18	female	6	240
19	female	4	280
20	female	2	30
21	female	10	400

For the Facebook data​ provided, find the​ range, variance, standard​ deviation, and interquartile range for hours​ online/week and number of friends in the sample using the appropriate Excel function. Compare these measures of location.Student Gender Hours online/week Friends 1 female 9 100 2 female 5 60 3 female 2 50 4 female 12 110 5 male 4 50 6 female 2 80 7 male 10 450 8 female 7 90 9 female 2 30 10 female 4 150 11 female 12 380 12 male 7 120 13 female 6 80 14 male 3 200 15 male 8 430 16 female 7 170 17 male 4 90 18 female 6 240 19 female 4 280 20 female 2 30 21 female 10 400

Answer 1

The given data is entered in the worksheet along with the labels from the cell A1 to cell D22.

Go to data, select data analysis, click on descriptive statistics. Give the input range as $C$1:$D$22, click on the checkbox of Labels, group by columns, select the summary statistics and give the output range as $F$1; click on OK.

From the output, we have the range, variance and the standard deviation as:

Statistic	Numeric Value for hours online/ week	Numeric values for number of friends
Sample Range	10	420
Sample Variance	10.5	19069.0476190476
Sample Standard Deviation	3.24037034920393	138.090722422064

Now to calculate the interquartile range for the hours online/week , we make the following computations:

For the first quartile, use the formula =quartile(c2:c22,1) and store it in cell J1

For the third quartile, use the formula =quartile(c2:c22,3) and store it in cell J2

Hence the interquartile range for the hours online/week is obtained by the formula =J2-J1 and the result is

4

Now to calculate the interquartile range for the number of friends , we make the following computations:

For the first quartile, use the formula =quartile(d2:d22,1) and store it in cell K1

For the third quartile, use the formula =quartile(d2:d22,3) and store it in cell K2

Hence the interquartile range for the number of friends is obtained by the formula =K2-K1 and the result is

160

All the measures of variability is higher for number of friends than hours online/ week and hence we can conclude that the variable number of friends has more variability than hours online/ week.

Hopefully this will help you. In case of any query, do comment. If you are satisfied with the query, give it a like. Thanks.