Hello All! New JMP user here with a Tabulate question. I am trying to achieve a data table look that I have been familiar with up to this point which looks similar to the below: Group 1Group 2Base Size300300ABAge18-24 10%25%A25-3420%20%35-4430%30%45-5420%15%55+20%B10% So far I am having luck developing the general look of a table like the above excluding the stat testing. My question is, can I create a table like the above in JMP? If so, can someone point me towards a resource that goes through the steps?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Stat Testing and Data Tables

mcstagger

Hello All!

New JMP user here with a Tabulate question. I am trying to achieve a data table look that I have been familiar with up to this point which looks similar to the below:

	Group 1	Group 2
Base Size	300	300
	A	B
Age
18-24	10%	25%A
25-34	20%	20%
35-44	30%	30%
45-54	20%	15%
55+	20%B	10%

So far I am having luck developing the general look of a table like the above excluding the stat testing.

My question is, can I create a table like the above in JMP? If so, can someone point me towards a resource that goes through the steps?

Accepted answers

jules

Hi mcstagger,

My apologies for not interpreting correctly, you want that table exactly! Tabulate is powerful, but you won't be able to move around the sections to make exactly that table. Tabulate is also not built for doing analyses, only tabulating. If you wish to reveal the contingency test, you will need to use Analyze > Fit Y by X, or Analyze > Consumer Research > Categorical. Each of those platforms will make a table close to what you want, but not exactly I'm sorry to say. In case it helps, here is the set up for both of those platforms.

I'm sorry I don't have steps to make that exact table, but I hope this gets you a little bit closer.

Julian

All comments

jules

Hi mcstagger,

Using tabulate you can make a table very much like the one you have posted. The exact steps depend on how your original data table is structured. Would you be willing to post your data, or some sample data with the same format? If so, I would be happy to write out some steps.

Julian

mcstagger

Julian,

Could we use a sample data set provided with JMP?

Using the attached with "Gender" as our banner and "Goals" as our stub should work.

Thank you for the assistance Julian.

Childrens Popularity.jmp

jules

Hi mcstagger

Of course. Here's a quick video of the steps I would go through to make that sort of table. Does this get you to where you want?

I hope this helps!

Julian

stan_koprowski

Hello,

Alternatively, if you are using JMP 11 you could use the Categorical platform under the Consumer Research menu.

Using the Children's Popularity data table and using the breakout and stub you suggested will produce the following:

7380_Screen Shot 2014-10-06 at 3.20.09 PM.png

Best,

Stan

mcstagger

Julian,

What you have shown me is pretty much where I have been able to get. The pieces that I am looking for now are:

Getting the column base size to show up above the column it represents, i.e. Male (n=227) and Female (n=251)
Stat testing between column A (males) and B (females)

mcstagger

Stan,

Thank you for helping out as well. Please see my latest response to Julian. What I am looking for is more consistent formatting to what I had initially posted, along with the steps, if possible, to show column stat testing.