I have a language school with 10 centres. We have data by level from the last five years. The average student is with us for 10 years, from age of 7 to 17.
We are suffering a drop off of intake in students at early ages ( though total students are holding their own) and I need some graphs to show how each centre might look over next 5 years if current trends continue. I attach a sample of the data we have 2013 and 2014. The previous 4 years are easily available.