3 Replies Latest reply on Nov 8, 2019 10:08 AM by Subodh Gupta

    Average Number of Records by Group

    Laurel Ayuyao

      Hi,

       

      I am working with a data set from the National Science Foundation that has information on grants from the past few years.

      I am trying to create a bar chart that shows the average number of awards for each type of institution.

      Screen Shot 2019-11-08 at 12.19.51 PM.png

      This is what happens when I try to put [Type] and AVG[Number of Records] into the sheet, but it is obviously wrong because it shows 1 for each group.