JMP® is statistical analysis software with capabilities that span from data access to advanced statistical techniques, with click of a button sharing. The software is interactive and visual, and statistically deep enough to allow users to see and explore data.
$1,320
per year per user
Microsoft Excel
Score 8.7 out of 10
N/A
Microsoft Excel is a spreadsheet application available as part of Microsoft 365 (Office 365), or standalone, in cloud-based and on-premise editions.
Many organizations have seen their analytical capabilities, and the results from them, plateau. Of these, we've observed, that most of them didn't appreciate that they could do (even) better. These companies should definitely consider JMP. Any company that is research-based can benefit from accelerating their research, learning more in less time, effort and cost, with JMP's tools. Basically, any organization that is hungry enough for improvement to seek out better ways is suitable for JMP. Those who are happy with their current performance are not likely to consider the changes, though they were not major impediments by our clients, required.
I find it easier to use than Google Sheets , though it's easier to collaborate with other teams using Google Sheets. I also feel like Microsoft Excel is more suited to deal with complex formulas. The best way to put it, if I have a project that I'm solely working on, I'm going to use Microsoft Excel. If it's going to be shared, then I'm using Google Sheets.
Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.
I've mentioned this earlier, but the licensing agreements are very prohibitive. I work with a company where my role has become less and less doing my own analytics and more and more trying to help other people in that role. As we are bringing more people "up to speed" it's hard to justify licenses for 2-3 people when they aren't full time, Six Sigma black belts just looking at stats all day. A floating license option would make this a no-brainer, since these people could continue their other work and add JMP usage as they grow their skills, but this is not something JMP/SAS has offered.
Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.
The GUI interface makes it easier to generate plots and find statistics without having to write code. The JSL scripting is a bit of a steep learning curve but does give you more ability to customize your analysis. Overall, I would recommend JMP as a good product for overall usability.
Overall I think the usuability is great and offers everything it should. I have never not be able to use it for what I wanted it for. However, it is so detailed and offers so much it can be difficult to use. Better descriptions or explanation to all the information could be helpful
The helpful tips are great for new users. I am always able to find solutions to a tool I am working with through the hep section. And my area has a users group that meets each quarter to share ideas and view upcoming JMP revisions.
We actually use both JMP and IBM SPSS, but I think JMP's complexity lends itself to more in-depth statistical analyses. SPSS is designed for that as well, but we tend to use it more for quicker analyses, and we have found that JMP is far more powerful.
Excel is one of the tools I use for everyday work but fits alongside all the other programs I use. I keep Excel as a way of tracking projects from start to finish as well as document content strategy and audits. There are not many programs like Excel that I can think of other than Google Sheets and I find Excel is far better.
Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise
JMP has resulted in literally millions of dollars in ROI due to identification of correctable errors.
Use of JMP control charts JMP has greatly simplified and improved interpretation of Lean, FMEA, and PDSA type analyses.
Use of JMP has enable the testing and subsequent selection of 'best practices' saving uncounted hours in false starts based on 'collective experience'.
The down side is that JMP is not a 'magic box', one still has to take care in applying the tools properly. Moreover, time-consuming approaches using JMP may still be the 'order of the day', because the service (even power user) is unaware of significant shortcuts available for free on the JMP community website.
It helps to me gather my thoughts, organize my research, and most importantly prioritize information in an easy to digest manner depending on what I am most interested to see at that time.
It helps me quite a bit to talk my clients through the financial implications of various office leasing transactions under consideration and coach them in a way that is very unbiased and fact-driven which I like.
It helps me to be more thoughtful as well when thinking about the various different situations in which I use Excel. And because it ultimately results in my clients getting comfortable ultimately pulling the trigger on a given deal, it directly leads to more commission in my pocket which I love!
