This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackHi 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