Module 1 Analytics

profilecpowers
Module1Homework2.xlsx

Problem 1

MPG Problem. The data below is a sample of several cars' MPG. Calculate the specified quantities
MPG Mean:
33 Median
28 Mode 1
27 Mode 2
21
31 Range
32 Variance
35 Standard Deviation
28
28 Coefficient of Variation
35
29 92nd Percentile
33
26 1st Quartile
34 2nd Quartile
33 3rd Quartile
31
30 IQR
34
22
23
35
28
20
19
22
21
32
26
31
29
29
34
27
32
27
30
27
18
30

Problem 2

Problem 2.5(b) - p. 72
Preferred Show Bins Frequency Relative Frequency Percent Frequency (%)
YAH WIKI YT WIKI GOOG
YT YAH GOOG GOOG GOOG
WIKI GOOG YAH YAH YAH
YAH YT GOOG YT YAH
GOOG FB FB WIKI GOOG
GOOG GOOG FB FB WIKI
FB YAH YT YAH YAH
YT GOOG YAH FB FB
WIKI GOOG YAH WIKI WIKI
YAH YT GOOG GOOG WIKI

 In a recent report, the top five most-visited English-language web sites were google.com (GOOG), facebook.com (FB), youtube.com (YT), yahoo.com (YAH), and wikipedia.com (WIKI). The most-visited web sites for a sample of 50 Internet users are shown in table below. b. Provide frequency and percent frequency distributions.