Skip to Content
avatar image
Former Member

How to generate Average and Median Forecast through Macros

Dear APO Gurus,

Could you kindly guide me to create a macro for generating  Average and Median Forecast for next one year by taking the last 3 years Sales history.

The attached file contains an example for your reference of what i am looking for. 

Would really appreciate your immediate help.

Regards

Gopi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 07, 2013 at 05:16 PM

    Gopi

    Maybe you try to use a Statistical Foercasting run (Constant Model) instead ?

    Rishi Menon

    Add comment
    10|10000 characters needed characters exceeded