Chegg数据相关面经_Chegg数据相关面试真题及高频题

1.Measuring the Impact of Chegg's $5 Off Coupon Launch

2.Excel Formula Challenge: SUMIFS Analysis With Conditions

3.Excel Tool for Dropdown List Creation in Cells.

4.Excel: Interpretation of LOWER(TRIM(LEFT())) Formula

5.Excel Interview Question: Testing Your Knowledge of Cell Properties

6.Gross Margin Calculation for Washing Machine Sales

7.Interpreting the Implication of a Z-Score for Height

8.Selecting the Optimal NosQL Database for Data Collection

9.Assumptions of t-test: What You Should Know.

10.Identifying and Addressing Data Issues for Classification Models

11.Logistic Regression vs. Decision Trees: Similarities, Differences, and Preferences

12.Dashboard Creation with Relational Database Visualization.

13.Do Both Linear and Logistic Regression Require Normal Error Distribution?

14.Z test table for mean calculation using variance?

15.Expected number of consecutive coin tosses landing heads

16.Common SQL Functions for Sorting and Filtering Output

17.Tips and Tricks.

18.Background, Excel Functions, SQL

19.Mathematics, Statistics, and Programming.

20.Title: Exploring Multidimensional Array T-Test Hypothesis

21.Understanding the Foundation.

22.SQL: Understanding Right Join and Left Join Differences

23.Understanding Sumif and Vlookup

24.Common Data Analysis Techniques and Functions

1. Measuring the Impact of Chegg's $5 Off Coupon Launch

If Chegg would like to offer $5 off to students for their first subscription, how would you measure the impact of this coupon launch?"

2. Excel Formula Challenge: SUMIFS Analysis With Conditions

Using the Excel table below, what value would the formula =SUMIFS(A1:A5, B1:B5, ">0", C1:C5, "NJ") return?

3. Excel Tool for Dropdown List Creation in Cells.

In Microsoft Excel, which tool allows you to make a dropdown list in a cel. thereby allowing the cell to take certain pre-defined yalues?

4. Excel: Interpretation of LOWER(TRIM(LEFT())) Formula

In Microsoft Excel, what would the formula =LOWER(TRiM(LEFT("Helc World",6))) return?

5. Excel Interview Question: Testing Your Knowledge of Cell Properties

In Microsoft Excel... Cell A1 contains the text "sales" Cell A2 contains the number 0 Which of the following statements is true?