chattanuga
New Member
- Joined
- Mar 28, 2013
- Messages
- 1
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>
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: