Prepare for and practice interview questions from Cash App across topics like Analytics, Python, Algorithms and more.

Cash App Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Cash App Interview Guides

<p>You’re given two tables, <em>payments</em> and <em>users</em>. The payments table holds all payments between users with the <code>payment_state</code> column consisting of either <code>&#34;success&#34;</code> or <code>&#34;failed&#34;</code>. </p>

<p>How many customers that signed up in January 2020 had a combined (successful) sending and receiving volume greater than $100 in their first 30 days?</p>

<p><em>Note: The <code>sender_id</code> and <code>recipient_id</code> both represent the <code>user_id</code>.</em></p>

<p><code>payments</code> table</p>

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

<tbody>
<tr>
<td><code>payment_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>sender_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>recipient_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>payment_state</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>amount_cents</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Payments Received

<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
Payments Received	SQL	Hard	Very High
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High