JMP Statistical Discovery Software from SAS vs. Microsoft Excel

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
JMP Statistical Discovery Software from SAS
Score 8.3 out of 10
N/A
JMP is a division of SAS and the JMP family of products provide statistical discovery tools linked to dynamic data visualizations.
$125
per month
Microsoft Excel
Score 8.9 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.
$6.99
per month
Pricing
JMP Statistical Discovery Software from SASMicrosoft Excel
Editions & Modules
Personal License
$125.00
per month
Corporate License
$1,510.00
Per Month Per Unit
Excel with Microsoft 365
$6.99
per month
Excel for 1 PC or Mac
$139.99
perpetual license
Offerings
Pricing Offerings
JMP Statistical Discovery Software from SASMicrosoft Excel
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
JMP Statistical Discovery Software from SASMicrosoft Excel
Top Pros
Top Cons
Features
JMP Statistical Discovery Software from SASMicrosoft Excel
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
JMP Statistical Discovery Software from SAS
9.5
9 Ratings
12% above category average
Microsoft Excel
-
Ratings
Pixel Perfect reports10.01 Ratings00 Ratings
Customizable dashboards9.09 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
JMP Statistical Discovery Software from SAS
7.6
13 Ratings
5% below category average
Microsoft Excel
-
Ratings
Drill-down analysis7.813 Ratings00 Ratings
Formatting capabilities6.612 Ratings00 Ratings
Integration with R or other statistical packages7.810 Ratings00 Ratings
Report sharing and collaboration8.213 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
JMP Statistical Discovery Software from SAS
8.7
12 Ratings
4% above category average
Microsoft Excel
-
Ratings
Publish to Web9.09 Ratings00 Ratings
Publish to PDF8.712 Ratings00 Ratings
Report Versioning7.01 Ratings00 Ratings
Report Delivery Scheduling10.01 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
JMP Statistical Discovery Software from SAS
8.3
16 Ratings
2% above category average
Microsoft Excel
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)8.016 Ratings00 Ratings
Location Analytics / Geographic Visualization9.013 Ratings00 Ratings
Predictive Analytics7.913 Ratings00 Ratings
Best Alternatives
JMP Statistical Discovery Software from SASMicrosoft Excel
Small Businesses
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
Google Sheets
Google Sheets
Score 8.5 out of 10
Medium-sized Companies
Mathematica
Mathematica
Score 8.2 out of 10
Google Sheets
Google Sheets
Score 8.5 out of 10
Enterprises
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
Google Sheets
Google Sheets
Score 8.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
JMP Statistical Discovery Software from SASMicrosoft Excel
Likelihood to Recommend
7.4
(28 ratings)
9.5
(57 ratings)
Likelihood to Renew
10.0
(16 ratings)
9.9
(5 ratings)
Usability
10.0
(5 ratings)
10.0
(2 ratings)
Availability
10.0
(1 ratings)
10.0
(1 ratings)
Performance
10.0
(1 ratings)
10.0
(1 ratings)
Support Rating
9.2
(7 ratings)
9.0
(1 ratings)
Online Training
7.9
(3 ratings)
-
(0 ratings)
Implementation Rating
9.6
(2 ratings)
8.0
(1 ratings)
Configurability
-
(0 ratings)
9.0
(1 ratings)
Ease of integration
-
(0 ratings)
9.0
(1 ratings)
Product Scalability
10.0
(1 ratings)
10.0
(1 ratings)
Vendor post-sale
-
(0 ratings)
9.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
9.0
(1 ratings)
User Testimonials
JMP Statistical Discovery Software from SASMicrosoft Excel
Likelihood to Recommend
SAS
It is perfectly suited for statistical analyses, but I would not recommend JMP for users who do not have a statistical background. As previously stated, the learning curve is exceptionally steep, and I think that it would prove to be too steep for those without statistical background/knowledge
Read full review
Microsoft
For tasks like financial analysis, budgeting, forecasting, and data visualization, I frequently use Microsoft Excel. I can develop financial models, use pivot tables to examine enormous datasets, and produce eye-catching visualizations thanks to its comprehensive features. I have, however, also come across circumstances in which Excel isn't the best tool.Excel falls short of alternatives like Google Sheets when I need to collaborate with my team in real-time. I favor employing robust database management systems or data analysis tools like SQL, Python, or R for managing very big data sets or sophisticated calculations. I use specialized tools like SPSS, SAS, or programming languages for better outcomes when complex statistical analysis or machine learning are necessary. And finally, for formatting elaborate reports, In conclusion, even though I consider Excel to be a great tool for many finance jobs, there are some limits in collaborating, processing big amounts of data, performing complex analysis, and creating documents that I take into account when choosing the best tool for the job.
Read full review
Pros
SAS
  • JMP is designed from the ground-up to be a tool for analysts who do not have PhDs in Statistics without in anyway "dumbing down" the level of statistical analysis applied. In fact, JMP operationalizes the most advanced statistical methods. JMP's design is centred on the JMP data table and dialog boxes. It is data focused not jargon-focussed. So, unlike other software where you must choose the correct statistical method (eg. contingency, ANOVA, linear regression, etc.), with JMP you simply assign the columns in a dialog into roles in the analysis and it chooses the correct statistical method. It's a small thing but it reflects the thinking of the developers: analysts know their data and should only have to think about their data. Analyses should flow from there.
  • JMP makes most things interactive and visual. This makes analyses dynamic and engaging and obviates the complete dependence on understanding p-values and other statistical concepts(though they are all there) that are often found to be foreign or intimidating.
  • One of the best examples of this is JMP's profiler. Rather than looking at static figures in a spreadsheet, or a series of formulas, JMP profiles the formulas interactively. You can monitor the effect of changing factors (Xs) and see how they interact with other factors and the responses. You can also specify desirability (maximize, maximize, match-target) and their relative importances to find factor settings that are optimal. I have spent many lengthy meetings working with the profiler to review design and process options with never a dull moment.
  • The design of experiments (DOE) platform is simply outstanding and, in fact, the principal developers of it have won several awards. Over the last 15 years, using methods broadly known as an "exchange algorithm," JMP can create designs that are far more flexible than conventional designs. This means, for example, that you can create a design with just the interactions that are of interest; you can selectively choose those interactions that are not of interest and drop collecting their associated combinations.
  • Classical designs are rigid. For example, a Box-Benhken or other response surface design can have only continuous factors. What if you want to investigate these continuous factors along with other categorical factors such as different categorical variables such as materials or different furnace designs and look at the interaction among all factors? This common scenario cannot be handled with conventional designs but are easily accommodated with JMP's Custom DOE platform.
  • The whole point of DOE is to be able to look at multiple effects comprehensively but determine each one's influence in near or complete isolation. The custom design platform, because it produces uniques designs, provides the means to evaluate just how isolated the effects are. This can be done before collecting data because this important property of the DOE is a function of the design, not the data. By evaluating these graphical reports of the quality of the design, the analyst can make adjustments, adding or reducing runs, to optimize cost, effort and expected learnings.
  • Over the last number of releases of JMP, which appear about every 18 months now, they have skipped the dialog boxes to direct, drag-and-drop analyses for building graphs and tables as well as Statistical Process Control Charts. Interactivity such as this allows analysts to "be in the moment." As with all aspects of JMP, they are thinking of their subject matter without the cumbersomeness associated with having to think about statistical methods. It's rather like a CEO thinking about growing the business without having to think about every nuance and intricacy of accounting. The statistical thinking is burned into the design of JMP.
  • Without data analysis is not possible. Getting data into a situation where it can be analyzed can be a major hassle. JMP can pull data from a variety of sources including Excel spreadsheets, CSV, direct data feeds and databases via ODBC. Once the data is in JMP it has all the expected data manipulation capabilities to form it for analysis.
  • Back in 2000 JMP added a scripting language (JMP Scripting Language or JSL for short) to JMP. With JSL you can automate routine analyses without any coding, you can add specific analyses that JMP does not do out of the box and you can create entire analytical systems and workflows. We have done all three. For example, one consumer products company we are working with now has a need for a variant of a popular non-parametric analysis that they have employed for years. This method will be found in one of the menus and appear as if it were part of JMP to begin with. As for large systems, we have written some that are tens of thousands of lines that take the form of virtual labs and process control systems among others.
  • JSL applications can be bundled and distributed as JMP Add-ins which make it really easy for users to add to their JMP installation. All they need to do is double-click on the add-in file and it's installed. Pharmaceutical companies and others who are regulated or simply want to control the JMP environment can lock-down JMP's installation and prevent users from adding or changing functionality. Here, add-ins can be distributed from a central location that is authorized and protected to users world-wide.
  • JMP's technical support is second to none. They take questions by phone and email. I usually send email knowing that I'll get an informed response within 24 hours and if they cannot resolve a problem they proactively keep you informed about what is being done to resolve the issue or answer your question.
