We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #296: Breaking News - Headlines and Keywords

SylviaP
Moderator
Moderator

Weekly Challenge Image 296.pngHi 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!!

Sylvia
Aaron_Harter
11 - Bolide

Lots of Monday morning quarterbacks in the news!

Spoiler
0.PNG
patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1638198092002.png

 

PhilipMannering
15 - Aurora
15 - Aurora

Task 1 and 2 below,

 

Spoiler
PhilipMannering_0-1638198528423.png

 

alexnajm
8 - Asteroid

Task 1 and 2 below, bonus perhaps to follow...

challenge_296_start_file_Alex Abi-Najm.PNG

 

Spoiler
Mine takes into account if the data updates and the "most published day" changes! 

 

 

binuacs
12 - Quasar
Spoiler
binuacs_0-1638200458690.png

 

AkimasaKajitani
15 - Aurora

My solution.

 

I completed the Bonus challenge, but the value is a little different.

 

Spoiler
AkimasaKajitani_2-1638201733680.png

 


 

AkimasaKajitani_1-1638201563577.png

 

 

 

rafaaelgeo
6 - Meteoroid
Spoiler
rafaaelgeo_0-1638201976828.png

 

Spalders
8 - Asteroid

Tasks 1 & 2 without predictions

Spoiler
Spalders_0-1638202425085.png

 

Tony_Castillo
8 - Asteroid

Did not do the Bonus

 

Spoiler
Tony_Castillo_0-1638206295990.png