Here are the graphs used to tally the top 5 videos based on category:

Conclusion

In the experiment conducted, the group watched several videos in YouTube. The task is to watch the featured videos for a certain period of time for a total of 6 hours. At first, the group members watched a couple of videos for about an hour last July 15. Afterwards, the group members watched some more videos individually in their own homes. Each group member is tasked to take some information of the videos he/she watched. The information the group has gathered were the title, author, number of views, duration, category, country, language, and the age of the author. After the data has been gathered, all data were compiled with Microsoft Excel for summary and tallying. With the help of Microsoft Excel, the group was able to identify that the average views of the videos they watched was around 180,161 and the average duration of the videos is 2:58 the average videos of the uploaders is 26, and the most popular category is entertainment. With this, the group was able to discover that even if the length of the video is as short as 3 minutes as long as it is for entertainment, thousands of people will be interested in

watching it.

Link for the Excel file:

http://rapidshare.com/files/407647625/soccomp_youtube.xlsx