Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- JMP is Not a Spreadsheet

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

Maybe one more way to help facilitate JMP adoption is to install the JMP add-in in MS Excel. It talks to JMP and has analysis icons from JMP within Excel, so that helps for people who really can't relinquish Excel. Excel is a wonderful tool as well and can complement and even supplement certain analyses in JMP where certain calculation options, for example, are not available. One simple example would be a test for equivalence under the assumption of unequal variance (which to my knowledge is not available in JMP). You can build an Excel spreadsheet for this spreadsheet in the special case of for example: if you were to find evidence to reject the assumption of unequal variance using the hypothesis tests for equal variance output.

Highlighted
##

If your talking about test for equivalence of means allowing unqual variances, I believe the can be done, but "indirectly". Equivalence test of means (as, say 95% level) is given by (90%) confidence interval for difference in means. Believe the t-test in the Fit Y by X platform gives that confidence interval allowing unequal variances,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

Thanks @Paul_J, you are right in that I could pull the CI from the 2 sample t-test assuming unequal variances within the Fit Y by X Platform and Compare it to zero to assess the statistical significance (or lack thereof).

What I'm actually talking about is the Equivalence test using TOST (two one-sided t-test approach) where you have to specify a practical difference threshold that defines the maximum difference on average, allowable between groups to be considered not practically important (and by default, that difference is symmetric about zero). For that particular method, there is no option for "unequal variances": the default is equal variance assumed.

What I'm actually talking about is the Equivalence test using TOST (two one-sided t-test approach) where you have to specify a practical difference threshold that defines the maximum difference on average, allowable between groups to be considered not practically important (and by default, that difference is symmetric about zero). For that particular method, there is no option for "unequal variances": the default is equal variance assumed.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

Indeed, I've had quite a bit of success with the Graph Builder, ... as well as Control Chart Builder and Local Data Filter. Many Excel users love the "pivot table feel" with power of graphics.

Another sucess I've had at showning value is replacing hours of manal copy-paste and cell formulating in Excel with seconds via a JMP script.

The Help and Books are great also!

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

@Paul_J, this is a key observation. The table manipulation and automation makes tasks that are ridiculously complex or difficult in Excel very fast, easy and reproducible. It opens the door to getting to the analysis you wanted to do, but were too exhausted to even start before.

Another @Patrick GIULIANO mentioned indirectly is that in Excel one needs to become an expert in creating a number of difficult and complex data structures, for each graph and summary table type, where in JMP there are really only one or two data structures that are nearly universal for every graph and analysis report. (one observation per row, one variable per column)

Another @Patrick GIULIANO mentioned indirectly is that in Excel one needs to become an expert in creating a number of difficult and complex data structures, for each graph and summary table type, where in JMP there are really only one or two data structures that are nearly universal for every graph and analysis report. (one observation per row, one variable per column)

JMP Systems Engineer, Pharm and BioPharm Sciences

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

Created:
Jan 29, 2020 7:17 PM
| Last Modified: Jan 29, 2020 7:18 PM
(1805 views)
| Posted in reply to message from Byron_JMP 01-29-2020

That's true! Also the syntax for conditional logic statements in JMP column formulas is WAY more intuitive than in Excel. I can write conditional statements with very complex logic using JMPs graphical display dialogue (with JSL embedded underneath) and in this way confidently create new column formulas to help me manipulate and gain greater insights from my data.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

Created:
Jan 16, 2020 9:53 AM
| Last Modified: Jan 16, 2020 9:56 AM
(1947 views)
| Posted in reply to message from markbailey 06-24-2019

Good stuff Mark. I think this is a challenging thing for some of the larger companies when they get their hands on JMP. The challenge may be one of communication. Folks come to them and say "hey, JMP is a great way to analytics better than what you are doing in Excel", which is very true, mostly, with the important caveats that JMP is not a spreadsheet and there are certain things that are much better to do in a spreadsheet.

But what the company may hear is "I can do everything I did in Excel better in JMP". I believe that this can result in some serious deployment heartburn as folks are tasked with transitioning things out of Excel into JMP when Excel still sits as the more fit-for-purpose tool.

One example from my own experience is discreet event simulation. Now if I'm doing any kind of heavy duty work there is more appropriate software for it, but for low-end back of the envelope queuing models I go straight to a spreadsheet program.

Monte-carlos in general I find to be somewhat evenly split. There are a lot of places where it's small enough I don't need to go to Python, but it's complex enough that its much easier to do it in a spreadsheet software than in JMP.

Linear programming as well. If it's a lightweight model I'm gonna run that in spreadsheet software. I'm not even certain JMP has that capability.

The best way to summarize the difference in my opinion is this: JMP is one of the best tools out there for doing a specific set of tasks, but it is not intended for everything. Excel is is a tool that can do entry level work on almost any task. Or, maybe: JMP can do a few things excellently. Excel can do everything poorly.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

Created:
Jan 17, 2020 11:05 PM
| Last Modified: Jan 17, 2020 11:06 PM
(1926 views)
| Posted in reply to message from Evan_Morris 01-16-2020

Maybe JMP is a spreadsheet? Or at least it can be! What I've been doing of late is just using the cell shading (dark blue) to "hide" duplicated calculations that I am performing which automatically duplicate in all the rows of a given column. Works pretty well! Only thing I wish was that it was even easier to access column formulas than it is currently. Maybe instead of a couple clicks it could be accessed and you could be taken there directly with a single right click or some other shortcut. The handy thing about Excel is the ability to readily enter column formulas. JMP you can do the same once you get in there to the formula editor and you can even use the JSL, but it takes some time to even access the formula editor, especially if you're doing this for multiple columns in one data table.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

In the column box, a single click on the "+" icon brings up the formula editor.

Once the developers get the neural natural language processor bluetooth head band working again, it will just open when you think about it. They had it working a while back but it was too early. I installed Windows NT and version 4.7 to try it out. It was pretty amazing but the batteries were kind of heavy and I kept falling over backwards.

JMP Systems Engineer, Pharm and BioPharm Sciences

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JMP is Not a Spreadsheet

I have visions of Doc Brown in "Back to the Future".

Article Labels

There are no labels assigned to this post.