Import data

# excel file
mydata <- read_excel("mydata.xlsx")

State one question

How many frog records were collected in each Australian state or province?

Plot data

ggplot(mydata, aes(y = stateProvince)) +
  geom_bar()

Interpret

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.