Read full review
Microsoft
  • It is very good at embedded formulas and tying cells to one another
  • It allows me to compare deals terms on a side-by-side basis and talk my clients through it easily.
  • It is very helpful as well in terms of allowing me to filter/sort results in many different ways depending on what specific information I am most interested in prioritizing.
Read full review
Cons
SAS
  • In general JMP is much better fit for a general "data mining" type application. If you want a specific statistics based toolbox, (meaning you just want to run some predetermined test, like testing for a different proportion) then JMP works, but is not the best. JMP is much more suited to taking a data set and starting from "square 1" and exploring it through a range of analytics.
  • The CPK (process capability) module output is shockingly poor in JMP. This sticks out because, while as a rule everything in JMP is very visual and presentable, the CPK graph is a single-line-on-grey-background drawing. It is not intuitive, and really doesn't tell the story. (This is in contrast with a capability graph in Minitab, which is intuitive and tells a story right off.) This is also the case with the "guage study" output, used for mulivary analysis in a Six Sigma project. It is not intuitive and you need to do a lot of tweaking to make the graph tell you the story right off. I have given this feedback to JMP, and it is possible that it will be addressed in future versions.
  • I've never heard of JMP allowing floating licenses in a company. This will ALWAYS be a huge sticking point for small to middle size companies, that don't have teams people dedicated to analytics all day. If every person that would do problem solving needs his/her own seat, the cost can be prohibitive. (It gets cheaper by the seat as you add licenses, but for a small company that might get no more than 5 users, it is still a hard sell.)
