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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

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