zoharb
New Member
- Joined
- Nov 24, 2011
- Messages
- 40
- Office Version
- 2021
- 2013
Respected ,
Needs to understand how to use CORREL -correlation function of excel (or any way other way) to find correlation between 4-5 data arrays which are in seperate column and cant be selected in one array as intermediate columns are not to be considered.
Example:-
level of reservoir 1,reservoir 2, reservoir 3, reservoir 4, reservoir 5 has to be considered
which are in column E, column J, column o, column T, column Y
but the contents of inbetween columns(open , high, low, Quantity) has not to be considered.
(also in another instance it has timestamp ,incoming Quantity/time, Pressure)
Please HELP.
Also posted a month ago @ CORREL-to find correlation between 4-5 data arrays - OzGrid Free Excel/VBA Help Forum
Zohar Batterywala
Needs to understand how to use CORREL -correlation function of excel (or any way other way) to find correlation between 4-5 data arrays which are in seperate column and cant be selected in one array as intermediate columns are not to be considered.
Example:-
level of reservoir 1,reservoir 2, reservoir 3, reservoir 4, reservoir 5 has to be considered
which are in column E, column J, column o, column T, column Y
but the contents of inbetween columns(open , high, low, Quantity) has not to be considered.
(also in another instance it has timestamp ,incoming Quantity/time, Pressure)
Please HELP.
Also posted a month ago @ CORREL-to find correlation between 4-5 data arrays - OzGrid Free Excel/VBA Help Forum
Zohar Batterywala
Attachments
Last edited by a moderator: