# Addin Descriptive Statistics and Excel

#### chattanuga

##### New Member
Hy all!

Not really a question, just wanted to post the correct way to adress the descriptive statistics add-in with vba (because after half a day of searching and then trial and error I think I finally figured it out!)

Hope it saves some of you from having to do the same thing!

Application.Run "ATPVBAEN.XLAM!Descr", Input Range, Output Range, "C" or "R" depending on data is in columns or rows,True or False if labels are in first row/column, True or False if summary is wanted or not, number of kth largest, number of kth smallest, percentage of mean of confidence level
<output range=""><the data="" is="" in="" the="" columns="" (put="" "c")="" or="" rows="" "r")=""><labels in="" first="" row="" column="" (depending="" on="" the="" "c"="" or="" "r"="" parameter)="" (put="" true="" false)=""><summary statistics?="" (put="" true="" or="" false)=""><kth largest=""><kth smallest=""><confidence level="" for="" mean="">
So for example

Application.Run "ATPVBAEN.XLAM!Descr", Sheets("Sheet1").Range(Cells(1, 1), Cells(10,2)), Sheets("Sheet1").Cells(1,5), "C", False, True,1,2,95

will give you the descriptive statistics of the data in A1 to B10 columnwise and write it to E1. The data name is not in the first row, you will get a summary, the 1th Largest and 2nd smallest values are shown and the 95% mean confidence level.</confidence></kth></kth></summary></labels></the></output>

Last edited:

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Replies
3
Views
775
Replies
1
Views
246
Replies
1
Views
822
Replies
3
Views
279
Replies
3
Views
1K

1,195,990
Messages
6,012,727
Members
441,723
Latest member
iansitorus

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back