=correl({},{})

  • Thread starter Thread starter Yoshi Tucker
  • Start date Start date
Y

Yoshi Tucker

How can I enter arguments as ranges like A1:A100,B1:B100?
I need your help because I have several arrays to deal
with.
 
Yoshi,
You either type them (no need to bother to capitalize column letters)
=CORREL(A1:A100, B1:B100)
Or type =CORREL( and drag mouse over A1:A100, type , drag mouse over
B1:B100, type )
Or click on Function Wizard, fill in form
Bernard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help with countif formula 4
Excel Countifs/Sumproduct with mutil Or statement 3
Sumproduct function 10
Looping through permutations 7
Cross refrence an index table and sum in one step? 7
I WANT FORMULA 4
Calculating Averages - Very Complex PLEASE HELP 7
Efficient Array Formula Construction 8

Back
Top