Q#21: Volume weighted price average (VWAP)

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

Q#13: Students in a class

In a class of 120 students numbered 1 to 120, all even numbered students opt for Physics, those whose numbers are…

Q#1: Second price (Vickrey) auction

Suppose you’re running a second-price auction. In this auction, the highest bidder will win, but…

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#8: Drop rows in dataframe that are between two dates

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#4: First or Third Class Mailers?

Suppose you’re trying to optimize a mailing campaign where physical mail is sent to potential…

Q#17: Relationship between Fitness and Smoking

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