Peer Review for material titled "PredInt.xls"
eTextbook Reviews for material titled "PredInt.xls"
User Rating for material titled "PredInt.xls"
Member Comments for material titled "PredInt.xls"
Bookmark Collections for material titled "PredInt.xls"
Course ePortfolios for material titled "PredInt.xls"
Learning Exercises for material titled "PredInt.xls"
Accessibility Info for material titled "PredInt.xls"
Please enter a Bookmark title
Please limit Bookmark title to 65 characters
Please enter a description
Please limit Bookmark title to 4000 characters
A Bookmark with this title already existed.
Please limit a note about this material to 2048 characters
Search all MERLOT
Select to go to your profile
Select to go to your workspace
Select to go to your Dashboard Report
Select to go to your Content Builder
Select 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


Advanced Search


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
Go to material
Material Type: Simulation
Date Added to MERLOT: April 20, 2004
Date Modified in MERLOT: June 05, 2011
Submitter: John McClain


  • Reviewed by members of Editorial board for inclusion in MERLOT.
    Editor Review
    Very good quality; in queue to be peer reviewed
    avg: 5 rating
  • User Rating (not rated)
  • Comments (none)
  • Learning Exercises (none)
  • Bookmark Collections (4)
  • Course ePortfolios (none)
  • Accessibility Info (none)

  • Rate this material
  • Create a learning exercise
  • Add accessibility information
  • Pick a Bookmark Collection or Course ePortfolio to put this material in or scroll to the bottom to create a new Bookmark Collection
    Name the Bookmark Collection to represent the materials you will add
    Describe the Bookmark Collection so other MERLOT users will know what it contains and if it has value for their work or teaching. Other users can copy your Bookmark Collection to their own profile and modify it to save time.
    Edit the information about the material in this {0}
    Submitting Bookmarks...


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
Accessibility Information Available: no
Creative Commons: unsure


QR Code for this Page

Users who viewed this material also viewed...


Discussion for PredInt.xls

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

Return to Top of Page