2024 Olympic Predictions For Track & Field
Using calculate trend lines from previous years to predict the winning results
@kaggle.bonniesindelar_2024_olympic_predictions_for_track_field
Using calculate trend lines from previous years to predict the winning results
@kaggle.bonniesindelar_2024_olympic_predictions_for_track_field
Using data from previous analyses of winning Olympic Track & Field performances in 10 events, I wanted to calculate the predicted winning results for those events at the 2024 Olympics. The events analyzed were the 100 meter, 200 meter, 400 meter, 800 meter, 1500 meter, long jump, high jump, shot put, javelin, and discus throw.
CREATE TABLE field_event_predictions (
"event" VARCHAR,
"eval_dates" VARCHAR,
"start_eval_date" BIGINT,
"end_eval_date" BIGINT,
"years_evaluated" BIGINT,
"trend_line_equation" VARCHAR,
"m" DOUBLE,
"b" DOUBLE,
"n_2024_prediction" DOUBLE -- 2024 Prediction
);CREATE TABLE running_event_predictions (
"event" VARCHAR,
"eval_dates" VARCHAR,
"start_eval_date" BIGINT,
"end_eval_date" BIGINT,
"years_evaluated" BIGINT,
"trend_line_equation" VARCHAR,
"m" DOUBLE,
"b" VARCHAR,
"n_2024_prediction" DOUBLE -- 2024 Prediction,
"mm_ss_format" VARCHAR
);Anyone who has the link will be able to view this.