1

I've ben sent a forecast of sales from a consultancy. It uses Excel's LINEST function, taking 4 factors that seem to have affected sales in the past, and used them to make a prediction.

How do I go about adding error bars to this prediction? I believe LINEST provides a standard error, but using that would give me constant error bars, and surely the error would increase the further inot the future we go?

(Please note, I am not a statistician, so be gentle!)

Thanks!

Dazed and Confused
  • 11
  • 1
  • If you find the duplicate does not have enough detail, check out other similar questions by searching on [regression prediction limit](http://stats.stackexchange.com/search?tab=relevance&q=prediction%20limit%20regression). – whuber Apr 22 '13 at 16:31

0 Answers0