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 Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution