Difference between revisions of "ANLY482 Team wiki: 2015T2 TeamROLL Data Anlysis/Post"

From Analytics Practicum
Jump to navigation Jump to search
Line 47: Line 47:
 
<!--END OF Sub-Navigation-->
 
<!--END OF Sub-Navigation-->
  
Work in progress.
+
==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: Time of day over average post reach </font></div>==
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post1.png|750px|center]] </div>
 +
The bars show the count of posts that were released during specific times of the day, while the line shows the average post reach of all posts released during those timings.<br>
 +
We observe that majority of posts were released in the evening between 6pm-12am. However, the average post reach also declines in the evening. Lunch hours (12pm) has the highest post reach. Going home hours (6pm) also has a relatively high post reach.
 +
 
 +
==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: Top performing posts in Total reach  </font></div>==
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post2.png|750px|center]] </div>
 +
The control chart above shows a detailed breakdown of posts posted at different times of the day. Posts within the red box performed exceptionally well since they are in the top 1% of posts which performed well. These 22 posts are: <br>
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post3.png|750px|center]] </div>
 +
We do not observe any distinct trends in topics among these posts.
 +
 
 +
==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: No. of Negative Feedback Over Likes  </font></div>==
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post4.png|750px|center]] </div>
 +
This scatterplot shows the relationship between the number of likes a post receives, as well the number of unlikes which the same post receives. <br>
 +
In general, we observe a linear trend where posts who received many likes also received a higher number of unlikes. These are positively correlated. Through the use of two control lines marking the top 1% of posts in both likes and unlikes, we segment the plot into four quadrants. The posts highlighted in red belonging to the bottom right quadrant indicates posts who had a high amount of likes, but an exceptionally low number of unlikes.
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post5.png|750px|center]] </div>
 +
Of these five posts, we do not observe any distinct trend in topics.<br>
 +
The posts highlighted in yellow on the scatterplot, belonging to the top left quadrant indicates posts who had a low amount of likes, but an exceptionally high number of unlikes.
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post6.png|750px|center]] </div>
 +
Of these 11 posts, we noticed that 5 posts indicated with a "*" shared a common topic about the Chinese seventh month and of ghosts. Such content may not have been favoured by superstitious Singaporeans, hence their exceptionally high amounts of unlikes.
 +
 
 +
 
 +
==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: Character Design vs No. of Likes    </font></div>==
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post7.png|750px|center]] </div>
 +
In general, Trolls/Memes forme the majority of SGAG's design character in posts. Of the other minor design characters used, "Politicians" and "Foreign Celebrities" appear to be more popular among audiences as well.
 +
 
 +
==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: No. of Frames Design vs No. of Likes    </font></div>==
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post8.png|750px|center]] </div>
 +
Most posts have 1, 2, or 3 frames in their design. Generally, as the number of frames increased, average number of likes decreased as well. Posts with more than 3 frames appear to garner more likes, perhaps because they are richer in information.
 +
 
 +
==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: No. of Description Lines Design vs No. of Likes    </font></div>==
 +
<div style="padding-bottom:25px;"> [[File:teamroll_post9.png|750px|center]] </div>
 +
Many posts tended to have more than three description lines. In general, as the number of description lines increased, so did the average number of likes. However, for posts with more than three description lines, the average number of likes decreased slightly, perhaps because audience found such posts increasingly wordy.

Revision as of 22:16, 18 April 2016

T(eam)ROLL.png

Teamroll home.png   HOME

 

Teamroll.png   ABOUT US

 

Teamroll overview.png   PROJECT OVERVIEW

 

Teamroll this.png   DATA ANALYSIS

 

Teamroll mgmt.png   PROJECT MANAGEMENT

 

Teamroll doc.png   DOCUMENTATION

Data Cleaning Page-Level Analysis Post-Level Analysis


Exploratory Data Analysis: Time of day over average post reach

Teamroll post1.png

The bars show the count of posts that were released during specific times of the day, while the line shows the average post reach of all posts released during those timings.
We observe that majority of posts were released in the evening between 6pm-12am. However, the average post reach also declines in the evening. Lunch hours (12pm) has the highest post reach. Going home hours (6pm) also has a relatively high post reach.

Exploratory Data Analysis: Top performing posts in Total reach

Teamroll post2.png

The control chart above shows a detailed breakdown of posts posted at different times of the day. Posts within the red box performed exceptionally well since they are in the top 1% of posts which performed well. These 22 posts are:

Teamroll post3.png

We do not observe any distinct trends in topics among these posts.

Exploratory Data Analysis: No. of Negative Feedback Over Likes

Teamroll post4.png

This scatterplot shows the relationship between the number of likes a post receives, as well the number of unlikes which the same post receives.
In general, we observe a linear trend where posts who received many likes also received a higher number of unlikes. These are positively correlated. Through the use of two control lines marking the top 1% of posts in both likes and unlikes, we segment the plot into four quadrants. The posts highlighted in red belonging to the bottom right quadrant indicates posts who had a high amount of likes, but an exceptionally low number of unlikes.

Teamroll post5.png

Of these five posts, we do not observe any distinct trend in topics.
The posts highlighted in yellow on the scatterplot, belonging to the top left quadrant indicates posts who had a low amount of likes, but an exceptionally high number of unlikes.

Teamroll post6.png

Of these 11 posts, we noticed that 5 posts indicated with a "*" shared a common topic about the Chinese seventh month and of ghosts. Such content may not have been favoured by superstitious Singaporeans, hence their exceptionally high amounts of unlikes.


Exploratory Data Analysis: Character Design vs No. of Likes

Teamroll post7.png

In general, Trolls/Memes forme the majority of SGAG's design character in posts. Of the other minor design characters used, "Politicians" and "Foreign Celebrities" appear to be more popular among audiences as well.

Exploratory Data Analysis: No. of Frames Design vs No. of Likes

Teamroll post8.png

Most posts have 1, 2, or 3 frames in their design. Generally, as the number of frames increased, average number of likes decreased as well. Posts with more than 3 frames appear to garner more likes, perhaps because they are richer in information.

Exploratory Data Analysis: No. of Description Lines Design vs No. of Likes

Teamroll post9.png

Many posts tended to have more than three description lines. In general, as the number of description lines increased, so did the average number of likes. However, for posts with more than three description lines, the average number of likes decreased slightly, perhaps because audience found such posts increasingly wordy.