topic Counting the number of columns with specific value in Discussions

Counting the number of columns with specific value

Rini_Kar — Sun, 10 Sep 2017 08:14:36 GMT

Hi,

I have a data table with columns (around 60) representing the different question code and rows respresenting individual student id and their corresponding scores obtained for each questions. Each student was given a different set of booklets with different questions. The scores given for each question is either 0 (no credit) or 1(partial credit) or 2(full credit) and missing values for those question which a student did not get in his/her booklet. I would like to get the count of questions for which the score was not a missing value and > 0 (ie.,1 and 2) in a new column. Below is my sample data table.

CNTSCHID	CNTSTUID	GENDER	L6 - M00GQ01S	L2 - M033Q01S	L4 - M034Q01S	L3 - M155Q02C	L5 - M155Q03C
70200001	70205783	Male	0	1	0	1	0
70200001	70205411	Female	1	0	.	1	1
70200001	70205421	Male	1	.	0	2	1
70200001	70201886	Female	1	0	2	0	.
70200001	70206437	Female	1	1	2	2	1

Thanks in advance.

Re: Counting the number of columns with specific value

txnelson — Sun, 10 Sep 2017 13:12:15 GMT

To do this interactively I would do the following:

1. Go to

Tables==>Stack

2. Select all of the response columns as columns to be stacked.

3. Click on OK

4. In the newly created data table, go to the column named "Data" and find a cell with a "0" value.

5. Click on that cell to select it.

6. You indicated that you did not want to have any zero values counted, so now right click on the selected cell, and select "Select Matching Cells".

7. Go to the pull down menu "Rows", click on it and select "Delete Rows"

( You could repeat the same steps for the rows that have missing values, but since missing values are egnored by JMP platforms, it isn't necessary.)

8. Now to count the values, go to

Tables==>Summary

9. Select the column named "Data" for the statistic column, selecting "N" as the statistic to be calculated.

10. Select the column named "CNTSTUID" and place it in the Group selection box.

11. Click on "OK"

The new data table will give you a count for each student for the number of questions with responses greater than zero.

Re: Counting the number of columns with specific value

Rini_Kar — Sun, 10 Sep 2017 13:48:05 GMT

Thanks Jim. The solution is working perfectly with my data set