Accepted Solutions
@cradle
If you could post a sample (fake data table) that mimic your data table with fake patient ids and scores that would be great to help see how your data is layout. One way to do this is that you could highlight on the column with the score > right click (a drop down list of commands would appear) > select new formula column, select "aggregate", > select Mean.
This though will give you the aggregate mean score of for that column assuming all those score belongs to a single patient. I am not so sure that is what you want, but that fact is that JMP will use that formulation to calculate 1 mean score for all the different scores and that will appear in a separate column duplicated.
This can be used assuming that the test score is associated with just a single patient as the repeated column avg is total of all scores for that person. I don't think this is helpful in your specific case, but rather as ron_horne suggested, the Table > Summary is very unique to this kind of descriptive analysis. I do that with millions of customers with records and its pretty unique.
See information below how to use the Table Summary feature in JMP Pro 12.
Table Summar.
If just want to compute a single score for each individual for example, you can use the Table Summary feature in JMP.
Let say for this example, you have 14 records of 7 patients' test score with each patient having two scores and you just want to know the average score of each patient. Right?
# 1. Click on Table > Summary ( a drop down menu appears).
>>> # 1 leads you to the Summary Box
In the Summary dialog box, click on the Patient ID and click Group.
Click on the Test Score and Click the down arrow on "Statistics" and select Mean
Click Ok
Once you are okay with the selection above and click ok under Action in the Summary box above. JMP generates a new summary table with the averages for each unique record and also include the frequency/number of observation of each patient test record/score.
@cradle
If you could post a sample (fake data table) that mimic your data table with fake patient ids and scores that would be great to help see how your data is layout. One way to do this is that you could highlight on the column with the score > right click (a drop down list of commands would appear) > select new formula column, select "aggregate", > select Mean.
This though will give you the aggregate mean score of for that column assuming all those score belongs to a single patient. I am not so sure that is what you want, but that fact is that JMP will use that formulation to calculate 1 mean score for all the different scores and that will appear in a separate column duplicated.
This can be used assuming that the test score is associated with just a single patient as the repeated column avg is total of all scores for that person. I don't think this is helpful in your specific case, but rather as ron_horne suggested, the Table > Summary is very unique to this kind of descriptive analysis. I do that with millions of customers with records and its pretty unique.
See information below how to use the Table Summary feature in JMP Pro 12.
Table Summar.
If just want to compute a single score for each individual for example, you can use the Table Summary feature in JMP.
Let say for this example, you have 14 records of 7 patients' test score with each patient having two scores and you just want to know the average score of each patient. Right?
# 1. Click on Table > Summary ( a drop down menu appears).
>>> # 1 leads you to the Summary Box
In the Summary dialog box, click on the Patient ID and click Group.
Click on the Test Score and Click the down arrow on "Statistics" and select Mean
Click Ok
Once you are okay with the selection above and click ok under Action in the Summary box above. JMP generates a new summary table with the averages for each unique record and also include the frequency/number of observation of each patient test record/score.