Youtube Data Analysis

	A	B	C	D	E
1	Total Views	177982
2	Total Watch Time (Minutes)	150841	0.8475070513	50.85042308
3
4	By Country
5	Country	Country Views (Total)	% of Total Views	Total Population (Millions)	Views Per Million People
6	United States	61000	34%	318.9	191
7	United Kingdom	59000	33%	64.1	920
8	Japan	11000	6%	127.3	86
9	Brazil	9000	5%	200.4	45
10	Germany	4900	3%	80.6	61
11	Canada	4500	3%	35.2	128
12	Italy	4400	2%	59.8	74
13	Australia	2500	1%	23.1	108
14	Netherlands	2300	1%	16.8	137
15	Spain	2200	1%	46.8	47
16
17
18
19
20
21
22	By Device Type
23	ID	device_type	watch_time_minutes	views	% of Total Views
24	1	DESKTOP	71564	93119	52%
25	2	MOBILE	56974	62342	35%
26	3	TABLET	19975	20444	11%
27	4	GAME_CONSOLE	964	1079	1%
28	5	TV	887	624	0%
29	6	UNKNOWN_PLATFORM	477	374	0%
30
31
32
33
34
35
36
37
38
39
40	By Age
41	Age	% of Total Views	% of Population	View %/Population %
42	13-17	1%	8%	0.13
43	18-24	20%	12%	1.74
44	25-34	38%	16%	2.32
45	35-44	21%	15%	1.39
46	45-54	11%	16%	0.69
47	55-64	4%	15%	0.26
48	65-	4%	18%	0.22
49
50				0.7505720824
51
52
53
54
55
56
57
58
59
60	By Gender
61	Gender	% of Total Views
62	Female	0.066361629
63	Male	0.933638371
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79	Female Views by Age
80	Age	Gender	% of Total Views	% of Age Group
81	13-17	f	0.10%	7.14%
82	18-24	f	1.30%	6.40%
83	25-34	f	2.60%	6.75%
84	35-44	f	1.40%	6.73%
85	45-54	f	0.70%	6.31%
86	55-64	f	0.30%	7.50%
87	65-	f	0.30%	7.69%
88
89
90
91
92
93
94
95
96
97	Source of View
98	traffic_source	watch_time_minutes	views	% of Total Views
99	YT_CHANNEL	41401	59458	34.36%
100	YT_RELATED	35475	37468	21.65%