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

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter10: Sequences, Series, And Probability
Section10.2: Arithmetic Sequences
Problem 54E
icon
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
Transcribed Image Text: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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill