Search all MERLOT
Click here to go to your profile
Select to go to your workspace
Click here to go to your Dashboard Report
Click here to go to your Content Builder
Click here to log out
Search Terms
Enter username
Enter password
Please give at least one keyword of at least three characters for the search to work with. The more keywords you give, the better the search will work for you.
select OK to launch help window
cancel help



Search > Material Results >




Logo for PredInt.xls
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... More
Material Type: Simulation
Date Added to MERLOT: April 20, 2004
Date Modified in MERLOT: June 05, 2011
Submitter: John McClain


  • Editor Review avg: 4.5 rating
  • User Rating (not rated)
  • Comments (none)
  • Learning Exercises (none)
  • Personal Collections (4)
  • Accessibility Info (none)


Primary Audience: Graduate School, Professional, College Upper Division
Mobile Compatibility: Not specified at this time
Technical Requirements: Runs as a Macro in Microsoft Excel. Macros must be enabled. Runs in Excel 2003 or 2007
Language: English
Cost Involved: no
Source Code Available: yes
Accessiblity Information Available: no
Creative Commons: unsure


QR Code for this Page

Browse in Categories


Discussion for PredInt.xls

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

Return to Top of Page