forecast monthly change of inflation rate

Zonki

New Member
Joined
Jan 31, 2017
Messages
2
Hi :)

I am working on a project to forecast monthly change of inflation rate. I used SLR but the forecast doesnt seem to be correct. Could someone take a look please? :confused:

I am also not sure how to diagnose
time series (stationarity, trend, ARMA..) in Excel( is this even possible?)

I hope someone can help.
Thanks!
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,997
are you using previous monthly rates or looking at events liable to affect inflation ?
 

Zonki

New Member
Joined
Jan 31, 2017
Messages
2
I want to make two analyses - first based on previous rates / second based on events
For SLR i used previous rates, the second I dont know how to approach:confused: any advice? :(
 

Watch MrExcel Video

Forum statistics

Threads
1,101,941
Messages
5,483,817
Members
407,415
Latest member
Anton1999

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