| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I generate an array of correlated values
I want to generate a column of 3 CORREL values.
Each CORREL value will be derived by CORREL(A=1x4 array, B=3x4 array) Can I do this by functions without using macros? Should be generic enough. Example: A=(10, 20, 30, 40) B=(B1, B2, B3) B1=(11, 12, 13, 14) B2=(15, 16, 17, 18) B3=(19, 20, 21, 22) Result = (CORREL(A,B1), CORREL(A,B2), CORREL(A,B3)) |
|
#2
|
|||
|
|||
|
vishs -
Perhaps you could use the Correlation data analysis tool. - Mike www.mikemiddleton.com I want to generate a column of 3 CORREL values. Each CORREL value will be derived by CORREL(A=1x4 array, B=3x4 array) Can I do this by functions without using macros? Should be generic enough. Example: A=(10, 20, 30, 40) B=(B1, B2, B3) B1=(11, 12, 13, 14) B2=(15, 16, 17, 18) B3=(19, 20, 21, 22) Result = (CORREL(A,B1), CORREL(A,B2), CORREL(A,B3)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| Keeping Array values? | Excel Worksheet Functions | |||
Linear Mode
