If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
spearman rank correlaiton coeffiecent on excel?
does excel perform the spearman rank correllation test?
|
#2
|
|||
|
|||
spearman rank correlaiton coeffiecent on excel?
tony -
If you browse to google.com and search for spearman rank correlation coefficient on excel? you'll get 38,300 hits. Have you tried that? (It helps if you spell "correlation coefficient" correctly.) - Mike www.mikemiddleton.com "tony" wrote in message ... does excel perform the spearman rank correllation test? |
#3
|
|||
|
|||
spearman rank correlaiton coeffiecent on excel?
The answer according to Sussex uin is no excel dosent calculate Spearman,
however their site, to which I was directed to on your advice expains how I can manipulate excel to perform the calculation; so thank you "Mike Middleton" wrote: tony - If you browse to google.com and search for spearman rank correlation coefficient on excel? you'll get 38,300 hits. Have you tried that? (It helps if you spell "correlation coefficient" correctly.) - Mike www.mikemiddleton.com "tony" wrote in message ... does excel perform the spearman rank correllation test? |
#4
|
|||
|
|||
spearman rank correlaiton coeffiecent on excel?
"tony" wrote in message
... The answer according to Sussex uin is no excel dosent calculate Spearman, however their site, to which I was directed to on your advice expains how I can manipulate excel to perform the calculation; so thank you "Mike Middleton" wrote: tony - If you browse to google.com and search for spearman rank correlation coefficient on excel? you'll get 38,300 hits. Have you tried that? (It helps if you spell "correlation coefficient" correctly.) - Mike www.mikemiddleton.com "tony" wrote in message ... does excel perform the spearman rank correllation test? I wonder why you would actually want to use the rank correlation method? I always thought it was a remnant of the days when more exact calculation was tedious but I'd be glad to be enlightened. -- James Silverton, Potomac, Maryland |
#5
|
|||
|
|||
spearman rank correlaiton coeffiecent on excel?
James -
I wonder why you would actually want to use the rank correlation method? Spearman's correlation is most appropriate when you want a correlation measure for two variables that are ordinal categorical measures (instead of numerical measures). For example, it may not make sense to arbitrarily assign numerical values (1,2,3,4,5) to ordinal responses on a survey questionnaire (Strongly Disagree, Disagree, Indifferent, Agree, Strongly Agree) I always thought it was a remnant of the days when more exact calculation was tedious but I'd be glad to be enlightened. Pearson's correlation (Excel's CORREL worksheet function) summarizes a linear relationship, so Spearman's correlation could be used to summarize a nonlinear relationship between two numerical variables. Also, Spearman's is not influenced as much by outliers. But, if you truly have a linear relationship between two numerical variables, you lose information if you convert the numbers to ranks before computing correlation. - Mike www.mikemiddleton.com |
#6
|
|||
|
|||
spearman rank correlaiton coeffiecent on excel?
Mike wrote on Mon, 8 May 2006 19:43:45 -0700:
?? I wonder why you would actually want to use the rank ?? correlation method? MM Spearman's correlation is most appropriate when you want a MM correlation measure for two variables that are ordinal MM categorical measures (instead of numerical measures). For MM example, it may not make sense to arbitrarily assign MM numerical values (1,2,3,4,5) to ordinal responses on a MM survey questionnaire (Strongly Disagree, Disagree, MM Indifferent, Agree, Strongly Agree) ?? I always thought it was a remnant of the days when more ?? exact calculation was tedious but I'd be glad to be ?? enlightened. MM Pearson's correlation (Excel's CORREL worksheet function) MM summarizes a linear relationship, so Spearman's correlation MM could be used to summarize a nonlinear relationship between MM two numerical variables. Also, Spearman's is not influenced MM as much by outliers. But, if you truly have a linear MM relationship between two numerical variables, you lose MM information if you convert the numbers to ranks before MM computing correlation. Thanks Mike, that does put things in a better perspective especially non-linearity and the effect of outliers. James Silverton. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
enable automatic refresh | Vass | Worksheet Functions | 2 | March 11th, 2006 04:36 AM |
Excel 5 and Excel 2000 question. | Naveen Mukkelli | General Discussion | 1 | March 3rd, 2006 09:05 AM |
Dynamic Excel chart in PowerPoint... | Rob | Powerpoint | 5 | November 5th, 2005 03:32 AM |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |