Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Staff
Extended Summary Statistics Add-in for JMP

The Summary platform in JMP offers an easy way to report many statistics, over multiple “By” groups, in data table format. The Distribution platform offers up an even greater variety of statistics, and we have had some customers ask for an easy way to get a Summary-style report of these. We’ve also received requests to add trimming and Winsorizing capabilities to all statistics.

If you’re not familiar with trimming or Winsorizing, don’t worry — the concepts are pretty simple: Trimming removes data from the “ends” of the sorted data set, while Winsorizing replaces these data with less extreme values.

For example, consider the data {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}. If we perform a 40% trim (perhaps a high percentage in practice but convenient for illustration), we keep only the middle 60% of the data, leaving us with the new data set { 3, 4, 5, 6, 7, 8 }.

If we perform a 40% Winsorizing, instead of removing the 1, 2, 9 and 10, we replace them with the minimum and maximum of the trimmed 40% data set. The result is the new data set { 3, 3, 3, 4, 5, 6, 7, 8, 8, 8 }. Winsorizing allows the extreme data in the original data set to contribute meaningful information to the analysis, while preventing it from having undue influence.

With the Extended Summary Statistics Add-in, you can compute any of the statistics on raw, trimmed or Winsorized data. The add-in has been designed with the look and feel of the Summary platform. So if you’ve used Summary, you’ll be up and running instantly. In addition to offering almost all of the statistics that the Summary and Distribution platforms offer, the add-in also will compute ranks, and presents the results in either a stacked or an unstacked (original) format.

I’ve placed the add-in in the “Stat” section of the add-ins on the JMP File Exchange. You can download it after logging in to your free SAS profile. Enjoy!

Article Labels

There are no labels assigned to this post.

Article Tags
Visitor

chris dorger wrote:

when I download this addin, it seems to be getting unpacked into its separate components. I don't wind up with a single *.addin file. Am I doing something wrong?

chris

Visitor

Hi Chris,

I am not sure if this applies to your case, but I've seen this happen before, so here goes:

When you download the file onto a Windows machine, sometimes (depending on your settings) the file comes over as a .zip file. In this case, you must rename the file so the extension is .jmpaddin instead of .zip. However, you must also ensure that you are not hiding extensions of known file types. So, you must navigate to settings and uncheck the box "hide extensions for known file types". If this is not done and you rename the file, it will appear as xxx.jmpaddin, but will actually be named xxx.jmpaddin.zip.

Hopefully this will remedy the issue; if not, please let us know.

Thank you,

Visitor

Aimee Tran wrote:

Hi, I would like to know if the correlation value that orthogonal regression report give in JMP 10 is a pearson correlation, r-value, or r-squared value.

Thanks,

Aimee

Staff