-of 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 Click the icon to view the data. The mean for the number of hours online per week is (Type an integer or a decimal rounded to two decimal places as needed.)

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 8PPS
icon
Related questions
Question
Hello, can I get some help with this? Thank you
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.
E Click the icon to view the data.
The mean for the number of hours online per week is.
(Type an integer or a decimal rounded to two decimal places as needed.)
Transcribed Image Text: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. E Click the icon to view the data. The mean for the number of hours online per week is. (Type an integer or a decimal rounded to two decimal places as needed.)
Facebook Survey
Student
Gender
Hours online/week Friends
1
male
200
female
50
3
female
50
4
female
12
380
female
170
male
4
120
7
female
80
8
female
30
9.
male
430
10
male
5.
70
11
female
4.
280
12
female
12
110
13
female
10
400
14
male
4
50
15
male
250
16
female
100
17
male
180
18
female
70
19
female
30
20
female
90
21
male
120
596 527
Transcribed Image Text:Facebook Survey Student Gender Hours online/week Friends 1 male 200 female 50 3 female 50 4 female 12 380 female 170 male 4 120 7 female 80 8 female 30 9. male 430 10 male 5. 70 11 female 4. 280 12 female 12 110 13 female 10 400 14 male 4 50 15 male 250 16 female 100 17 male 180 18 female 70 19 female 30 20 female 90 21 male 120 596 527
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
PREALGEBRA
PREALGEBRA
Algebra
ISBN:
9781938168994
Author:
OpenStax
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL