Statistical Analysis in MS Excel using KADD Stat!

Most of us know that we can do few statistical analysis using ‘Analysis Tool pack’ addin in Microsoft Excel. We can also do more than that using KADD STAT.

KADD STAT is an add-in which comes for free of cost and easy to use. Mostly all the versions after Excel 2003 would support. So, students and other people who want to use some basic statistical stuff can utilize this awesome one.

Download KADD here

How to Install the New Version of KADD

Also see video here

Option A

If KADD is currently not stored on your computer, then use the following steps:

  1. Download KADD into a folder on your hard drive
  2. Open up Excel
  3. Go to the Tools option and click on Add-Ins
  4. Click on the Browse button (on the right side of the dialog box) and go to the folder with KADD
  5. Double-Click on KADD
  6. KADDSTAT 3.02 will now show up as an Add-In option. Check it and press OK
  7. KADD will then show up as a menu option across the top. You may have to close Excel and then open it up again before you see KADD in Excel across the top

Option B

IF you have already installed the older version of KADD, then use the following steps to upgrade it to the new version:

  1. Download KADD to your hard drive
  2. Open up Excel
  3. Go to the Tools option and click on Add-Ins. KADD (the older version) will be an option in Add-In menu. Remove it by clicking off the check mark and shut down Excel
  4. Now open up Excel again and follow Steps 3 through 7 from Option A

Ready to rock?

A Glance at the available list of analysis in the add-in

List of analysis

You can calculate probability values

  1. Find confidence Intervals in different scenarios
Confidence Intervals

2. Plot a Normal curve

3. Plot ‘Box plots’ for your data

4. Find out minimal sample size for different scenarios

Sample Size

5. Perform Hypothesis testing

Hypothesis Testing

6. Draw different quality control charts and find out process capability for normal data

Quality Control

7. Find out correlation and regression 

Regression and Correlation

8. Become a forecasting pro ! 🙂


9. Some financial calculations

Risk and Return

10. Find out Expected value and variability

11. Perform Decision Trees 

12. Linear Programming

Reference Tables

Doing this is simple if you have data and know what to do. Give it a try and enjoy ! Happy learning…