Ordinal Ranking significance

#1
Right guys, this should be a no-brainer for those tuned into SPSS, regression and correlation. I've been trying to work this out all week and in my desperate state am turning to you :(

Here is a description of my data:

I conducted a questionnaire and asked participants their preference of product (4 possibilities):

Product1,
Product2,
Product3, or
Product 4.

So each case has i.e.:

Age | Preference
23 | Product2

Now. I've actually asked for their preference for TWO given tasks, so we end up with TWO ratings columns:

Age | Question1 | Question2
23 | Product2 | Product1

My Question:

How do I perform a test of significance of the most frequently rated product

(1) For each question. :confused:
(2) Globally. For for both questions. :confused:

So that I'm clear on this, I've attached the data (to save you having to open the file, I've pasted the contents at the bottom of this message). It's a small poll, only 23 participants. You'll see that for Q1 Product2 is rated more frequently and for Q2 Product1 is rated more frequently.

Only thing I ask is that you try and get back to me as soon as possible

Several thanks in advance

:wave:


----file start----

Age, Q1, Q2
19, 1, 1
20, 2, 3
65, 2, 1
65, 2, 1
29, 2, 2
25, 2, 1
25, 1, 3
24, 1, 1
25, 1, 2
23, 1, 2
24, 1, 1
24, 3, 4
27, 3, 3
28, 2, 1
30, 2, 3
25, 2, 1
24, 4, 3
26, 3, 4
26, 2, 1
27, 1, 4
29, 1, 1
30, 2, 4
31, 3, 1

----file end----
 
Last edited: