Forum Discussion

bsong416's avatar
bsong416
Copper Contributor
Nov 17, 2020

Frequency Values Don't Appear in Cells Below

Hi there,

 

I'm a novice Excel user, so a little help would be very much appreciated. I'm just trying to calculate frequency under column D. My problem is that when I type the formula the only value that appears is in cell D2 with no values in the subsequent cells below in the column.

 

I'm sure it's not a big fix, but if anyone could point me in the right direction, I'd be thankful.

 

Note: I have tried dragging the cell down, but it gives me cumulative frequency value instead of the values for each of the bins. 

 

excel

3 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 17, 2020

    bsong416 

    Confirm the formula with Ctrl+Enter to enter it in all cells of the selection.

    By the way, I'd use =FREQUENCY(A2:A21,C2:C9) since your bins are in C2:C9.

    If you have ages over 10, select D2:D10, enter the same formula and confirm with Ctrl+Enter. D10 will contain the count of ages over 10.

    • bsong416's avatar
      bsong416
      Copper Contributor
      Nov 17, 2020

      HansVogelaar  appreciate the help! Was excited to try this out but it's only fixed the issue halfway. I'm getting values to appear, but the values are incorrect. 

       

      The values under the frequency column should be {0, 3, 3, 4, 3, 4, 3, 0} respectively.

       

      If you have any other suggestions, I'd be happy to test them out!

       

      Thanks gain!

       

Resources