I've got a big list of data that is split by industry, and 'keyword' within this. I'm trying to do an average per industry, as well as an average for overall, and wanted to check what is the most accurate way of finding averages here. I've checked other similar questions and couldn't quite be sure of the answer.
So I have data split as follows:
So the first Overall Average in the Score column is the average of all the numbers overall, the second is average after doing an average of each keyword, the third is the average of all the scores within an industry, and the final column is per keyword grouping per industry.
Obviously each of these comes up with a different average, but I want to be able to say:
- The average for finance is XX
- The average overall is XX
There will not necessarily be the same number within each industry or keyword.
Could you please let me know which way is the most acccurate to show an overall average, and an average of each industry?
Please let me know if that's not clear. Thank you in advance.