"Proving the Null" (PTN) Home Page >> Downloading and Installing the PTN add-in for Excel

Note: Installing PTN is very easy. The instructions may seem long but the only reason is because there are a lot of screenshots to guide you step by step, so don't be discouraged.
Installing PTN actually takes less time than it takes you to read through the instructions.

 

 

 

 

 

 

 

 

 

 

 


Download the PTN add-in

NOTE: PTN requires the Matlab Component Runtime (MCR) software. If you do not have MCR installed on your machine already, please download the installation file that contains MCR as well.

32bit Version

64bit Version

The PTN add-in has not been compiled or tested for a 64bit Windows operating system at the moment. Since we now have the code runing online chances are a 64bit version will not be available as an Excel add-in

 

 


Installing on Windows 2000/XP with Office XP/2003

IMPORTANT: Administrative privileges are needed to install the PTN Excel Add-in. If you do not have administrative privileges, please contact your local administrator.

  1. Right-click the install file you downloaded and choose "Run as ..." from the menu (Figure 1)

    Figure 1
    Figure 1

  2. Do not run as current user even if the current user has administrative privileges. Instead select "The following user:" and enter username and password for a user that has administrative privileges. (See Figure 2)

    Figure 2
    Figure 2

    Depending on your security settings you may get a message saying "The publisher could not be verified. Are you sure you want to run this software?" (See Figure 3). It is ok, just click the "Run" button.

    Figure 3
    Figure 3

  3. Then a window will open asking you to enter your username in order to install the Add-in, into your personal documents folder (only you will be abThen a command window will open and the installation will begin. Do not close this window until you it says "Installation complete, press Enter to exit".

  4. The Matlab Component Runtime (MCR) installation will begin first (See Figure 4 & 5). Go through the steps of the wizzard. Default settings should be ok, just click through the steps.

    (NOTE: You can skip this step if you have downloaded the install package without MCR or if you already have MCR installed)

    Figure 5
    Figure 4

    Figure 6
    Figure 5

  5. When the installation is done, the black-background install window will display a message that the installation is complete and ask you to press ENTER to exit. ot;Installing on Windows Vista with Office 2007" instructions.

  6. Open Excel and click on "TooNOTE: If you have Office 2007 installed proceed with step 6 of the "Installing on Windows Vista with Office 2007" instructions.

  7. Open Excel and click on "Tools\Add-ins ..." (See Figure 6)

    Figure 7
    Figure 6

  8. A list of Add-Ins will be displayed (See Figure 7). Click on the checkbox next to the PTN Add-in and click OK.

    Figure 8
    Figure 7

YOU ARE DONE!he PTN Excel Add-in. If you do not have administrative privileges, please contact your local administrator.

  1. Right-click the install file you downloaded and choose "Run as administrator." from the menu (Figure 1)

    Figure 1
    Figure 1

  2. Type in the administrative password for the correct user.

    Depending on your security settings you may get a message saying "The publisher could not be verified. Are you sure you want to run this software?" (See Figure 2). It is ok, just click the "Run" button.

    Figure 2
    Figure 2

  3. Then a window will open asking you to enter your username in order to install the Add-in, into your personal documents folder (only you will be able to use the Add-in functionality). Leave this blank to install in the root directory, so thatFigure 2

  4. Then a command window will open and the installation will begin. Do not close this window until you it says "Installation complete, press Enter to exit".

  5. The Matlab Component Runtime (MCR) installation will begin first (See Figure 3 & 4). Go through the steps of the wizzard. Default settings should be ok, just click through the steps.

    (NOTE: You can skip this step if you have downloaded the install package without MCR or if you already have MCR installed)

    Figure 4
    Figure 3

    Figure 5
    Figure 4

  6. When the installation is done, the black-background install window will display a message that the installation is complete and ask you to press ENTER to exit. k on the Office button (Big round button in the top left corner) and then click on "Excel Options" (See Figure 6)

    NOTE: If you have Office XP/2003 installed proceed with step 6 of the "Installing on Windows 2000/XP with Office XP/2003" instructions.

  7. Open Excel, click on the Office button (Big round button in the top left corner) and then click on "Excel Options" (See Figure 5)

    Figure 6
    Figure 5

  8. The options window will open. Click on the "Add-ins" tab and the on the "Go ..." button (See Figure 6)

    Figure 7
    Figure 6

  9. A list of Add-Ins will be displayed (See Figure 7). Click on the checkbox next to the PTN Add-in and click OK.

    Figure 8
    Figure 7

YOU ARE DONE! location where you ran the installation file from.
The ptn.xls file has 3 sheets, 1 for each function (BF2, ConvDists, and BinimBF). You can switch between them using the tabs at the bottom left corner (See Figure 1)

Figure 1
Figure 1

Depending on your version of Excel the "Proving the Null" menu will either be in the main toolbar (for Excel XP/2003 - Figure 2) or in the Add-ins tab (for Excel 2007 - Figure 3)

Figure 2
Figure 2
Figure 3
Figure 3

 

Using BF2

  1. Open the "ptn.xls" file by double-clicking on it and go to the "bf2 test" sheet. You should see the test data (Figure 1)

    Figure 1
    Figure 1

  2. Once you click on the "Run BF2" option from the "Proving the Null" menu, the BF2 entry form will show up. (Figure 2)

    Your inputs are:
    - Control Data (fields A3:A10)
    - Experiment Data (fields B3:B12)
    - Analytical Limit (fields C3:C4)
    - *Increment Prior (fields D3:D4)

    Your outputs are:
    - Weight: (field F3)
    - Odds for: (field G3)
    - Odds against: (field H3)
    - *Null prior: (begins at field I3)
    - *Alternative prior: (begins at field K3)
    - *Likelyhood: (begins at field M3)

    * Optional Fields

    If you check the "Plot results" checkbox, the output data will also be presented to you visually (See Figure 3)


    Figure 2
    Figure 3
    Figure 3

Using ConvDists

  1. Open the "ptn.xls" file by double-clicking on it and go to the "convdists test" sheet. You should see the test data (Figure 1)

    Figure 1
    Figure 1

  2. Once you click on the "Run ConvDists" option from the "Proving the Null" menu, the ConvDists entry form will show up. (Figure 2)

    Your inputs are:
    - A (fields A3:C341)
    - F (field E3)

    Figure 2
    Figure 2

    Once you click the OK button, data will be inserted in the correct output columns (Figure 3)

    Figure 3
    Figure 3

Using BinomBF

  1. Open the "ptn.xls" file by double-clicking on it and go to the "binombf test" sheet. You should see the test data (Figure 1)

    Figure 1
    Figure 1

  2. Once you click on the "Run BinomBF" option from the "Proving the Null" menu, the BinomBF entry form will show up. (Figure 2)

    Your inputs are:
    - Draws (field A3)
    - Successes (field B3)
    - Probability Parameter (field C3)
    - Upper Limit (field D3)

    Your outputs are:
    - Weight: (field F3)
    - Odds for: (field G3)
    - Odds against: (field H3)

    If you check the "Plot results" checkbox, the output data will also be presented to you visually (See Figure 3)

    Figure 2
    Figure 2
    Figure 3
    Figure 3

 


This page is maintained by Dr Charles Gallistel, Co-Director, Rutgers Center for Cognitive Science