Excel 2007 compatible Prediction Intervals for Excel
Peer Review for material titled "Excel 2007 compatible Prediction Intervals for Excel"
User Rating for material titled "Excel 2007 compatible Prediction Intervals for Excel"
Member Comments for material titled "Excel 2007 compatible Prediction Intervals for Excel"
Personal Collections for material titled "Excel 2007 compatible Prediction Intervals for Excel"
Learning Exercises for material titled "Excel 2007 compatible Prediction Intervals for Excel"
Accessibility Info for material titled "Excel 2007 compatible Prediction Intervals for Excel"
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

MERLOT II




        

Search > Material Results >

Excel 2007 compatible Prediction Intervals for Excel

        

Excel 2007 compatible Prediction Intervals for Excel

Logo for Excel 2007 compatible  Prediction Intervals for Excel
NOW COMPATIBLE WITH EXCEL 2007 AND EXCEL 2003. The Regression tool in Excel's Data Analysis tool package does not calculate prediction intervals. The PredInt 2008-2003.xls spreadsheet contains a macro to do that. Features include a Normal Probability Plot, residual plots, line-fit plots, and standardized residuals that match the ones calculated in most commercial statistics packages (Excel's program calculates them differently). Outliers and influential observations are also flagged.
Material Type: Reference Material
Technical Format: Microsoft Excel with Macro
Date Added to MERLOT: September 28, 2007
Date Modified in MERLOT: September 28, 2007
Submitter: John McClain

Details

  • Reviewed by members of Editorial board for inclusion in MERLOT.
    Editor Review
    Useful material in MERLOT
    avg: 3 rating
  • User Rating (not rated)
  • Comments (none)
  • Learning Exercises (none)
  • Personal Collections (none)
  • Accessibility Info (none)

About

Primary Audience: College General Ed
Mobile Compatibility: Not specified at this time
Technical Requirements: Microsoft Excel 2007 or earlier
Language: English
Cost Involved: no
Source Code Available: yes
Accessiblity Information Available: unsure
Creative Commons: unsure

Connections





QR Code for this Page

Browse in Categories

Discussion

Discussion for Excel 2007 compatible Prediction Intervals for Excel

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

Return to Top of Page