Answers to Media Streaming Data
Analysis Questions
1. Day with highest total watch duration: Friday
2. Hour with peak engagement (highest average watch duration): 18 (6 PM)
3. Most common subscription plan among active users: Standard
4. Users with higher sessions per week are more likely to be: Inactive (based on average
sessions per week)
5. Relationship between completion rate and user rating: Very weak correlation (approx
0.005)
6. Country with highest average user rating: India
7. Mobile device users are more likely to have an active status, Standard subscription plan,
and average 5.44 sessions per week
8. Most new users started subscriptions in: 2024Q1
9. Percentage of inactive users: 20.46%
10-12. Device type comparison:
- Average watch duration (Tablet highest): ~81.21 min
- Average completion rate (Smart TV highest): ~78.34%
- Average user rating (Smart TV highest): ~3.04
13. Device type delivering highest satisfaction and completion rates: Smart TV
14. Strategies to improve engagement on lowest device type (Mobile):
- Enhance mobile app interface and playback quality
- Personalized content and push notifications
15-16. Subscription type does not significantly influence engagement sessions/week or
completion rate (p > 0.86)
Which subscription plan has the highest number of users in the dataset? Standard
Which region has the highest overall watch duration on average? Europe
What is the most popular content type based on the number of views? Series