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.)
to participate in the discussions or
if you are not already a MERLOT member.
This will delete the comment from the database. This
operation is not reversible. Are you sure you want to do it?
Report a Broken Link
Thank you for reporting a broken "Go to
Material" link in MERLOT to help us maintain a collection of
valuable learning materials.
Link Reported as Broken
Your broken link report has been sent to
the MERLOT Team. Thank you for helping MERLOT maintain a current
collection of valuable learning materials!
Link Report Failed
Your broken link report failed to be sent.
Please try reloading the page and reporting it again. Thank you!
Sorry for the trouble.
If you feel this material is inappropriate for the MERLOT
Collection, please click SEND REPORT, and the MERLOT Team will
investigate. Thank you!
Material Reported as
Your inappropriate material report has
been sent to the MERLOT Team. Thank you for helping MERLOT maintain
a valuable collection of learning materials.
Material Report Failed
Your inappropriate material report failed
to be sent. Please try reloading the page and reporting it again.
Thank you! Sorry for the trouble.
Comment Reported as
Your inappropriate comment report has been
sent to the MERLOT Team. Thank you for helping MERLOT maintain a
valuable collection of learning materials.
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.