Katkat
Back

Test If Initial Video Uploads Are Shorter Than Later Ones

LinkedInData Scientist · Technical Screen
MediumData ScientistTechnical ScreenAnalytics & Experimentation

Last updated

Evaluates hypothesis testing for whether users' first video uploads are shorter than later uploads. Strong answers define a clean data slice, paired user-level metrics, robust tests, and SQL-style implementation.

Scenario

A video-sharing platform wants to know whether users’ first uploaded videos tend to be shorter than their later uploads.

Question

Describe how you would test the hypothesis that users’ initial video posts are shorter. Define the data slice, metrics, statistical test, and provide high-level SQL or pseudo-code for the analysis.

Hints

Compare first-video length vs. subsequent average per user; control for outliers and posting date distribution.