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

- JMP User Community
- :
- Discussions
- :
- Comparisons of several groups within categories

- 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

Apr 5, 2020 10:39 AM
(1639 views)

I have data from 260 individuals. In 1 row the persons are ceategorized into male or female.

Within each gender, there is another coloums categorizing individuals into children, adolescents, adults, elderly.

And then there are coloums With measured parameters, e.g food intake, intake of energy etc.

How do I compare the measured parameters between age categories from each gender?

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

You should be able to do the separate analyses you are mentioning "male and female adolescent, male and female elderly etc", by specifying those columns as "By" columns in the analysis and graphical platforms you are running. The example below adds "Age" and "Sex" to a simple Fit Y by X for "Height" vs. "Weight"

,

and it produces the output for each combination of sex and age

Jim

8 REPLIES 8

Highlighted
##

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

Re: Comparisons of several groups within categories

your description of your data, I believe the below is representative of what the structure is like?

If this is so, I think what you need to do, is to start off with the Distribution Platform, learning about the distributions of the data. Are there any unusual issues? I would then list out the questions about the data that you want answered. Once you get to that point you may see what you need to do to answer the questions. At least, you will be able to as the Community, a more specific question.

Jim

Highlighted
##

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

Re: Comparisons of several groups within categories

Well, "it depends" on so many questions. But to get you started:

1. Use graph builder to build charts (nest the descriptors: Graph Builder Documentation on Nested Axes)

2. You can select both descriptor columns, right click, select new formula, character, concatenate with a space to build a new column that contains a column with the two level description (Documentation on new formula column from right click)

3. Use Fit Y by X with a by variable (Documentation on One Way analysis )

4. Use Fit Model (Documentation on fitting linear models )

5. Potentially use the consumer research categorical platform - depends on what types of responses you have.

Highlighted
##

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

Re: Comparisons of several groups within categories

Hi thanks for the answer.

I know the data are not normally Distributed and non-Parametric tests have to de bone

I have compared the data for gender.

And I have also plotted and compared data for different age Groups (categories).

But then I would like to divide the data into age categories AND gender at the same time and have not figured out how to do this in JMP without splitting the data into one file for male and one for females

Gunnar

I know the data are not normally Distributed and non-Parametric tests have to de bone

I have compared the data for gender.

And I have also plotted and compared data for different age Groups (categories).

But then I would like to divide the data into age categories AND gender at the same time and have not figured out how to do this in JMP without splitting the data into one file for male and one for females

Gunnar

Highlighted
##

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

Re: Comparisons of several groups within categories

Created:
Apr 6, 2020 12:27 AM
| Last Modified: Apr 6, 2020 2:39 AM
(1600 views)
| Posted in reply to message from KarenC 04-05-2020

Highlighted
##

Hi thanks for the answer.

I know the data are not normally Distributed and non-Parametric tests have to de bone

I have compared the data for gender.

And I have also plotted and compared data for different age Groups (categories).

But then I would like to divide the data into age categories AND gender at the same time and have not figured out how to do this in JMP without splitting the data into one file for male and one for females

Gunnar

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

Re: Comparisons of several groups within categories

I know the data are not normally Distributed and non-Parametric tests have to de bone

I have compared the data for gender.

And I have also plotted and compared data for different age Groups (categories).

But then I would like to divide the data into age categories AND gender at the same time and have not figured out how to do this in JMP without splitting the data into one file for male and one for females

Gunnar

Highlighted
##

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

Re: Comparisons of several groups within categories

Yes this is quite similar to what the data look like. And I know the data is not normally distributed. I have compared the data between gender and between age Groups, but I would like to find out how to compare for example male and female adolescent, male and female elderly etc. DO I need to make subgroups and new files or is it an easier way to do this?

Highlighted

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

You should be able to do the separate analyses you are mentioning "male and female adolescent, male and female elderly etc", by specifying those columns as "By" columns in the analysis and graphical platforms you are running. The example below adds "Age" and "Sex" to a simple Fit Y by X for "Height" vs. "Weight"

,

and it produces the output for each combination of sex and age

Jim

Highlighted
##

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

Re: Comparisons of several groups within categories

After using the fit X by Y function , the kcal intake as response, the age category as X factor and sex in the BY function, I have now got 2 graphs like the one below, one for the male and one for female.

What I wanted to do was to have all the Groups in the same figure and be able to compare them also by Wilcoxio tests

Article Labels

There are no labels assigned to this post.