This weekend while I was importing some new music on my computer, I found myself manually searching through my Apple® iTunes library to figure out which artists were represented most heavily in my music collection. During this process, it occurred to me that a visual in JMP might be a
Last week, I showed how the Excel Add-In for JMP can bring more value to Excel spreadsheets for what-if analysis and optimization. Today, we’ll look at how using that same data from within JMP alone is more elegant. First, let’s look at the Excel spreadsheet from last week's post (see
As Valentine’s Day approaches, a wise person starts thinking about what gift to give to their loved ones. Chocolate is always a popular gift. And as a homeschooling parent, I try to turn many things into lessons. How could I turn chocolate into a lesson for my children, and how
Over the past few weeks, we’ve looked at the rise of Excel’s usage and popularity, and I've noted that Excel has made forays into analytics. Today, we’ll look at one type of analysis: scenario-based planning and optimization. Using Excel add-ins, you can create what-if analysis and scenario-based planning using Monte
Last week, we looked at the first scenario in our example showing some guesswork that Excel performs when adding to existing data that are included in a formula. This week, we’ll look at Scenarios 1b and 2, which further show the behavior of Excel after rows are inserted within a
In my last blog post, I introduced the new Multiple Comparisons option available in Fit Model Least Squares in JMP 11 and showed an example where we compared the treatment means of two effects to the overall average. We learned how to examine a Comparison with Overall Average Decision Chart, also known
Last week, I shared some of the many stories about errors in Excel spreadsheets that led to misinformation and to a path toward incorrect decisions. Today, we’ll explore why such errors can be potentially pervasive. The power of the spreadsheet has always been its interactive ease of use. It allows
In 2010, esteemed Harvard professors Carmen Reinhart and Kenneth Rogoff published the paper “Growth in a Time of Debt.” It soon became powerful supporting evidence for those who argued against growing government spending, even in times of needed economic stimulation. The paper looked at the debt levels of many different
JMP 11 provides a convenient way to convert a continuous numeric column into a new column that represents a sequence of ranges. The command is called Make Binning Formula in the Columns menu. It brings up a dialog that lets you interactively choose the binning parameters (offset and width) and
Interactive HTML is a new technology for sharing results in JMP 11. In a previous post, I showed these examples: Diamonds (Distribution Analysis) Movies (Multivariate Analysis) Sales per Employee (Fitted Model) In this post, I want to describe in more detail how to use this new feature. There are two