Paid
Average order value, written correctly
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Problem Bank
The full shelf, arranged the way a serious practice index should be: filter it, sort it, and work it in any order. Difficulty is shown as Easy, Medium, and Hard. The site’s own tiers map onto those names directly, and the mapping is printed rather than hidden: Starter is Easy, Standard is Medium, Advanced is Hard.
A problem is Solved when a scored Case Room run averages at least 3.5 of 5 across the rubric lines, or when a graded data problem is submitted correctly and recorded. That is the same completion the leaderboard counts. Attempted means a scored run exists below that line, and Untouched means nothing has been recorded yet. Sandbox practice is never recorded, so it never changes a state here.
Create a free account and your state on every problem is tracked here. The leaderboard is opt-in and off by default.
Across all members, the shelf is being worked in the open: every row shows the community solve rate, the share of members with a recorded attempt who solved the problem, counted live from the same recorded work the leaderboard recognizes. A problem nobody has attempted yet shows no rate, because there is no honest rate to show.
Ordered paths through the bank for members who want a sequence instead of a shelf. A set is a suggestion, never a lock: every problem in it can be opened on its own.
The on-ramp. One free case, then the core moves in the order a first month of practice should build them: operations, growth, entry, and defense.
5 problems
Profitability and its other half, cost. Both profitability cases at full depth, then the two cost cases, where the honest answer is usually the cost that does not go away.
4 problems
The number-heavy shelf: a deal, an investment decision, and two pricing cases where the arithmetic is the interview.
4 problems
The opening run of the Data and AI Wing's graded problems, in the order the wing teaches them.
5 problems
Showing 611 of 611 problems. Sign in to see your state on each problem.
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the query return?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $1,510?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $595?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $935?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $930?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $1,400?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $1,195?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $1,250?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula counts the rows with an amount strictly greater than $1,590?
Sign in to trackNo attempts yet
Paid
Data problem
What does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
What does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Estimate total visitors for the full seven-day week.
Sign in to trackNo attempts yet
Paid
Manufacturing
A plant network runs two factories far below capacity and one above it. Rebalance the work and show the savings without breaking delivery promises.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the period's total amount, in dollars.
Sign in to trackNo attempts yet
Paid
Data problem
What does df.groupby("region")["amount"].sum() return?
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from W1 to W6? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from W3 to W4? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Mar to Apr? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Feb to Jun? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Q1 to Q2? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Q2 to Q4? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Q2 to Q4? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Jan to Mar? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Feb to Mar? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Apr to Jun? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Mar to Apr? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Q2 to Q3? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Q1 to Q3? Give a negative number if it fell.
Sign in to trackNo attempts yet
Paid
Data problem
By what percentage did the value change from Q1 to Q2? Give a negative number if it fell.
Sign in to trackNo attempts yet
Free
Restaurants and retail
A regional coffee chain with forty stores has watched profit fall for two years while revenue held steady. Find where the profit went and say what you would do first.
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $690?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $870?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $300?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $710?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $390?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $490?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $380?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $360?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $540?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $790?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $850?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $350?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $570?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows have an amount strictly greater than $740?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the Central region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the North region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the East region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the East region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the West region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the North region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the West region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the Central region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the South region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the North region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the East region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
How many different products appear in the South region's rows?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount of the live rows only, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which statement about this chart is correct?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns total revenue by region, one row per region?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["channel"] == "online"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["channel"] == "online"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["channel"] == "online"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["channel"] == "online"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["channel"] == "online"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["status"] == "paid"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["status"] == "paid"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["status"] == "paid"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["status"] == "paid"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["status"] == "paid"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Paid
Data problem
Which product sits at the top of that result?
Sign in to trackNo attempts yet
Free
Data problem
What is the total value of this order, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the smallest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns how many rows carry an amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the average amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the largest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the largest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the smallest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the average amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns how many rows carry an amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns how many rows carry an amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the average amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the largest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the average amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the smallest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns how many rows carry an amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the average amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the largest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the smallest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the largest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the smallest amount?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from W4 through W6, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from W3 through W6, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Apr through Jun, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Feb through May, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Jan through Jun, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Q1 through Q3, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Q1 through Q3, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Jan through Mar, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Jan through Jun, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Apr through Jun, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Apr through Jun, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Apr through Jun, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Q1 through Q3, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined value from Q1 through Q3, inclusive?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the South region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the Central region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the West region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the South region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the West region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the West region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the West region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the West region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the North region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the West region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for the North region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
By how many percentage points did New line's share of total revenue change from Year 1 to Year 2? Give a negative number if its share fell.
Sign in to trackNo attempts yet
Paid
Data problem
By how many percentage points did Services's share of total revenue change from Year 1 to Year 2? Give a negative number if its share fell.
Sign in to trackNo attempts yet
Paid
Data problem
By how many percentage points did Legacy's share of total revenue change from Year 1 to Year 2? Give a negative number if its share fell.
Sign in to trackNo attempts yet
Paid
Data problem
By how many percentage points did Legacy's share of total revenue change from Year 1 to Year 2? Give a negative number if its share fell.
Sign in to trackNo attempts yet
Paid
Data problem
By how many percentage points did Legacy's share of total revenue change from Year 1 to Year 2? Give a negative number if its share fell.
Sign in to trackNo attempts yet
Paid
Data problem
By how many percentage points did Growth line's share of total revenue change from Year 1 to Year 2? Give a negative number if its share fell.
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the five lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Economy row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Outerwear row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Beans row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Monthly row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Pantry row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Deluxe row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Freight row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Brand row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Starter row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average amount of a Ad tier row, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average price paid per unit, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the overall average order value?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per subscriber, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
Which query lists the customers who have never ordered?
Sign in to trackNo attempts yet
Free
Data problem
By how many percentage points did the gross margin change from Year 1 to Year 2? Give a positive number if the margin rose.
Sign in to trackNo attempts yet
Paid
Data problem
On that index, what is the value for W3?
Sign in to trackNo attempts yet
Paid
Data problem
On that index, what is the value for Mar?
Sign in to trackNo attempts yet
Paid
Data problem
On that index, what is the value for Apr?
Sign in to trackNo attempts yet
Paid
Data problem
On that index, what is the value for Q3?
Sign in to trackNo attempts yet
Paid
Food manufacturing
A packaged food manufacturer faces rising input costs it cannot pass on in full. Find the cost lines worth attacking and protect the ones that hold the brand up.
Sign in to trackNo attempts yet
Paid
Consumer retail
An outdoor goods retailer has flat sales in a growing market. Work out which lever matters most and build a growth plan around it.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in January 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in January 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in February 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in February 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in January 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in April 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in January 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount dated in February 2025, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Premium in the North region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Tops in the West region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Latte in the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Class pack in the North region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Bakery in the North region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Standard in the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Ground in the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Brand in the South region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Starter in the East region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount for Ad tier in the South region, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the South region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the Central region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the West region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the East region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the East region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the East region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the East region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the South region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the North region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
What share of the table's total amount comes from the East region? Give the answer as a percentage.
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After applying that rule, what is the total amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does pd.merge(customers, orders, on="customer_id") return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Consumer health devices
A fitness device maker has a new band that tracks sleep in detail. Plan the launch: first buyers, channel, price, and the number that decides success in year one.
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What value does that summary cell display, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the frame have after that call?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the frame have after that call?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the frame have after that call?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the frame have after that call?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the frame have after that call?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the frame have after that call?
Sign in to trackNo attempts yet
Paid
Airlines
A low cost entrant just started flying your client's three most profitable routes. Decide what to defend, what to give up, and what it costs either way.
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["plan"] == "pro"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["plan"] == "pro"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["plan"] == "pro"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What does df[df["plan"] == "pro"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the average of the amounts present, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest change between two consecutive periods, in the series' units? Give a negative number if the largest move is a fall.
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest change between two consecutive periods, in the series' units? Give a negative number if the largest move is a fall.
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest change between two consecutive periods, in the series' units? Give a negative number if the largest move is a fall.
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest change between two consecutive periods, in the series' units? Give a negative number if the largest move is a fall.
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest change between two consecutive periods, in the series' units? Give a negative number if the largest move is a fall.
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest change between two consecutive periods, in the series' units? Give a negative number if the largest move is a fall.
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the blended monthly revenue per customer, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the West and East region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the West and North region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the East and West region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the Central and East region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the South and West region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the West and North region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the South and Central region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
By how many dollars does the larger of the East and West region totals exceed the smaller?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns exactly that?
Sign in to trackNo attempts yet
Paid
Data problem
How many visitors reach the final step, pay? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many visitors reach the final step, pay? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many visitors reach the final step, pay? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many applicants reach the final step, offer? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many applicants reach the final step, offer? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many applicants reach the final step, offer? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many visitors reach the final step, activate? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many visitors reach the final step, activate? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many visitors reach the final step, activate? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many trials reach the final step, convert? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many trials reach the final step, convert? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
How many trials reach the final step, convert? Round to the nearest whole number in your working; the count itself need not be whole at each step.
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Whose row sits first after that sort?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the West region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the North region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the South region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the East region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the South region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the East region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the West region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the North region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the North region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the West region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the South region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the East region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the South region?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the total amount for the West region?
Sign in to trackNo attempts yet
Paid
Energy and transport
A maker of electric vehicle charging hardware sells to workplaces. It is deciding whether to enter the highway corridor market. Size the opportunity and make the call.
Sign in to trackNo attempts yet
Paid
Data problem
Which statement about this exhibit is both true and the strongest reading of it?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Data problem
What does the count come to?
Sign in to trackNo attempts yet
Paid
Energy and transport
A charging network has budget for one serious launch across three candidate metros. Pick the metro and the build model, and prove both choices with per station economics.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the five steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the steps into the working pipeline, first step to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Data problem
Arrange the lines into the working query, first line to last.
Sign in to trackNo attempts yet
Paid
Logistics
A regional freight carrier can buy a smaller rival whose routes overlap its own. Value the overlap honestly and decide whether the deal earns its price.
Sign in to trackNo attempts yet
Paid
Consumer brands
A direct to consumer personal care brand grew site traffic by half last year while revenue barely moved, and growth has now stalled. Find where the model broke and rebuild the plan around the failing numbers.
Sign in to trackNo attempts yet
Paid
Data problem
After that treatment, what is the average amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After that treatment, what is the average amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After that treatment, what is the average amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After that treatment, what is the average amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After that treatment, what is the average amount, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
After that treatment, what is the average amount, in dollars?
Sign in to trackNo attempts yet
Paid
Healthcare services
An investor is weighing a chain of outpatient clinics. Build the case for and against, and name the diligence question that matters more than the rest.
Sign in to trackNo attempts yet
Paid
Airlines
A mid size airline grew revenue last year and still landed at zero operating profit. Find where the profit went, judge the new routes the finance team wants to cut, and set the order of your fixes.
Sign in to trackNo attempts yet
Paid
Business software
A business software company lists one price and collects another, after years of discounting. Restructure the tiers and the discounting together, and show what the new model is worth after the churn it causes.
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers LEFT JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers LEFT JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers LEFT JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers LEFT JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers LEFT JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers LEFT JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does SELECT * FROM customers LEFT JOIN orders ON orders.customer_id = customers.id return?
Sign in to trackNo attempts yet
Paid
Data problem
Which query returns one row per customer with that customer's most recent order?
Sign in to trackNo attempts yet
Paid
Data problem
Estimate the quarter's total revenue, in dollars.
Sign in to trackNo attempts yet
Paid
Manufacturing
A castings maker runs four plants at very different costs per unit. Decide whether closing the smallest plant and moving its volume pays, and cost the closure honestly, including the costs that do not go away.
Sign in to trackNo attempts yet
Paid
Subscription software
A subscription software company prices one tier for every customer. Decide whether a second tier helps or hurts, and set the price gap between them.
Sign in to trackNo attempts yet
Paid
Data problem
How many months of margin does it take to pay back the cost of acquiring one customer?
Sign in to trackNo attempts yet
Paid
Data problem
How many months of margin does it take to pay back the cost of acquiring one customer?
Sign in to trackNo attempts yet
Paid
Data problem
How many months of margin does it take to pay back the cost of acquiring one customer?
Sign in to trackNo attempts yet
Paid
Data problem
How many months of margin does it take to pay back the cost of acquiring one customer?
Sign in to trackNo attempts yet
Paid
Data problem
How many months of margin does it take to pay back the cost of acquiring one customer?
Sign in to trackNo attempts yet
Paid
Data problem
How many months of margin does it take to pay back the cost of acquiring one customer?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
What is the total variance, actual minus budget, in dollars? Give a negative number if the quarter came in under budget.
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
Which result does the expression return?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
How many rows does the merged frame have?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Tops?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Filters?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Travel?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Apparel?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Latte?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Add-on?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Currency?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Breakfast?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Freight?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Generics?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Refill?
Sign in to trackNo attempts yet
Paid
Data problem
Which formula returns the price each of Standard?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Paid
Data problem
In which period did the series actually reach its highest value?
Sign in to trackNo attempts yet
Free
Data problem
What does df[df["status"] == "paid"]["amount"].sum() return, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which statement reads this exhibit correctly?
Sign in to trackNo attempts yet
Paid
Data problem
Taking the latest dated row per customer as current, what is the total of the current amounts, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Taking the latest dated row per customer as current, what is the total of the current amounts, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Taking the latest dated row per customer as current, what is the total of the current amounts, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Taking the latest dated row per customer as current, what is the total of the current amounts, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Taking the latest dated row per customer as current, what is the total of the current amounts, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Taking the latest dated row per customer as current, what is the total of the current amounts, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest percentage increase between two consecutive periods?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the largest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Economy rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Accessories rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Stationery rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Pastry rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Monthly rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Pantry rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Deluxe rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Ground rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Generics rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Sides rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Scale rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the median amount among the Standard rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the smallest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the smallest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the smallest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the smallest value in the query's result, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest East rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest North rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest East rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest North rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest East rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest East rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest North rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest East rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest North rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest West rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest South rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the combined amount of the three largest North rows, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What is the total amount, expressed in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What revenue has each acquired user generated on average across months 0 through 3, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What total revenue does the cohort generate across months 0 through 3, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What total revenue does the cohort generate across months 0 through 3, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What total revenue does the cohort generate across months 0 through 3, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What total revenue does the cohort generate across months 0 through 3, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What total revenue does the cohort generate across months 0 through 3, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
What total revenue does the cohort generate across months 0 through 3, in dollars?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which segment contributed the most to the change in total revenue?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
Paid
Data problem
Which option names the region the report keeps, if it keeps exactly one, or None of them if it keeps none?
Sign in to trackNo attempts yet
I am Richard, your interviewer here. I run cases with you, drill your math, and tell you plainly which part of your game needs work. Ask me something, or press Hear it and I will introduce myself out loud in your device voice. The studio voice connects at launch.
He answers from the guide's own content, names the level it lives in, and does not invent firm facts. On member accounts he remembers your year, school, progress, and scores; you can see and clear what he remembers.