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>


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>
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,101,891
Messages
5,483,528
Members
407,397
Latest member
HerbA

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top