freq table

[Mehdi Riazi]

Dear all,

I ran a freq on one of the variables in my data file and got the following table:

Task2

		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	5	74	28.6	28.6	28.6
	6	6	2.3	2.3	30.9
	6	92	35.5	35.5	66.4
	7	2	.8	.8	67.2
	7	85	32.8	32.8	100.0
	Total	259	100.0	100.0

Can somebody explain to me why I get separate freq for the same categories? (6 & 7)

Best;

Mehdi

--
Mehdi Riazi, PhD
Associate Professor & Director HDR

Department of Linguistics
Faculty of Human Sciences
Macquarie University NSW 2109

Room: C5A 575
Phone: [phone]
Fax: [phone]
www.ling.mq.edu.au

[MaxJasper]

I suspect your cat var is defined as text rather than numeric and then while typing in labels inadvertently a blank is added to 6 & 7 and so SPSS sees them as different categories.

 

Go to variables section and click and make this var as numeric and SPSS resets all 6b/b6 to 6 and 7b or b7 to 7 and then run freq.

 

Max.

 

Dear all,

I ran a freq on one of the variables in my data file and got the following table:

Task2

 

　		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	5	74	28.6	28.6	28.6
	6	6	2.3	2.3	30.9
	6	92	35.5	35.5	66.4
	7	2	.8	.8	67.2
	7	85	32.8	32.8	100.0
	Total	259	100.0	100.0	　

Can somebody explain to me why I get separate freq for the same categories? (6 & 7)

Best;

Mehdi

--
Mehdi Riazi, PhD
Associate Professor & Director HDR

Department of Linguistics
Faculty of Human Sciences
Macquarie University NSW 2109

Room: C5A 575
Phone: [phone]
Fax: [phone]
www.ling.mq.edu.au

---

[Jon K Peck]

Those values are not actually the same.  You are seeing the formatted representation, but if the two "6"s and two "7"s differ at all, they are considered different values for frequencies.  Try increasing the number of decimals (via the Data Editor( until you see the difference.  If you want to consider them the same, you might need to round the values in a transformation.

HTH,


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Mehdi Riazi <[hidden email]>
To:        [hidden email]
Date:        11/16/2011 06:39 PM
Subject:        [SPSSX-L] freq table
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,
I ran a freq on one of the variables in my data file and got the following table:

Task2

$B!! (B		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	5	74	28.6	28.6	28.6
	6	6	2.3	2.3	30.9
	6	92	35.5	35.5	66.4
	7	2	.8	.8	67.2
	7	85	32.8	32.8	100.0
	Total	259	100.0	100.0	$B!! (B

Can somebody explain to me why I get separate freq for the same categories? (6 & 7)
Best;
Mehdi

--
Mehdi Riazi, PhD
Associate Professor & Director HDR
Department of Linguistics
Faculty of Human Sciences
Macquarie University NSW 2109

Room: C5A 575
Phone: [phone]
Fax: [phone]
www.ling.mq.edu.au

[Mehdi Riazi]

Thanks to all. Jon's trick worked. :-) M

2011/11/17 Jon K Peck <[hidden email]>

Those values are not actually the same.  You are seeing the formatted representation, but if the two "6"s and two "7"s differ at all, they are considered different values for frequencies.  Try increasing the number of decimals (via the Data Editor( until you see the difference.  If you want to consider them the same, you might need to round the values in a transformation.

HTH,


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: <a href="tel:[phone]" target="_blank" value="[phone]">720-342-5621




From:        Mehdi Riazi <[hidden email]>
To:        [hidden email]
Date:        11/16/2011 06:39 PM
Subject:        [SPSSX-L] freq table
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,
I ran a freq on one of the variables in my data file and got the following table:

Task2

		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	5	74	28.6	28.6	28.6
	6	6	2.3	2.3	30.9
	6	92	35.5	35.5	66.4
	7	2	.8	.8	67.2
	7	85	32.8	32.8	100.0
	Total	259	100.0	100.0

Can somebody explain to me why I get separate freq for the same categories? (6 & 7)
Best;
Mehdi

--
Mehdi Riazi, PhD
Associate Professor & Director HDR
Department of Linguistics
Faculty of Human Sciences
Macquarie University NSW 2109

Room: C5A 575
Phone: <a href="tel:%2B61%2802%29%2098507951" target="_blank" value="[phone]">[phone]
Fax: <a href="tel:%2B61%2802%29%2098509199" target="_blank" value="[phone]">[phone]
www.ling.mq.edu.au