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
- :
- Discussions
- :
- Bivariate Histogram

Topic Options

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

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

Bivariate Histogram

Aug 9, 2016 4:25 PM
(4287 views)

Can JMP create a bivariate histogram of 2 data columns from a data set? I am thinking of something that creates graphs similar to those one can make in Matlab using the "hist3" command?

http://www.mathworks.com/help/stats/hist3.html

(see bottom figure in this link as an example of what I'm visualizing)

I don't necessarily need the fancy aspect viewpoint like shown in the figures from the Mathworks website. Having a top view with "counts" represented with color scale for the vertical dimension would be great.

Thanks

5 REPLIES 5

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

Re: Bivariate Histogram

hi joe.schaar@gmail.com,

if you just need a 2D version try heat map until someone gives the more comprehensive solution.

in graph builder put the two variables on the x and y axis and click the heat map button from the top menu.

best,

ron

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

Re: Bivariate Histogram

Thanks Ron. That is exactly what I was looking for!

An add-on question here...once I select a bin(s) from the heat map I see that the corresponding rows are selected within the originating data table as expected. Is there a way, separate from the obvious copy/paste approach, to a have only the selected data (both columns) populate a new data table?

-Joe

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

Re: Bivariate Histogram

Concerning your addon question:

If you go to the pulldown menu

Tables==>Subset

The platform comes up with the option defaulted to subset only the selected rows

Jim

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

Re: Bivariate Histogram

I think Ron's suggestion is great. You could also use the density plot option in Graph Builder if more definition would be helpful.

You could create something like this with the 3D scatterplot:

You need to first bin the variables and then create a table where you have frequency or N for each of the 2D bins. I did this by saving midpoints from the Distribution platform and then Table > Summary. There is probably a quicker way.

However, I can't see what this 3D plot gives you. Or the 3D plots in the link that you shared - in fact they are even worse because you can't see what is happening behind a peak. 3D plots only really work when you can spin them. Best not to add the 3rd dimension unless you have a really good reason. The colour in the above graph is probably not adding anything either!

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

Re: Bivariate Histogram

Phil,

Those are great suggestions, and I like the visuals. Thank you very much!

-Joe