##### 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.

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.

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.

What difficulty level is this interview question?

This is a medium difficulty Analytics & Experimentation question, commonly asked during Technical Screen rounds at LinkedIn.

What role is this question designed for?

This question is commonly asked for Data Scientist candidates at LinkedIn during technical interviews.

Test If Initial Video Uploads Are Shorter Than Later Ones

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).

Hypothesis Test: Are Users’ First Video Uploads Shorter?

Context

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

Quick Overview

Hypothesis Test: Are Users’ First Video Uploads Shorter?

Context

Task

Solution

Submit Your Answer to Earn 20XP

Test If Initial Video Uploads Are Shorter Than Later Ones

Quick Overview

Hypothesis Test: Are Users’ First Video Uploads Shorter?

Context

Task

Solution

Submit Your Answer to Earn 20XP