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.)
You are being taken to the material on
another site. This will open a new window.
Rate this Material
You just viewedPredInt.xls.
Please take a moment to rate this material.
Search by ISBN?
It looks like you have entered an ISBN number. Would you like to search using what you have
entered as an ISBN number?
Searching for Members?
You entered an email address. Would you like to search for members? Click Yes to continue. If no, materials will be displayed first. You can refine your search with the options on the left of the results page.