Data Analytics and Visualisation: Australian School Profile Report

This report presents an analysis of Australian school data from 2018, employing both basic and advanced statistical techniques using R programming. The analysis is divided into two parts. Part A focuses on comparing school profiles across different states, utilizing summary statistics and bar charts to address research questions related to staffing, student enrollment (gender-wise), and the proportion of non-English speaking students. Part B delves into k-means clustering to segment schools in New South Wales (NSW) based on numeric variables, aiming to categorize schools according to campus type, year ranges, and geographical location. The report includes detailed outputs of statistical analyses, bar charts for data visualization, and cluster plots to evaluate the effectiveness of the clustering. The findings reveal significant variations in school profiles across states, with NSW, QLD, and VIC exhibiting higher staff and enrollment numbers. The clustering results indicate that school profiles are significantly correlated with geographical locations but not with campus type or year levels. The report concludes with recommendations for school authorities and government bodies to improve education quality and attract more students.