It's easy to do this one in Excel with the "countif" function but, How can define a column that counts the total specified values from other columns?
example: I have a table of the total answers, how can I count the right answer for each question?
| question | student 1 | student 2 | right answer | total answer |
| 1 | A | A | A | 2 |
| 2 | A | B | B | 1 |
| 3 | C | B | A | 0 |
thank you very much.
Here is one way to create the formula for this
Sum( :student 1 == :right answer, :student 2 == :right answer )
Many was to do this in JMP but they do differ from excel because JMP isn't a spreadsheet.
Some examples with formulas:
N Items(Loc(Words(:"student 1"n || :"student 2"n, ""), :"right answer"n));
N Items(Loc(Current Data Table()[row(), {"student 1", "student 2"}], :"right answer"n))
Datatables: Stack table with student columns:
Add formula to check differences between answer and and right answer:
Formula for Column 5:
If(:right answer == :Data,
1,
0
)
Create tabulate/summary (you might have to change the modeling type of question to Nominal or Ordinal):
