JMP software, provided by SAS Corp., is a statistics / data analysis package used by both individuals and corporations. License holders may e-mail the supplier with queries about technical issues or questions about how to use the JSL scripting / macro language that is supplied with the software.
JMP Statistical Analysis Software Features
JMP supports most statistical analysis methods such as Design of Experiments (DOE), sample size calculations, and significance testing. It also allows data to be imported from external sources such as Oracle tables or Excel spreadsheets. Another very useful feature of JMP is that it allows scripts / macros to be recorded and programmed, so that repetitive tasks may be performed with the click of an icon.
JMP Statistics Software Data Collection
Although some functions do not require data to start with, such as sample size calculations, data usually need to be available before they may be analysed, and JMP allows several ways to be used to provide data:
- Manually enter data on to a blank JMP worksheet
- Open data in another file format such as Excel, Minitab, SAS, htm, dBase, Foxpro, or CSV etc
- Import the data directly from another data source by "programming" a script in JSL
JMP Statistics Software Data Analysis
Statistical analysis is the main reason why JMP software is purchased. JMP provides a wide range of features that include:
- Sample size calculations - for means, variance / standard deviation, proportions and others.
- Design of Experiments (DOE) - using Taguchi, full factorial, fractional and other designs, including augmented and blocked designs.
- Inference testing and confidence intervals - for means, variance / standard deviation, proportions and others.
- JMP also provides non-parametric tests for non-Gaussian (non- Normal) distributions, as well as the facility to check for Normality.
JMP Statistics Software Data Graphing and Summary
Graphing is an integral part of the statistical testing suite in JMP. Graphing options include pie charts, pareto plots, bivariate, regression and others. Like most of the options in JMP, graphing may be recorded or programmed in a script for repeated use.
JMP Statistical Software Scripting Language JSL - Data Importing, Graphing and Analysis
Tasks that are time-consuming and that need to be repeated at regular intervals, may be written into JSL script code and then "called" when needed. SQL queries are supported. Some examples are shown here.
To extract data from the sheet called "Sheet1" in the Excel spreadsheet "myfile.xls" and create a JMP sheet called "Result":
dt=Open Database("DSN=Excel Files;DBQ=c:\myfile.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=5;","SELECT * FROM `Sheet1$`" , "Result" );
To extract one days data for customer "ABC" from an Oracle database "mytable", that exists on server "myserver", and store the results in a JMP file called "myresults", using a JMP script:
dt=Open Database("DRIVER={Microsoft ODBC for Oracle};UID=myname;SERVER=myserver;PWD=mypasswd;","SELECT * FROM mytable WHERE CUSTNAME='ABC'","myresults");
JMP statistical analysis may also be automated. To produce a one-way ANOVA of a measured variable myAVG, in a table called MEAS_DATA, for a group of machines in the field myMACH, by a date field called myDATE, and show the means, standard deviations, and mean diamonds (with 95% confidence intervals), the following could be used:
Dt=DataTable("MEAS_DATA");
Oneway(Y( :myAVG), X( :myMACH), Means(1), Means and Std Dev(1), Each Pair(1), Box Plots(0), Mean Diamonds(1), Comparison Circles(1), X Axis proportional(0), Grand Mean(0), by(:myDATE) );
JMP Statistical Analysis Software Summary
JMP software is a powerful tool with which to collect, analyse, and graph data. The script language JSL may be used to automate laborious and repetitive processes. A comprehensive help manal and on-line support is also available. One disadvantage of JMP software is that it allows the user to do statistical tests that are inappropriate, and that could produce misleading results. For that reason, it needs to be used by competent statisticians.
JMP Statistical Analysis Software References
JMP Start Statistics: A Guide To Data Analysis and Statistics, 4th Ed, (SAS Press Series)
Martin Bell - Martin holds a B.Sc. degree in chemical engineering, and an M.Sc. degree in electronics and computing. He has spent more than 25 years ...
Join the Conversation