Data Analysis Report: Australian Road Crash Trends (1989-2019)

This report presents an analysis of Australian road crash data from 1989 to 2019, focusing on the relationship between age, gender, speed limits, and crash occurrences. The analysis includes exploratory data analysis (EDA) with one and two-variable analysis to identify trends. The methodology includes data setup using Excel and R, incorporating data cleaning to handle missing values. Advanced analysis techniques such as k-means clustering are used to group variables, and linear regression is applied to model the relationship between speed limit and age. The findings reveal insights into the distribution of age and speed limits, the association between road users and gender, and the linear correlation between age and speed limit. The report concludes with reflections on the methods and scope for further research, such as calculating the probability of different types of crashes across individual's age, gender and other independent variables.