Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jonathan
 
Posts: n/a
Default Statistical Function

I have two sets of data that I would like to put together into the function.,
First set would be (for example) A2:A6 and A25:A30 and use a stats function
(such as correlate) to B2:B6 and B25:B30. I want them joined together but
Excel won't let me. Help please.
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Use a nested IF to select the data
=CORREL(IF((ROW(A2:A30)6)*(ROW(A2:A30)<25),"",A2: A30),B2:B30)

Some functions, such as AVERAGE() support a syntax like
=AVERAGE((A2:A6,A25:A30),(B2:B6,B25:B30))
which is considered only 2 arguments (of compound arrays) rather than 4
arguments. Unfortunately this syntax does not seem to work with
CORREL(), PEARSON(), RSQ(), or even SUMPRODUCT() and {SUM(()*())}.

Jerry

Jonathan wrote:

I have two sets of data that I would like to put together into the function.,
First set would be (for example) A2:A6 and A25:A30 and use a stats function
(such as correlate) to B2:B6 and B25:B30. I want them joined together but
Excel won't let me. Help please.


  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Jerry W. Lewis wrote:

Use a nested IF to select the data
=CORREL(IF((ROW(A2:A30)6)*(ROW(A2:A30)<25),"",A2: A30),B2:B30)


I failed to mention that this must be array entered (Ctrl-Shift-Enter).

Jerry

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Averaging function Sarah Excel Discussion (Misc queries) 0 January 18th 05 05:09 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 02:00 AM
change function variable prompts?? thinkingfield Excel Worksheet Functions 1 November 8th 04 05:01 PM
Counting Function Dilemma Simon Lloyd Excel Worksheet Functions 0 November 8th 04 04:13 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 07:55 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"