Columns for data in Three Way anova

Question

I have emotion response and preference response from normal hearing and hearing impaired people for both 28 piano and drum clips. I have two factors tempo of the songs and mode of the song (major or minor). I want to look at both the fixed effects of tempo and mode and the interaction effects on each of these groups.  I am using Three way anova with Tempo (continuous), Mode(Nominal) and Hearing ability (Nominal).

However, I am having issues creating a column for Hearing ability since my data as shown in attached figure. I would like to create a separate column as Hearing ability with labels (0-Normal hearing, 1-Hearing Impaired). However, My data for emotion and preference for Normal hearing and hearing impaired are in separate columns.

If I put all the data for emotion both groups in one column and label it as emotion then it is possible to create one column as Hearing ability but then I have to append column of tempo and mode with the 28 values appended.

How do i account for Hearing ability in my model and create it as a separate variable?

Screenshot 2019-07-23 at 9.36.22 AM.png

txnelson · Answer

I interpreted NH as Normal Hearing, and CI as Clinically Impared, and that you want to compare Tempo, Mode and Hearing Ability on the Emotional data, and then on the Piano Preferences.  If you want to treat CI independly from NH, then a different stacking would be what you need.

* Create 2 new columns, calling them Emotional and Preference 
* Fill all of the rows for column Emothional with "0"s
* Fill all of the rows for column Preference with "1"s
* Use the Tables==>Stack platform and select "Multiple series stack"
* Select Contiguous
* Place the columns NH Emotional Response...., NH Preference ..., CI Emotional Respnse....., CI Preference, Emotional and Preference into the Stack Columns selection box
* Change the Number of Series to 3
* Click on OK

The results should give you a data table you can analyze

2605 · Answer

I did the first two steps (shown in figure) and then followed the steps. I get the all the emotion data for both NH and CI in one column. And then I end up in doing analysis for all emotional data for tempo, hearing ability and mode. I want to do analysis separately for each group (NH and CI) for the three variables with interaction.

After Stacking.png

txnelson · Answer

I think this will do what you want:

* Create 2 new columns, calling them NH and CI 
* Fill all of the rows for column NH with "0"s
* Fill all of the rows for column CI with "1"s
* Use the Tables==>Stack platform and select "Multiple series stack"
* Select Contiguous
* Place the columns NH Emotional Response...., CI Emotional Response ..., NH and CI into the Stack Columns selection box
* Click on OK

The results should give you a data table you can analyze