1. How would you decrease the chance of a false positive (type 1 error) in a hypothesis testing framework?

2. All ids appear in table_2. But table_1 has missing ids. Write a SQL query to find all missing ids.

3. Using only table1 find all missing ids. Assuming ids are a complete sequence from 10001:11000 and no repeating ids.

Question

1. How would you decrease the chance of a false positive (type 1 error) in a hypothesis testing framework?

2. All ids appear in table_2. But table_1 has missing ids. Write a SQL query to find all missing ids. 

3. Using only table1 find all missing ids. Assuming ids are a complete sequence from 10001:11000 and no repeating ids.

Anonymous · Accepted Answer

1. Collect more data decreases sampling error and increases the power of a test. Increase the significance level

2. Left join then filter out the nulls 

3. Pseudo code: Sort ids. Create a lag, subtract the ids. Find ids with a difference is greater than 1. Fill in the gaps for these ids.

Coupang

Coupang Interview Question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches