Question

DATA:

Nursing	Psychology
Nervous	16	3
Excited	4	17

Required output for Chi square test is given as below and I need help inputting the data above into SPSS to achieve these results:

Observed Frequencies
	Column variable
Row variable	Nursing	Psychology	Total
Nervous	16	3	19
Excited	4	17	21
Total	20	20	40
Expected Frequencies
	Column variable
Row variable	Nursing	Psychology	Total
Nervous	9.5	9.5	19
Excited	10.5	10.5	21
Total	20	20	40

Data
Level of Significance	0.05
Number of Rows	2
Number of Columns	2
Degrees of Freedom	1
Results
Critical Value	3.841459149
Chi-Square Test Statistic	16.94235589
p-Value	0.0000385
Reject the null hypothesis

Answer 1

For doing your task in SPSS, first of all, set the given data as below:

Use code for the row as below:

1 for Nervous

2 for Excited

Use code for the column as below:

1 for nursing

2 for Psychology

Our data becomes:

Frequency	Nervous/Excited	Nursing/Psychology
16	1	1
3	1	2
4	2	1
17	2	2

Pair (1,1) or (Nervous, Nursing) have frequency 16.

Pair (1, 2) or (Nervous, Psychology) have frequency 3.

Pair (2, 1) have frequency 4.

Pair (2,2) have frequency 17.

So, input data in excel as below:

Pair (1, 1) appeared 16 times. (1, 2) appeared 3 times. (2, 1) appeared 4 times. (2, 2) appeared 17 times.

Nervous/Excited	Nursing/Psychology
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	1
1	2
1	2
1	2
2	1
2	1
2	1
2	1
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2
2	2

Then open SPSS, input above data, label variables, use codes for values for variable given as above.

Then click Analyze > Descriptive Statistics > Crosstabs > Enter Row and Column > Click Statistics > Check box for Chi square > Press OK

Required SPSS outputs are given as below: