Prepare for and practice interview questions from Nike across topics like Algorithms, SQL, Python and more.

Nike Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Nike Interview Guides

<p>As a data analyst in a fitness app company, you are tasked with analyzing the user’s daily step count.</p>

<p>Write a SQL query to calculate the 3-day rolling average of steps for each user, rounded to the nearest whole number.</p>

<p><strong><em>Notes:</em></strong> <em>The rolling average should only be calculated for days where there are 3 previous days of step counts, including the current day. The first 2 days for any user should be excluded.</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>daily_steps</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>steps</td>
<td>INTEGER</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>

<tr>
<td>avg_steps</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Calculate the 3-day rolling average of steps for each user.

Rolling Average Steps

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Nike Interview Questions

Nike Interview Guides

Nike Interview Questions

Nike Salaries by Position