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
- :
- how to create average data from several rows?

Topic Options

- 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
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 5, 2011 1:47 AM
(2967 views)

Hi, I have groups of mice, with tumours. Each group gets a specific treatment and tumour growth is measured daily. At the end of the experiment I have data for 3-4 groups, each group consisting of 4-5 mice, how do I create a graph of the data with one line for each group using the average daily measurements for the groups as the points on the lines?

here is part of the table:

where there are four members to each treatment group (with their order changing randomly each day) and a set of measurements for each day (d20, d21, d22 etc)

I need to plot the line for the averages (with error bars) like you can do in prism (my supervisor wants me to use jmp)

thanks for the help

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 7, 2011 7:12 AM
(4701 views)

Solution

To perform analysis on your data, JMP needs the data organised 1 column per variable. So your first step is to restructure your data so that you have a single column containing all tumour growth data (and one column for day). To do this use the Stack command on the Tables menu and stack all the "d" columns:

This will give you a table organised like this:

If you want to generate summary stats (means and standard deviations) for each group for each day you can use the Summary command on the Tables menu:

Alternatively, if you want to graph the data with error bars, the Chart option under Graphs will perform the graphical equivalent of the Summary command:

-Dave

-Dave

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 7, 2011 7:12 AM
(4702 views)

To perform analysis on your data, JMP needs the data organised 1 column per variable. So your first step is to restructure your data so that you have a single column containing all tumour growth data (and one column for day). To do this use the Stack command on the Tables menu and stack all the "d" columns:

This will give you a table organised like this:

If you want to generate summary stats (means and standard deviations) for each group for each day you can use the Summary command on the Tables menu:

Alternatively, if you want to graph the data with error bars, the Chart option under Graphs will perform the graphical equivalent of the Summary command:

-Dave

-Dave