| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CORREL versus COVAR/STDEV^2.......why different?
Hi everyone,
If you list a column of any data, try to calculate CORREL for same column (i.e., against itself), you get 1 (which is correct). Now, try to calculate COVAR for that column (also against itself), and STDEV. then try to get Correlation using COVAR/(STDEV^2) you don't get 1?! What is the problem here? Shouldn't both get you 1? Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Functions Correl and Pearson are identical | Excel Worksheet Functions | |||
| Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
| Can I "CORREL" statistical funtion with three or more Arrays? | Excel Worksheet Functions | |||
| Excel 2003 versus 2002 seem incompatible related to the EDATE fun. | Excel Worksheet Functions | |||
| CORREL versus r-squared | Excel Worksheet Functions | |||
Threaded Mode
