| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Correlations, Group By Type?
I have data for several different types of land
Variable1 Variable2 Variable3 TypeOfLand 30 250 300 Desert 40 670 200 Forest 10 30 400 Forest 20 500 800 Arctic 20 180 270 Desert .... I'd like to know if there's a way using PivotTables or any other function to product the following automatically CorrelationBetweenVar1and2 CorrelationBetweenVar2and3 CorrelationBetweenVar1and3 Desert Forest Arctic Swamp Lakeside .... In other words, I'd like to run a correlation between two variables, but I'd like for it to be grouped by type. Will be very grateful for any input! Regards, Sak |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Correlations, Group By Type?
Use this array formula as a template
=CORREL(IF(Land="Arctic",Variable1),IF(Land="Arcti c",Variable2)) or see: http://www.savefile.com/files/1686640 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Correlations, how do I graph one? | Charts and Charting in Excel | |||
| Excel should allow correlations of data so chart markers match up | Charts and Charting in Excel | |||
| Multiple Correlations and Multicollinearity | Excel Worksheet Functions | |||
| Partial correlations | Excel Discussion (Misc queries) | |||
| creating groups based upon correlations | Excel Worksheet Functions | |||
Linear Mode
