Difference between revisions of "Manuals/calci/FREQUENCY"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FREQUENCY'''('''d_arr''','''b_arr''') '''d_arr''' is an array of or reference to a set of values to count frequ...") |
|||
| Line 1: | Line 1: | ||
| − | + | =FREQUENCY(DataArray, BinArray)= | |
| − | ''' | + | *Where <math>DataArray</math> is an 'array of values' or 'reference to set of values' from which frequency of values is to be counted, and |
| + | *<math>BinArray</math> is an array or a reference to intervals in which values can be grouped. | ||
| − | + | FREQUENCY() calculates the number of occurrences within a range of values, and then returns a vertical array of numbers. | |
| − | + | == Description == | |
| − | + | FREQUENCY(DataArray, BinArray) | |
| − | |||
| − | FREQUENCY | + | *<math>DataArray</math> is an input array from which frequency of values is to be calculated. |
| + | *If <math>DataArray</math> does not contain values, it returns array of zeros. | ||
| + | *<math>BinArray</math> is an array of intervals in which input values are to be grouped. | ||
| + | *If <math>BinArray</math> has no values, Calci returns the number of values in DataArray. | ||
| + | *Blank cells are considered as zero value. | ||
| + | *Text values are ignored. | ||
| + | |||
| + | == Examples == | ||
| + | Below table shows the use of FREQUENCY function: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | 5 |
| − | + | | class=" " |10 | |
| − | + | | class=" " | | |
| − | | class=" | + | |
| − | | class=" | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 20 | |
| − | | class="sshl_f " | | + | | class=" " |30 |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | |
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 15.5 | |
| − | | class="sshl_f" | | + | | class=" " |50 |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 21 | |
| − | | class="sshl_f" | | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | |
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 0.3 | |
| − | | class="sshl_f" | | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | |
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 45 | |
| − | | class="sshl_f" | | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | |
| − | |||
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 38 |
| − | | class=" | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | -2 |
| − | | class=" " | | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | |||
| − | |||
|} | |} | ||
| − | < | + | =FREQUENCY(A1:A8,B1:B3) : Returns the frequencies as '''3'''(for values < 10), '''3'''(for values between 10 and 30), </ br>'''2'''(for values between 30 and 50), '''0'''(for values > 50). </ br>Displays '''3 3 2 0''' as a result. |
| − | + | =FREQUENCY(A1:A9,B1:B3) : Returns the frequencies as '''4'''(for values < 10, A9 is considered '0'), '''3'''(for values between 10 and 30), </ br>'''2'''(for values between 30 and 50), '''0'''(for values > 50). </ br>Displays '''4 3 2 0''' as a result. | |
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/COUNT | COUNT]] | ||
| + | *[[Manuals/calci/COUNTA | COUNTA]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Frequency Frequency] | ||
Revision as of 16:53, 27 March 2014
FREQUENCY(DataArray, BinArray)
- Where is an 'array of values' or 'reference to set of values' from which frequency of values is to be counted, and
- is an array or a reference to intervals in which values can be grouped.
is an 'array of values' or 'reference to set of values' from which frequency of values is to be counted, and
is an array or a reference to intervals in which values can be grouped.FREQUENCY() calculates the number of occurrences within a range of values, and then returns a vertical array of numbers.
Description
FREQUENCY(DataArray, BinArray)
- is an input array from which frequency of values is to be calculated.
- If does not contain values, it returns array of zeros.
- is an array of intervals in which input values are to be grouped.
- If has no values, Calci returns the number of values in DataArray.
- Blank cells are considered as zero value.
- Text values are ignored.
Examples
Below table shows the use of FREQUENCY function:
| 5 | 10 | |
| 20 | 30 | |
| 15.5 | 50 | |
| 21 | ||
| 0.3 | ||
| 45 | ||
| 38 | ||
| -2 |
=FREQUENCY(A1:A8,B1:B3) : Returns the frequencies as 3(for values < 10), 3(for values between 10 and 30), </ br>2(for values between 30 and 50), 0(for values > 50). </ br>Displays 3 3 2 0 as a result. =FREQUENCY(A1:A9,B1:B3) : Returns the frequencies as 4(for values < 10, A9 is considered '0'), 3(for values between 10 and 30), </ br>2(for values between 30 and 50), 0(for values > 50). </ br>Displays 4 3 2 0 as a result.