Wonder if anyone could help me come up with a formula either in google sheets or open office to work out the mean from grouped data for example.
Score Number of People
0 - 4 0
5 - 9 0
10 - 14 0
15 - 19 2
20 - 24 4
25 - 29 2
30 - 34 10
35 - 39 10
40 - 44 23
45 - 49 25
50 - 54 33
55 - 59 32
60 - 64 41
So to work out the mean score if we take the last line it would be ((60+64)/2)*41 this would then need to be repeated for every row added together and divided by the number of people.
Any help appreciated
Score Number of People
0 - 4 0
5 - 9 0
10 - 14 0
15 - 19 2
20 - 24 4
25 - 29 2
30 - 34 10
35 - 39 10
40 - 44 23
45 - 49 25
50 - 54 33
55 - 59 32
60 - 64 41
So to work out the mean score if we take the last line it would be ((60+64)/2)*41 this would then need to be repeated for every row added together and divided by the number of people.
Any help appreciated