Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #132: When Will Community Hit 1,000,000 Posts?

Dibas98
8 - Asteroid

Solution

JarekSkudrzyk
11 - Bolide

my solution below

Erin
10 - Fireball

Solution attached.

lynnesonneyrsm
8 - Asteroid

any one else studying for the expert exam?

dyamaguchi
8 - Asteroid
Spoiler
Snipaste_2024-05-08_23-13-00.png

Rhys_Cooper
8 - Asteroid

Great practice for using the ARIMA tools in the context of problem solving

 

Spoiler
Screenshot 2024-05-30 200310.png
Szymon_Czuszek
8 - Asteroid
Spoiler
WeeklyChallenge132.PNG
JoachimCaronTIL
8 - Asteroid

Here is my solution

 

Spoiler
Challenge 132 JC.png

Smatthias
7 - Meteor

I did a bit of renaming, somehow I can't work if the Fields are named F1 or F2, I need them to say month or sum.

 

Spoiler
First thing, crop the first row so I can do the prognosis, the formula is just to change the 9,10,12 e.c. into an actual month, did so by making it a string and then TimeParsing it and cropping the year and the day with time parse. 
running average sum until you get the solution. 
My prediction thing was set to 36 initially but then I just typed in 200, so I could be sure to get the right amount of forecasts. 
Answer is in pic below

Challenge132.jpg
SJKIM
8 - Asteroid

Done