Hi
I have 24 months of sales data for 50 territories.
I want to forecast data for each territory for the next 12 months.
The sales data can go up and down each month (20% either way) but generally the sales are increasing on all territories.
Please could somebody:
a) In simple terms explain the difference between TREND and LINEST functions
b) Advise as to which function should give the most accurate forecast.
Many thanks for any support
Kev
I have 24 months of sales data for 50 territories.
I want to forecast data for each territory for the next 12 months.
The sales data can go up and down each month (20% either way) but generally the sales are increasing on all territories.
Please could somebody:
a) In simple terms explain the difference between TREND and LINEST functions
b) Advise as to which function should give the most accurate forecast.
Many thanks for any support
Kev