Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Regression Trend Test for Compensation

MediumStatistics & Probability00:00
I
Practice interviewer
Your interviewer
In session
I
Interviewer

Welcome to your interview.

The question is on your right: Regression Trend Test for Compensation. Take a moment with it first.

Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.

You need to log in / sign up to chat or submit.

Problem

Business Context

Meta HR Analytics wants to determine whether employee compensation growth changed after a compensation policy update introduced in July 2023. You are given monthly median total compensation for a stable cohort of software engineers so the goal is to test whether the time trend changed, not to compare different employee mixes.

Problem Statement

Use a time-trend regression with a policy-change indicator and an interaction term to evaluate whether compensation trends changed after the policy update.

Given Data

Monthly median total compensation is shown below in thousands of dollars.

Month Index tttPeriodPost-Policy Indicator DtD_tDt​Median Compensation ($K)
1Jan 20230180.0
2Feb 20230180.4
3Mar 20230180.9
4Apr 20230181.1
5May 20230181.5
6Jun 20230181.8
7Jul 20231183.0
8Aug 20231183.6
9Sep 20231184.1
10Oct 20231184.7
11Nov 20231185.1
12Dec 20231185.8
Assume the following segmented regression model:

Yt=β0+β1t+β2Dt+β3(t×Dt)+εtY_t = \beta_0 + \beta_1 t + \beta_2 D_t + \beta_3 (t \times D_t) + \varepsilon_tYt​=β0​+β1​t+β2​Dt​+β3​(t×Dt​)+εt​

You are also given the fitted coefficient estimates and standard errors from OLS:

CoefficientEstimateStandard Error
β0\beta_0β0​179.550.18
β1\beta_1β1​0.350.04
β2\beta_2β2​0.820.29
β3\beta_3β3​0.150.05

Use a two-sided test with α=0.05\alpha = 0.05α=0.05. For the small sample, use a critical value of t0.975,8=2.306t_{0.975,8} = 2.306t0.975,8​=2.306.

Requirements

  1. State the null and alternative hypotheses for whether the compensation trend changed after the policy update.
  2. Interpret β1\beta_1β1​, β2\beta_2β2​, and β3\beta_3β3​ in business terms.
  3. Test whether the post-policy slope change is statistically significant.
  4. Construct a 95% confidence interval for the slope change β3\beta_3β3​.
  5. Compute the pre-policy monthly trend and post-policy monthly trend.
  6. Conclude whether compensation trends meaningfully changed over time.

Assumptions

  • The cohort composition is stable across months.
  • The linear trend is a reasonable approximation within this 12-month window.
  • Residuals are independent with constant variance; ignore autocorrelation for this exercise.