View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ashley B Ashley B is offline
external usenet poster
 
Posts: 1
Default Multiple Regression in Analysis Tool Pack - Confidence Intervals

How do I calculate the confidence interval for each year's forecast with the
output Excel gives me regarding the confidence intervals? I ran a multiple
regression in Excel using the Analysis Tool Pack and I can see the upper and
lower limits, but I do not know how to use those numbers to calculate the
interval for each forecasted period.