Difference between revisions of "ANLY482 AY2017-18T2 Group30 Youtube"
Jump to navigation
Jump to search
| (5 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=" | + | |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=" | + | |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=" | + | |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=" | + | |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=" | + | |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=" | + | |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=" | + | |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 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: | + | |
| + | |||
| + | <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 style=" width: | + | ==<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:96.5%;"> | |
| − | <div style=" width: | ||
<font> | <font> | ||
<!---------Enter Text Here -------> | <!---------Enter Text Here -------> | ||
| + | <p>No data preparation is required.</p> | ||
</font> | </font> | ||
</div> | </div> | ||
| − | |||
| − | + | ||
| − | <div style=" width: | + | ==<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 style="width:96.5%;"> | |
| − | <div style=" width: | ||
<font> | <font> | ||
| − | + | 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. | |
| − | + | ||
| − | + | [[File:Youtube viewers by age.png|449 × 520px|center]] | |
| − | + | ||
| − | + | 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. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
</font> | </font> | ||
| − | |||
| − | |||
| − | |||
| − | |||
</div> | </div> | ||
Latest revision as of 13:33, 10 April 2018
| HOME | ABOUT US | PROJECT OVERVIEW | EDA | BUSINESS OBJECTIVES | PROJECT MANAGEMENT | DOCUMENTATION | MAIN PAGE |
| Facebook Post | Facebook Video | Youtube | 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:
- Video
- Geography
- Date
- Subscription Status
- Youtube Product
- Device Type
- Subtitles and CC
- 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:
- Viewer Age
- 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.
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.
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.
All of the above findings are consistent with that of Facebook Videos.
