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>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

<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?

Question	Topic	Difficulty	Ask Chance
Rolling Average Steps	SQL	Medium	Very High
Boarding Times Bias	Statistics	Medium	Low
Hundreds of Hypotheses	Statistics	Medium	Low

Nike Interview Questions

Nike Interview Guides

Nike Interview Questions

Nike Salaries by Position