Thanks to Jay Wang and Ivan Zezula's ranking formulae (see "Rank Awful"
postings) I have produced an Excel spreadsheet to calculate both correlation
coefficients for Pogo's data.
1. I have two sets of scores which are related to each other.
SET A
I guess "nice" is in the eye of the beholder. I view this as
another good reason NOT to use Excel for Statistics!
Please use the right tool for the job.
Jon Cryer
Sometimes the right tool for the job is Excel. Most of my students will not
have access to specialist statistical software
i would like to comment on this ... without getting anyone mad at me. i
have heard this argument many times before but ... i think that if we
promulgate this ... what it means is that we are not doing our students any
favors ... i don't view some general stat package as a "specialist" package
...