TREND v FORECAST

[inked]

I need to calculate a number based on two criteria. For example: revenue at 2:00 am last Sunday and revenue at 2:00 am the Sunday before. Based on those two criteria, what will the predicted revenue be this Sunday at 2:00 am. Should I simply add the two together and divide by two, or should I introduce a TREND and/or FORECAST function?

D32 = 2:00 am; E32 = revenue Sunday two weeks ago; H32 = revenue last Sunday.

Thanks.

ep

[Jacob Hilderbrand]

If you just divide the sum by 2 you will get the average, but that will not show you the actual trend.

For example.

Sunday 1: 10
Sunday 2: 20

Now the average is 15, but the trend is 30, because the numbers increased by 10.

So it depends on what you want to see, If you want to look at theoretical future earnings, use Trend or Forecast.