Excel add-in to calculate the chi-square test statistic p-value
The built-in Excel chi-square function is rather more complex and time-consuming. I have written an Excel add-in that streamlines the process.
Steps to install the add-in
- Download the file above to your USB drive. Don't open the file!
- Open Excel.
- Click the "Office Button" at the top right-hand corner of the screen. The button is round and has different colored windows inside of it.
- Select "Excel Options."
- Select "Add-ins"
- Next to where it says "manage," click Go...
- At the Add-ins dialog box, click Browse... Find the file that you downloaded (chi_square.xlam).
- In the Add-In dialog box, you should see "Chi_square." Check it if its unchecked and press OK.
- There may be another dialog box. Press Yes.
- Now the add-in should be installed. You can now use the function that I created called chisquare.