Forum Discussion

Peter Meinertzhagen's avatar
Peter Meinertzhagen
Copper Contributor
Jan 09, 2018

Help in compiling average ratings

Hi there,

 

I have a question about how to calculate average ratings for specific genres from a table of items with genre/rating. 

 

I have a table a bit like the below:

 

Movie Genre Rating
A Action 4.5
B Horror 2
C Action 5
D Comedy 5

 

I would like a separate table that calculates the average rating for a specific genre based on the info in the table, e.g. 

 

Genre Average
Action 4.75
Horror 2
Action 5
Comedy 5

 

How would I query this data to do the above?

 

Thanks!

excel
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 09, 2018
    This is perfect for a pivottable:
    - Select data
    - Insert, Pivottable
    - follow instructions
    - Drag Genre to row area
    - Drag Rating to Sigma area (bottom-right)
    - Right-click in the table on the right-hand column and choose "Summarize values By...", select "Average".

Resources