Forecasting & Predicting Data

petewillis99

New Member
Joined
Jan 6, 2018
Messages
1
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

<tbody>
</tbody>
20132014201520162017
Grades +210%0%0%0%0%YearEqual
Grades +145%13%13%25%0%201335,00%
Equal35%87%50%42%69%201487,00%
Grades -10%0%38%33%31%201550,00%
Grades -210%0%0%0%0%201642,00%
201769,00%EquationForecast
201863,50%63,50%
201965,80%40,30%
202068,10%91,67%

<colgroup><col span="22"></colgroup><tbody>
</tbody>
clip_image002.png


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

<attachment></attachment>
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top