How to calculate percentage change applicants by school year over year?
I'm working on a project examining the number of applicants to highly selective universities in the United States from 2011-2022. I'd like to calculate the year-over-year percentage change of the total number of applicants by school. I have tried to work with "group by" and also create a lag variable, but I can't quite figure it out. Help -- any ideas on how to do this? Thanks!