InstructionsforPValueCalculatoradd-in-WabashCollege.docVIP

The P Value Calculator Excel Add-in Software for Introductory Econometrics By Humberto Barreto and Frank M. Howland barretoh@ and howlandf@ (765) 361-6315 and (765) 361-6317 WARNING: This software was written and designed for teaching purposes. It has been tested on several examples but not on a wide variety of data sets. For mission-critical projects, always check the results with full-fledged statistical programs. The P Value Calculator add-in is PValue.xla (in BasicTools\ExcelAddIns\PValueCalcuator). PURPOSE OF THIS DOCUMENT This document explains how to find exact probability values (or significance levels) in Excel by using the P Value Calculator add-in. Normal, t (Student’s t), ?2 (chi-squared), F, and Durbin-Watson d distributions are available. The user provides needed input and the add-in calculates the P-Value. The user can obtain a picture of the results for P-Values greater than 0.01% (except for the Durbin Watson d statistic). This document reviews Excel add-ins and describes how to access and install the P Value Calculator. Once installed, it explains how to use the P Value Calculator via an example. Organization Reviewing Excel Add-Ins Installing the P Value Calculator Add-In Using the P Value Calculator Conclusion Reviewing Excel Add-Ins An add-in file, usually named filename.xla (“a” for add-in), is a way for Excel to access procedures and algorithms that are not part of the core Excel program. Add-ins provide extensive flexibility and additional functionality from within the familiar Excel interface. The Add-In Manager, a dialog box from which you control the add-ins available to Excel, can be accessed by executing Tools: Add-Ins. Try it now to see which, if any, add-ins you have installed. To the right is an example of the Add-Ins dialog box from a Mac screen. Notice the Browse (Windows) or Select (MacOS) button in the Add-In Manager dialog box. This button enables you to access additional add-in