Forum Discussion

REJrej's avatar
REJrej
Copper Contributor
Mar 22, 2023

Frequency calculation

I have a column of lengths which I wish to organise into a column of lengths with 0.5mm separation. I would like to have a step by step method to fill the frequency array from the data array using th...
Excel on Mac
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Mar 22, 2023

REJrej 

The FREQUENCY function in Excel is used to calculate how often values occur within a range of values, and then returns a vertical array of numbers.

Here are the steps to use the function:

  1. Enter your raw data into a row, column or combination or rows and columns.
  2. In a separate column, specify the intervals you want the FREQUENCY function to consider.
  3. Next to the intervals column, create an “Upper Limit” column that notes the upper limit of each interval.
  4. Create a “Frequency” column.
  5. Select the cells where you want the results to go.
  6. Switch to the “Formulas” menu and click the “More Functions” button.
  7. On the drop-down menu, point to the “Statistical” submenu, scroll down a bit, and then click the “FREQUENCY” function.
  8. Type in your data array and bin array separated by commas (e.g., =FREQUENCY(A1:A50,B1:B10)).
  9. Press CTRL+Shift+Enter (For Mac: Press Command+Shift+Enter) .

If you’re still getting 0 all down the results array, make sure that you have entered your data array and bin array correctly separated by commas in step 8 above.

Even though my knowledge of mac is limited, I hope this information has been of some help.

Resources