Material Detail



Regression analysis can be used to make forecasts. Prediction intervals put confidence intervals around a forecast. Microsoft Excel's statistical tool pack does not do this. I wrote a macro in Visual Basic to do multiple regression with interactive prediction intervals, meaning that the intervals are automatically recalculated whenever you change the value of a predictor (independent) variable, or the confidence level. The macro also produces scatter plots and a normal probability plot. (Excel's normal probability plot is incorrect.)


  • Editor Reviews
  • User Rating
  • Comments
  • Learning Exercises
  • Bookmark Collections (4) Bookmark Collections
  • Course ePortfolios
  • Accessibility Info

More about this material


Log in to participate in the discussions or sign up if you are not already a MERLOT member.