frequency

A

anna

I'm calculating the frequency of certain values of a
matrix. I got the results of the frequency (frequency
vector) on the data input window, but don't manage to get
this vector in my excel sheet. I tried to select a column
with n+1 cells (n = number of classes), but still, it only
writes one number (the frequency of my first class) in a
cell.
What do I have to do to get the whole vector?
 
A

Anon

anna said:
I'm calculating the frequency of certain values of a
matrix. I got the results of the frequency (frequency
vector) on the data input window, but don't manage to get
this vector in my excel sheet. I tried to select a column
with n+1 cells (n = number of classes), but still, it only
writes one number (the frequency of my first class) in a
cell.
What do I have to do to get the whole vector?

I assume you mean that you are using the FREQUENCY function?
When you selected the n+1 cells, did you remember to array-enter the formula
(using CTRL+SHIFT+ENTER)?
 

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

Top