summing transformed data issue

Disspair · Post by **Disspair** » Wed Mar 05, 2025 1:36 pm

Hi!
I'm currently trying to sum a lot of questions that have been transformed, taking it from a 1-4 scoring to "0" and "1" ("0" for numbers originally scored 1&2, "1" for scores of 3&4). For some reason it has converted the continuous data into nominal, and I believe this is causing issues with summing the data.
So far what I have done it try "SUM('Q1t','Q2t'...)" for all data points which did not seem to work. I tried changing the transform variable's measure type from nominal to ordinal to continuous to see if that would allow me to sum the data, and it hasn't. I also tried breaking it into smaller parts to sum the data (ie. doing 5/10 points at a time) but that hasn't worked.

Any help would be appreciated!

reason180 · Post by **reason180** » Wed Mar 05, 2025 10:24 pm

Hi. You cannot sum nominal data. Can you share what you did, exactly, that produced the nominal data? You'll need to do things differently so that those data never become nominal.

reason180 · Post by **reason180** » Wed Mar 05, 2025 11:01 pm

For example: If you specified "0" and "1" with quotes, that would produce nominal data. Alternatively, if you specify 0 and 1 without quotes, that will produce numeric data.

Post by **jonathon** » Thu Mar 06, 2025 12:20 am

actually, you can sum nominal data, provided it can be "cast" to numeric

: Screenshot 2025-03-06 at 11.19.28.png (75.17 KiB) Viewed 64133 times

: Screenshot 2025-03-06 at 11.19.04.png (67.53 KiB) Viewed 64133 times

reason180 · Post by **reason180** » Thu Mar 06, 2025 2:02 am

Yes, but it doesn't work if it's nominal text data . . .

: temp2Transform_0_1.png (53.6 KiB) Viewed 63949 times

jamovi