Frequency function
Posted by Lynda on January 22, 2002 1:41 PM
I seem to be having some problems getting the results I need using the Frequency Function. I enter my Data array (Do I need to make the rows absolute?) and the bin array (Only the range of the values, not where I need the results printed?) and do not get the appropriate answers. And why does it not give me results for all the values? Do I have to copy this? I didn't have to when I used Lotus!
Posted by Mark W. on January 22, 2002 2:17 PM
Can you provide/describe some sample data? [nt]
Posted by Lynda on January 23, 2002 4:50 AM
Yes. Say in Range A1:A10 you have a list of grades and you want to determine how many A's, B's etc. In Range D1:D5 are the cut off's for the grades-- 70, 77, 85, 93, 100. I want the number of A's etc. to be in Range E1:E5. Does this help?
Posted by AB on January 23, 2002 5:31 AM
FREQUENCY is an array function.
My guess is that you are simply entering the FREQUENCY function in a single cell and perhaps trying to copy it, in which case, it won't work.
Select a range of cells equivalent to the number of bins you've chosen plus one and then enter the FREQUENCY function and use CTRL-SHIFT-ENTER to make the formula work.
Posted by Juan Pablo G. on January 23, 2002 6:34 AM
Lynda,
In E1:E5 array enter (Control Shift Enter)
=FREQUENCY($A$1:$A$10,$D$1:$D$5)
The cutoffs (In D1:D5) need to be the LOWER LIMIT of each range, ie, if F goes from 0 - 70, E, 71 - 77, D, 78 - 85 and so on, you should have in D1:D5
0
71
78
Juan Pablo G.
Juan Pablo G.
Posted by Juan Pablo G. on January 23, 2002 6:40 AM
Sorry, this should read the UPPER LIMIT (Not Lower), so D1:D5 should read
70
77
85
93
100
Juan Pablo G. Lynda, In E1:E5 array enter (Control Shift Enter) =FREQUENCY($A$1:$A$10,$D$1:$D$5) The cutoffs (In D1:D5) need to be the LOWER LIMIT of each range, ie, if F goes from 0 - 70, E, 71 - 77, D, 78 - 85 and so on, you should have in D1:D5 0
Posted by Lynda on January 23, 2002 6:46 AM
Thank You for the suggestions--I off to try them. Doesn't seem as easy as Lotus!
