Weekly Challenges

AYXAcademy

Hi Community members,

A solution to last week’s challenge can be found here.

This challenge was submitted by Griffin Welsh, @griffinwelsh. Thank you, Griffin, for your submission, and for making our Halloween even more fun!

Halloween is just around the corner, and you have been tasked with creating the scariest possible haunted house for your accounting department. You have received survey results showing each employee’s fear and corresponding fear intensity.

However, not everyone filled out the survey correctly.

Your goal is to determine the scariest haunted house feature, measured by the total sum of fear intensity from all respondents. For respondents who listed a fear but did not provide an intensity, use the median intensity from other respondents who reported the same fear. Ignore any respondents who did not list a fear in their response.

Bonus Task

Was the first challenge not scary enough for you? You have now been given a budget of $1,700 to build your haunted house. Your goal is to find the combination of features that maximizes the total fear intensity while staying within budget. Each feature can only be used once.

Using your results, create a short proposal paragraph describing your recommendations based on the data.

Once you’ve completed the challenge, include your solution file and a screenshot of your workflow as attachments to your comment.