Test If Initial Video Uploads Are Shorter Than Later Ones

Q: Test If Initial Video Uploads Are Shorter Than Later Ones

This question evaluates a candidate's competency in hypothesis testing, statistical inference, and event-level data preparation for analyzing differences between users' initial and subsequent video uploads.

Q: How do I approach Analytics & Experimentation interview questions?

Analytics & Experimentation questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master analytics & experimentation interviews.

Question

Hypothesis Test: Are Users’ First Video Uploads Shorter?

Context

You are given event-level data for a video-sharing product. Each record represents a published video with its duration and uploader. We want to determine whether a user's first uploaded video tends to be shorter than their subsequent uploads.

Assume you have a table like:

video_uploads(user_id, video_id, upload_ts, duration_sec, status, visibility, category, source)

Task

Describe how you would test the hypothesis that users’ initial video posts are shorter than their later uploads.

Specify:

Data slice (inclusion/exclusion criteria)
Metrics and aggregation
Statistical test(s) and assumptions
High-level SQL or pseudo-code to implement the analysis

Hints:

Compare first-video length vs. subsequent average per user.
Control for outliers and posting-date distribution (e.g., cohort effects or time trends).

Test If Initial Video Uploads Are Shorter Than Later Ones

Hypothesis Test: Are Users’ First Video Uploads Shorter?

Context

Task

Solution

Comments (0)