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"
Bookmark Collections for material titled "Excel 2007 compatible Prediction Intervals for Excel"
Course ePortfolios 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"
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

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

Quality

  • Reviewed by members of Editorial board for inclusion in MERLOT.
    Editor Review (not reviewed)
  • User Rating (not rated)
  • Comments (none)
  • Learning Exercises (none)
  • Bookmark Collections (none)
  • 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...

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

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