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

Realtor.com Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Realtor.com Interview Guides

<p>A marketing company is conducting a survey on household incomes in various cities. Now they’re asking for your help with analytics.
Write a SQL query to compute the median household income for each city.</p>

<p><em>Note: Assume that the median is the middle value in an odd set of numbers, and the average of the two middle numbers in an even set.</em></p>

<h3><strong>Example:</strong></h3>

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

<p><code>survey_responses</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>city</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>household_income</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>city</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>median_income</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Write a SQL query to compute the median household income for each city

Median Household Income

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

Question	Topic	Difficulty	Ask Chance
Median Household Income	SQL	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	High
Boarding Times Bias	Statistics	Medium	Medium

Realtor.com Interview Questions

Realtor.com Interview Guides

Realtor.com Interview Questions

Realtor.com Salaries by Position