1. Home
  2. Material Detail: PredInt.xls

Material Detail

PredInt.xls

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 normal probability plot is incorrect.)
Disciplines:
Go to Material 
Bookmark / Add to Course ePortfolio
Create a Learning Exercise
Add Accessibility Information
Rate
Add a Comment

Quality

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

More about this material

Material Type:
Simulation
Date Added to MERLOT:
April 20, 2004
Date Modified in MERLOT:
July 21, 2017
Author:
 
Submitter:
John McClain
Primary Audience:
College Upper Division, Graduate School, Professional
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:
Unknown
Creative Commons:
No

Browse...

Disciplines with similar materials as PredInt.xls
People who viewed this also viewed
Other materials like PredInt.xls

Comments

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