Wayfair数据相关面经_Wayfair数据相关面试真题及高频题

1.Measure the strategy of pricing

2.Decrease of conversion rate

3.Distribution Type Identification

4.Graph Interpretation for Best Classification

5.Fitting Function Calculation

6.Determining Next Steps After Implementing a Pricing Strategy

7.Quantifying the Impact of a Pricing Change

8.Evaluating the Success of a Pricing Strategy

9.MySQL Query to Match Train Departures with Passenger Arrivals

10.MySQL Query Using LEFT JOIN to Calculate Test Pass Rate and Score

11.MySQL Query to Select Condition-Satisfying IDs

12.Python Sum of Two-Digit Numbers

13.SQL Aggregation Query

14.Calculate Total Imports and Exports by Country

15.Calculate Total Import and Export Amounts by Country

16.Group By Company SQL Query

17.Python Programming for Number Printing

18.SQL Query with LEFT JOIN and IFNULL

19.Ice Cream Dataset Analysis

20.SQL Ranking Query

21.Ice Cream Dataset Insights and Recommendations

22.Shipping Time Reduction Analysis

23.SQL Window Function Application

24.Ice Cream Case Analysis

25.Python Array Rearrangement

26.SQL Question

27.AB Testing Case Analysis

28.Debugging Python Code

29.SQL Ranking by Partition

30.Coffee Maker Pricing and Policy Case

31.Logistics Pricing Analysis Case

32.Google Bid Problem Case Study

33.Linear Model for Predicting House Prices

34.Take-Home Presentation on Channel Analysis

35.Case Study on Assignment and Scheduling

36.Shipping Cost Estimation Case

37.Product Matching Case Study

38.Forecasting Monthly Sales from Daily Sales Data

39.Design an Autocomplete System

40.Calculate Total Weight of Goods on a Truck

41.SQL Query for Employee Count and Total Salary by Department

42.Sort Roman Numerals

43.Convert Date Format

44.Project Deep Dive

45.Problem Analysis and Simple Calculations

46.Data Analysis and Conclusion with Google Sheets

47.SQL Problem Solving

48.SQL and Pandas Assessment

49.Name Sorting with Roman Numerals

50.Date Format Conversion

1. Measure the strategy of pricing

关于wayfair针对coffee maker的定价做出了一个决策，让你分析决策的好坏。数据包括决
策执行前半年和之后四个月的cost、sales、visit数据。另外还提供了coffee flter和toast ovens
的数据，但它们是没有定价调整的，可用来做对比

2. Decrease of conversion rate

| 关于conversion rate，问你关于一些怎么利用conversion rate 去判断新的period 哪里出
错了导致conversion rate下降，并问解决方案

3. Distribution Type Identification

What type of distribution do the anderson-darling and chi-square tests belong to?

4. Graph Interpretation for Best Classification

Given four graphs, each displaying a fitting line and scattered data points, which graph best reflects the classification?

5. Fitting Function Calculation

Given a fitting function y=ax+b, with the value of a known, how can you always determine the value of b? (Options include using the point (0,0), substituting one of the data points, or calculating with the mean of the data.)