Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi everyone!
A solution to last week’s challenge can be found here.
In this weekly challenge, you will find a dataset containing the New York Times articles from January 1, 2020 to December 31, 2020.
Your first task is to identify which day of the week has the highest number of sports articles published.
Your second task is to identify how many times the word "Football" or "football" is in the headline or keywords on the day of the week that has the highest number of sports articles published.
As a final result, you have to write a statement similar to this: The word football appears ____ times in sports articles published on _____.
BONUS!
Forecast in what future month articles will surpass the 20 million comments milestone using the high end of the 70% confidence interval. (HINT: Consider a cumulative sum for all posts since 2020)
For the bonus, you will need to Download and Install Predictive tools [https://help.alteryx.com/20213/designer/download-and-use-predictive-tools]. Also, don’t worry if your output it’s slightly different from the output here. What is important is to understand the results.
Good luck!!
Lots of Monday morning quarterbacks in the news!
Task 1 and 2 below, bonus perhaps to follow...
Tasks 1 & 2 without predictions