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!

tags: Add-Ins, JMP 10, Statistics

4 Comments

  1. chris dorger
    Posted January 8, 2013 at 1:53 pm | Permalink

    Brady,
    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

  2. Brady Brady Brady Brady
    Posted January 9, 2013 at 12:20 pm | Permalink

    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.

    Once the downloaded file is named xxx.jmpaddin, opening the file in JMP (or, simply double-clicking the file) will install the add-in.

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

    Thank you,
    Brady

  3. Aimee Tran
    Posted January 18, 2013 at 7:29 pm | Permalink

    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

  4. Brady Brady Brady Brady
    Posted January 18, 2013 at 8:51 pm | Permalink

    Hi Aimee,

    The correlation value given in the orthogonal regression report is Pearson's r.

    Thank you,
    Brady

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <p> <pre lang="" line="" escaped=""> <q cite=""> <strike> <strong>