-
Challenge 11 - Finding outliers, my take
My motivation for this month’s challenge was to have you think beyond the traditional definition of outliers as only being observations falling far from the center of the data (relative to the amount of data variability). In general, we can consider an outlier as a non-representative data point, something that doesn’t…
-
Challenge 11 - Outlier Screening
Outlier screening is an anomaly detection methodology where the data is typically numeric. JMP has four outlier screening methods under the Analyze > Screening > Explore Outliers menu option. Two of these methods are univariate, applicable to outliers that can be identified from a single column of data. These methods use a…
-
Challenge 10 Results
Item 1 The challenging part here in Item 1 of Challenge 10 is not the code but the intricacies around the definition of quantile. First, let's keep things distribution independent and work with the rank order of the values rather than the values directly. That is, we sort values in ascending order and number them according…
-
Challenge 5 – Results
My apologies for the delay on this write up. I have been very busy with, among other things, preparations for a talk on Functional Data Explorer at JMP Discovery Summit . It appears the regular contributors were equally preoccupied, as I only received two non-staff submissions for this challenge. Here are point totals…
-
Challenge 10
One of the things I forgot to mention in my previous post was that the matrix lookup method adapts poorly to character data. The code in Set Operations using matrices.JSL contains the function mapString which converts a character string comprised of lower-case letters to a numeric value. This mapping slows things down…
-
Challenge 9 results
Let’s start with an interactive solution. The table operations Summary and Join can be used to determine unions, intersections and differences. Unions are the simplest, just put everything in one column and Group by that column. The union, with duplicates removed, appears as the first column in the resultant table. To find…
-
Challenge 9 - Finding differences and similarities
The need to create intersections, differences, and unions, comes up when we need to know values in common, exclusive, or unique to two or more data sets. For this month, create three functions: * intersection(aList, bList) – Returns a list of values contained in both aList and bList. * difference(aList, bList) – Returns…
-
JMP Challenge 8: My solutions
What is the fastest way to turn the elements in a list of number lists into characters? This challenge is an extension of the question found here in the Community. I decided to test eight approaches: three iterative methods (For, For Each, and Transform Each), four non-iterative methods (table operations, expressions,…
-
JMP Challenge 7 - Solutions/Challenge 8
Thanks to those folks who gave Challenge 7 a try. Hopefully, even if you didn’t have a chance, you’ve been following the discussions. How can we solve this challenge? Conceptually, the simplest approach would find single character duplicates, then two-character duplicates, three character, etc., increasing by one character…
-
JMP Challenge 7
With lots going since just after the last post, including getting ready for JMP 16, which came out only a few days ago, and with no replies to my last post asking for column formula challenges that readers had encountered, I didn’t think I had the time or material to post something worth your time reading. I’ve had a bit…