Q#21: Volume weighted price average (VWAP)

Suppose you’re given the following table, showing open and close prices as well as…

Q#36: Assigning grades

You are given a dataframe (called df) of students, and you need to assign grades to each student. The table schema is…

Q#19: Calculating monthly sales growth in SQL

Given the table below, called ‘sales’, can you write a SQL query to show the…

Q#44: Calculating a moving average — using python

Q#35: Christmas M&Ms

Suppose you have two different bags of M&Ms, one is a special Christmas edition while the other is a standard bag of M&Ms…

Q#17: Relationship between Fitness and Smoking

Given the data table below, use Chi-Square to determine if there is a…

Q#16: Pricing a coin flip

Suppose a casino has created a new game, determined via coin toss. If the coin is tails, the individual is paid…

Q#20: The carshare dilemma

Suppose we have selected a group of people to take a survey. 35% of the group like Uber, 20% like both Lyft and…

#Q26: Biased coin toss

Suppose you want to generate a sample of heads and tails from a fair coin. However, you only have a biased coin available (meaning the probability of coming up with heads is different than 1/2).

Q#32: Fraudulent Retail Accounts

Below is a daily table for an active acount at Shopify (an online ecommerce, retail platform). The…