# excel file
mydata <- read_excel("mydata.xlsx")
How many frog records were collected in each Australian state or province?
ggplot(mydata, aes(y = stateProvince)) +
geom_bar()
Based on the data, New South Wales has the highest number of frog records by a significant amount. Most of the sightings are concentrated in the eastern states (New South Wales, Queensland, and Victoria), while the Northern Territory and Other Territories have the fewest records.