-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.)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman