Apple数据分析面试真题

职位分类
全部
数据科学
数据分析
计算机科学
人工智能
产品经理
BQ
面试题
全部(1)
Coding(0)
SQL(1)
Stats(0)
ML basics(0)
Product Case(0)
高频题(0)
全部(1)
Coding(0)
SQL(1)
Stats(0)
ML basics(0)
Product Case(0)
高频题(0)
1.Basic SQL questions
1. Basic SQL questions
 | 两张表:表1 search (search_id,ab_testing_group 0或1), 
 表2 results (search_id,result_id,domain and is_shown)
 1.Sanity check,如何证明AB组sample size类似,用什么test,怎么算
 2. Some join and basic filtering
 3.For each search,identify whether it has at least one results shown
 4. Calculate the result shown rate by ab bucket
 5. Find the top 3 domain (ordered by shown rate) in each ab_bucket
 6.SQL里面rank和dense rank的区别