Syntax
=FREQUENCY(data_array, bins_array)Arguments
| Argument | Required | Description |
|---|---|---|
data_array | Required | The values to count |
bins_array | Required | The upper limits of the bins |
How to use FREQUENCY
When FREQUENCY returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
FREQUENCY takes 2 required arguments. Type =FREQUENCY( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=FREQUENCY({79,85,78,85,50,81,95,88,97}, {70;79;89})Result Spilled result
| A | |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 4 |
| 4 | 2 |
Related statistical functions
- FORECAST.ETS.CONFINTReturns the half width of the confidence interval around a FORECAST.ETS prediction.
- FORECAST.ETS.SEASONALITYReturns the length of the repeating pattern detected in a time series (1 when there is none).
- FORECAST.ETS.STATReturns a statistic of the exponential smoothing model: 1 alpha, 2 beta, 3 gamma, 4 MASE, 5 SMAPE, 6 MAE, 7 RMSE, 8 step size.
- FORECAST.LINEARPredicts a value for x from the straight line that best fits known x and y values.
- GAMMAReturns the gamma function value.
- GAMMA.DISTReturns the gamma distribution.
- GAMMA.INVReturns the inverse of the cumulative gamma distribution.
- GAMMALNReturns the natural logarithm of the gamma function.
- GAMMALN.PRECISEReturns the natural logarithm of the gamma function.