Depending on the version of SPSS, and the operating system that you're
using, copying (maybe copying as a table) should work, and then
pasting into Excel.
Alternatively, you can use syntax to turn the correlation matrix into
a data file, which you can then export to Excel.
Something like:
NONPAR CORR VARIABLES= a b c
/MATRIX=OUT(*).
To play around with syntax, just click paste, instead of OK. To get
the matrix into data, add the /MATRIX=OUT(*). line BEFORE the final
full stop.
If you're using an older version of SPSS (pre-13? I forget), you'll
need to make sure that you save your data before you run this, as it
will replace the dataset that you have open with the correlation
matrix. In newer versions, it opens another data file.
Jeremy
On 27/03/2008, Ioanna Vrouva <[log in to unmask]> wrote:
> Hallo,
> I would be grateful if any of you could help with this.
> I have a transposed SPSS dataset of rater's scores (in columns) and
> need to calculate their average agreement.
> The correlation matrix calculated in SPSS is quite large (100x100)
> and I was wondering if there is a way to export this correlation
> matrix to Excel, so that I can calculate the average of these correlations.
> thank you very much
> Ioanna
>
>
> ----------
>
> Ioanna Vrouva
> PhD Student
> Room 451a
> Sub-Department of Clinical and Health Psychology
> Department of Psychology, UCL
> 1-19 Torrington Place
> London WC1E 7HB
> Tel: 0207 679 8273
> Fax: 0207 916 1989
> Email: [log in to unmask]
>
--
Jeremy Miles
Learning statistics blog: www.jeremymiles.co.uk/learningstats
Psychology Research Methods Wiki: www.researchmethodsinpsychology.com
|