Difference between revisions of "ANLY482 AY2017-18T2 Group30 Youtube"

From Analytics Practicum
Jump to navigation Jump to search
 
(4 intermediate revisions by 3 users not shown)
Line 9: Line 9:
 
{|style="background-color:#5A6B96; color:#5A6B96; width="100%" cellspacing="0" cellpadding="10" border="0" |
 
{|style="background-color:#5A6B96; color:#5A6B96; width="100%" cellspacing="0" cellpadding="10" border="0" |
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18_T2_Group_30|<font color="#FFFFFF" size=3><b>HOME</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18_T2_Group_30|<font color="#FFFFFF" size=3><b>HOME</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18T2_Group30 About Us |<font color="#FFFFFF" size=3><b>ABOUT US</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 About Us |<font color="#FFFFFF" size=3><b>ABOUT US</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18T2_Group30 Project Overview |<font color="#FFFFFF" size=3><b>PROJECT OVERVIEW </b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 Project Overview |<font color="#FFFFFF" size=3><b>PROJECT OVERVIEW </b></font>]]
  
|style="font-size:88%; border-left:1px solid #347cc4; border-right:1px solid #347cc4; text-align:center; border-bottom:1px solid #347cc4; border-top:1px solid #347cc4;" width="14%" |[[ANLY482_AY2017-18T2_Group30 Data Analysis |<font color="#347cc4" size=3><b>PROJECT FINDINGS</b></font>]]
+
|style="font-size:88%; border-left:1px solid #347cc4; border-right:1px solid #347cc4; text-align:center; border-bottom:1px solid #347cc4; border-top:1px solid #347cc4;" width="12.5%" |[[ANLY482_AY2017-18T2_Group30 Data Analysis |<font color="#347cc4" size=3><b>EDA</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18T2_Group30 Project Management |<font color="#FFFFFF" size=3><b>PROJECT MANAGEMENT</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 Business Objectives |<font color="#FFFFFF" size=3><b>BUSINESS OBJECTIVES </b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="15%" |[[ANLY482_AY2017-18T2_Group30 Documentation | <font color="#FFFFFF" size=3><b>DOCUMENTATION</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 Project Management |<font color="#FFFFFF" size=3><b>PROJECT MANAGEMENT</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="15%" |[[ANLY482_AY2017-18_Term_2 | <font color="#FFFFFF" size=3><b>MAIN PAGE</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" |[[ANLY482_AY2017-18T2_Group30 Documentation | <font color="#FFFFFF" size=3><b>DOCUMENTATION</b></font>]]
 +
 
 +
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" |[[ANLY482_AY2017-18_Term_2 | <font color="#FFFFFF" size=3><b>MAIN PAGE</b></font>]]
 
|}  
 
|}  
 
</center>
 
</center>
Line 47: Line 49:
 
<!---------------END of sub menu ---------------------->
 
<!---------------END of sub menu ---------------------->
 
<br>
 
<br>
<div align="center">
 
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Source</font></div>
 
</div>
 
  
<div align="left">
+
==<div style=" width: 96.5%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Source</font></div>==
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
+
 
 +
 
 +
<div style="width:96.5%;">
 
<font>
 
<font>
 
For data files from YouTube(Watch Time), the sponsor provided exported data for Watch Time, with different metric tabs in Excel format. The tabs included are:
 
For data files from YouTube(Watch Time), the sponsor provided exported data for Watch Time, with different metric tabs in Excel format. The tabs included are:
Line 71: Line 72:
 
</font></div>
 
</font></div>
  
<div align="center">
+
 
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Preparation</font></div>
+
==<div style=" width: 96.5%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Preparation</font></div>==
<div style="width:90%;">
+
 
</div>
+
 
<div align="left">
+
<div style="width:96.5%;">
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
 
 
<font>
 
<font>
 
<!---------Enter Text Here ------->
 
<!---------Enter Text Here ------->
 +
<p>No data preparation is required.</p>
 
</font>
 
</font>
 
</div>
 
</div>
</div>
 
  
<div align="center">
+
 
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Exploratory Data Analysis</font></div>
+
==<div style=" width: 96.5%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Exploratory Data Analysis</font></div>==
</div>
+
 
<div align="left">
+
<div style="width:96.5%;">
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
 
 
<font>
 
<font>
<!---------Enter Text Here ------->
+
As seen in the chart below, majority of viewers (>70%) fall into the age category of 18-34. Slightly over 10% of viewers fall into the age categories of 13-17 and 35-44 each as well, with less than 5% of views who are above 54.
</font>
+
 
</div>
+
[[File:Youtube viewers by age.png|449 × 520px|center]]
</div>
+
 
<br/>
+
Across all the age groups, there is always a larger percentage of female audience except for those 35 and older. The disparity is especially obvious in the 18-24 category, with almost twice as many female viewers.
 +
 
 +
[[File:Youtube_views_by_age_gender.png|589 × 548px|center]]
 +
 
 +
Despite differences in views for age and gender, there are no significant differences observed for the average duration (in minutes), which is around 4-5 minutes.
 +
 
 +
[[File:Youtube_view_duration_age_gender.png|775 × 687px|center]]
 +
 
 +
All of the above findings are consistent with that of Facebook Videos.
  
<div align="center">
 
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Final Application: Learning Dashboard</font></div>
 
</div>
 
<div align="left">
 
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
 
<font>
 
<!---------Enter Text Here ------->
 
 
</font>
 
</font>
</div>
 
</div>
 
<br/>
 
 
 
</div>
 
</div>

Latest revision as of 13:33, 10 April 2018

APex Logo.PNG


HOME ABOUT US PROJECT OVERVIEW EDA BUSINESS OBJECTIVES PROJECT MANAGEMENT DOCUMENTATION MAIN PAGE
Facebook Post Facebook Video Youtube Instagram Blog Post


Data Source

For data files from YouTube(Watch Time), the sponsor provided exported data for Watch Time, with different metric tabs in Excel format. The tabs included are:

  1. Video
  2. Geography
  3. Date
  4. Subscription Status
  5. Youtube Product
  6. Device Type
  7. Subtitles and CC
  8. Video Information Language


For data files from YouTube(Demographics), the sponsor provided exported data for watch time for different Demographic, with different metric tabs in Excel format. The tabs included are:

  1. Viewer Age
  2. Viewer Gender


For data files from YouTube(Traffic Sources), the sponsor provided exported data for watch time from different traffic source type


Data Preparation

No data preparation is required.


Exploratory Data Analysis

As seen in the chart below, majority of viewers (>70%) fall into the age category of 18-34. Slightly over 10% of viewers fall into the age categories of 13-17 and 35-44 each as well, with less than 5% of views who are above 54.

449 × 520px

Across all the age groups, there is always a larger percentage of female audience except for those 35 and older. The disparity is especially obvious in the 18-24 category, with almost twice as many female viewers.

589 × 548px

Despite differences in views for age and gender, there are no significant differences observed for the average duration (in minutes), which is around 4-5 minutes.

775 × 687px

All of the above findings are consistent with that of Facebook Videos.