Dear All,

First of all sorry if this has been answered somewhere else also I am a newbie so sorry if I'm wasting your time.

I'm currently analysing data for my School. I have two questions:


Art
2013 2014 2015 2016 2017
Grades +2 10% 0% 0% 0% 0% Year Equal
Grades +1 45% 13% 13% 25% 0% 2013 35,00%
Equal 35% 87% 50% 42% 69% 2014 87,00%
Grades -1 0% 0% 38% 33% 31% 2015 50,00%
Grades -2 10% 0% 0% 0% 0% 2016 42,00%
2017 69,00% Equation Forecast
2018 63,50% 63,50%
2019 65,80% 40,30%
2020 68,10% 91,67%


1) Is is possible to use forecasting formula on more than one set of data but view it all in one graph (whether that is as a number or %).




2) Am I ok using Forecast Formula, or should I look for a non linear forecasting / predictions formula. If so which one?

Thank you in advance for any help & advice given.

Pete