Maven Analytics Challange Halloween 2024
Minimizing Tricks, Maximizing treats
With inflation being the scariest thing this spooky season, households are looking to maximize the popularity of their house on Halloween while cutting cost where ever possible. In order to achieve these goals, we can control internet survey results for price to find the candies that provide the most value for the price.
In order accurately control for price, we need to convert the percentile rank of the price of each candy into a term that can equally adjust the head-to-head performance, as measured in win percentage, for a better comparison.
We can derive an adjustment value that equally weights the win percentage by subtracting the price percentile by the average percentile (~.50). This function give us each candies distance from the average price as expressed by a number in-between -1 and +1.