Read full review
Microsoft
  • Counting conditionally formatted cells (e.g., you have 5 green cells, 10 red ones, and 3 orange ones in a row).
  • Merging cells in a table; I have to remove the table first and then re-add the table to merge cells together.
  • Offering more preset colour categories for formatting graphs.
  • Built-in functions to run ANOVAs, Multiple Linear Regression, Factor Analysis, etc.
Read full review
Likelihood to Renew
SAS
JMP has been good at releasing updates and adding new features and their support is good. Analytics is quick and you don't need scripting/programming experience. It has been used organization wide, and works well in that respect. Open source means that there are concerns regarding timely support. Cheap licensing and easy to maintain.
Read full review
Microsoft
It comes with MS Office. Unless we stop using PCs or Microsoft Office, it's highly unlikely, even imperceivable to not continue to use Excel. It would be nice to see more Excel functions used, though, beside basic tables and calculations.
Read full review
Usability
SAS
The overall usability of JMP is extremely good. What I really love about it is its ability to be useable for novices who have no coding experience, which is not the case with most other, similar, programs. It can output a fast and easy analysis without too much prior coding or statistical knowledge.
Read full review
Microsoft
Microsoft excel stands out in its User Interface as compared to any other software which offers same functionality. It can be used by a beginner as well as the expert in the same field. It is having many features as we dig deep in it like advance functions, dynamic arrays, pivot, VBA and Macros.
Read full review
Reliability and Availability
SAS
No answers on this topic
Microsoft
I have rarely, if ever, had issues with its availability.
Read full review
Performance
SAS
No answers on this topic
Microsoft
Again it does what I need it to do with little to no issues.
Read full review
Support Rating
SAS
Support is great and give ease of contact, rapid response, and willingness to 'stick to the task' until resolution or acknowledgement that the problem would have to be resolved in a future build. Basically, one gets the very real sense that another human being is sensitive to your problems - great or small.
Read full review
Microsoft
I have not had to use it often, but it is good.
Read full review
Online Training
SAS
I have not used your online training. I use JMP manuals and SAS direct help.
Read full review
Microsoft
No answers on this topic
Alternatives Considered
SAS
It is great because it has UI menus but it costs money whereas the other programs are free. That makes it ideal for beginners but I think that RStudio and Python are going to make someone a lot more marketable for future opportunities since most companies won't pay for the software when there is a great free option.
Read full review
Microsoft
We utilize Tableau and Alteryx in addition to Excel. We use Excel since we have a data dump that could be utilized in feeding for these two solutions. We select Excel for some manual work then plug the data into the other two tools for further analysis around text analytics like word clouds in Tableau, or text mining in Alteryx. Excel is an input data source that we use in conjunction with these two.
Read full review
Contract Terms and Pricing Model
SAS
No answers on this topic
Microsoft
N/A I was not involved in this process.
Read full review
Scalability
SAS
No answers on this topic
Microsoft
It integrates well with all cross functional teams
Read full review
Return on Investment
SAS
  • ROI: Even if the cost can be high, the insights you get out of the tool would definitely be much more valuable than the actual cost of the software. In my case, most of the results of your analysis were shown to the client, who was blown away, making the money spent well worth for us.
  • Potential negative: If you are not sure your team will use it, there's a chance you will just waste money. Sometimes the IT department (usually) tries to deploy a better tool for the entire organization but they keep using the old tool they are used too (most likely MS Excel).
Read full review
Microsoft
  • Excel has positively impacted the business as it has increased our efficiency.
  • It also saves us the time that we would have spent on making the calculations that it does for us.
  • Since it works on all devices and is compatible with both Windows and Mac, we do not have to invest in any other alternative.
Read full review
ScreenShots

JMP Statistical Discovery Software from SAS Screenshots

Screenshot of Graph Builder.Screenshot of Design of ExperimentsScreenshot of Hierarchical and KMeans clustering are available from the Multivariate platform.Screenshot of Scatterplot Multivariate AnalysisScreenshot of Survey Analysis