Data Analysis expert needed
maq
1sthwforstat250.docxSAMPLe HW 1 done last week
Data Analysis Assignment 1
Problem 1: Streaming Device
A)
Frequency table results for Streaming Device: Count = 220
|
Streaming Device |
Frequency |
Percent of Total |
|
Amazon Fire |
29 |
13.18 |
|
Apple TV |
30 |
13.64 |
|
Google Chromecast |
17 |
7.73 |
|
None |
40 |
18.18 |
|
Other |
15 |
6.82 |
|
Roku |
89 |
40.45 |
B)
The most popular steam device is “Roku” and the least one is “other” because Roku have 40.45% total of people watching and other is 6.82 % of others.
C)
Contingency table results: Rows: Streaming Device Columns: Monthly Cable
|
Cell format |
|
Count (Percent of total) |
|
|
No |
Yes |
Total |
|
Amazon Fire |
11 (5%) |
18 (8.18%) |
29 (13.18%) |
|
Apple TV |
9 (4.09%) |
21 (9.55%) |
30 (13.64%) |
|
Google Chromecast |
8 (3.64%) |
9 (4.09%) |
17 (7.73%) |
|
None |
10 (4.55%) |
30 (13.64%) |
40 (18.18%) |
|
Other |
3 (1.36%) |
12 (5.45%) |
15 (6.82%) |
|
Roku |
22 (10%) |
67 (30.45%) |
89 (40.45%) |
|
Total |
63 (28.64%) |
157 (71.36%) |
220 (100%) |
D)
The frequency totals are the same in both graphs.
E)
Contingency table results: Rows: Streaming Device Columns: Monthly Cable
|
Cell format |
|
Count (Row percent) (Percent of total) |
|
|
No |
Yes |
Total |
|
Amazon Fire |
11 (37.93%) (5%) |
18 (62.07%) (8.18%) |
29 (100%) (13.18%) |
|
Apple TV |
9 (30%) (4.09%) |
21 (70%) (9.55%) |
30 (100%) (13.64%) |
|
Google Chromecast |
8 (47.06%) (3.64%) |
9 (52.94%) (4.09%) |
17 (100%) (7.73%) |
|
None |
10 (25%) (4.55%) |
30 (75%) (13.64%) |
40 (100%) (18.18%) |
|
Other |
3 (20%) (1.36%) |
12 (80%) (5.45%) |
15 (100%) (6.82%) |
|
Roku |
22 (24.72%) (10%) |
67 (75.28%) (30.45%) |
89 (100%) (40.45%) |
|
Total |
63 (28.64%) (28.64%) |
157 (71.36%) (71.36%) |
220 (100%) (100%) |
This table represents the row percent totals along with the percent of total.
Contingency table results: Rows: Streaming Device Columns: Monthly Cable
|
Cell format |
|
Count (Column percent) (Percent of total) |
|
|
No |
Yes |
Total |
|
Amazon Fire |
11 (17.46%) (5%) |
18 (11.46%) (8.18%) |
29 (13.18%) (13.18%) |
|
Apple TV |
9 (14.29%) (4.09%) |
21 (13.38%) (9.55%) |
30 (13.64%) (13.64%) |
|
Google Chromecast |
8 (12.7%) (3.64%) |
9 (5.73%) (4.09%) |
17 (7.73%) (7.73%) |
|
None |
10 (15.87%) (4.55%) |
30 (19.11%) (13.64%) |
40 (18.18%) (18.18%) |
|
Other |
3 (4.76%) (1.36%) |
12 (7.64%) (5.45%) |
15 (6.82%) (6.82%) |
|
Roku |
22 (34.92%) (10%) |
67 (42.68%) (30.45%) |
89 (40.45%) (40.45%) |
|
Total |
63 (100%) (28.64%) |
157 (100%) (71.36%) |
220 (100%) (100%) |
This table represents the total percent of the columns along with percent of total. The Roku total is 40.45 % total in both tables.
Problem 2: Home Run Distances
A)
B)
The first graph shows amount of Home Runs and the second graph shows the relative frequency of Home Runs.
C)
Summary Statistics:
|
Mean |
401.47 |
|
Std. dev. |
29.527 |
D)
Summary statistics:
|
Column |
|
Max |
Min |
Q1 |
Q3 |
IQR |
|
Distance |
|
495 |
339 |
381 |
420.5 |
39.5 |
E)
Q1-1.5xIQR=Lower fence
381-1.5x39.5
381-59.25= 321.75
Q3+1.5xIQR= Upper fence
420.5+1.5xIQR
420.5+59.25=479.75
If anything is less than 321.75 or greater than 479.75, it is an outlier. There are two in this graph, the first is Schimp, Ryan and the second is Ruf, Darin because they are outside of the upper fence.
Problem 3: Song Year
A)
B)
The percentage of songs released before 1990 was 18%.
C)
The shape of this histogram appears to be left skewed with the tail feather to the left.
D)
Summary Statistics:
|
Mean |
1997.51 |
|
Median |
1999.5 |
E)
There are 7 outliers that are at extreme values anything created before 1973.
LIST:
The band-1968-caledionia mission
Simon and Garfunkel- 1966- Richard Coy
The beatles-1964-Cant buy me love
Andy Williams-1970-cant get us
The beatles- 1969- you never get your money
Paul McCartney-1970-Man we was lonely
Problem 4: Streaming Devices Revisited
A)
Frequency Bar Chart
Frequency Pareto Chart
Pie Chart
B)
According to all these graphs Roku is the most popular streaming device.
C)
First bar chart
Second bar chart
In both charts the data is the same but it looks different in the graphs. This is the same with problem one because it’s the same data.
1
1
S
A
M
P
L
e
H
W
1
d
o
n
e
l
a
s
t
w
e
e
k
Data Analysis Assignment 1
Problem 1:
Streaming Device
A)
Frequency table results for Streaming Device:
Count = 220
Streaming Device
Frequency
Percent of Total
Amazon Fire
29
13.18
Apple TV
30
13.6
4
Chromecast
17
7.7
3
None
40
18.18
Other
15
6.8
2
Roku
89
40.45
B)
The most popular
steam device is “Roku” and the least
one is “other” because Roku have
40.45% total of people watching and other is 6.82 % of others.
C)
Contingency table results:
Rows: Streaming Device
Columns: Monthly Cable
Cell format
Count
(Percent of total)
No
Yes
Total
Amazon Fire
11
(5%)
18
(8.18%)
29
(13.18%)
Apple TV
9
(4.09%)
21
(9.55%)
30
(13.64%)
Google Chromecast
8
(3.64%)
9
(4.09%)
17
(7.73%)
None
10
(4.55%)
30
(13.64%)
40
(18.18%)
Other
3
(1.36%)
12
(5.45%)
15
(6.82%)
Roku
22
(10%)
67
(30.45%)
89
(40.45%)
Total
63
(28.64%)
157
(71.36%)
220
(100%)
