I would like to calculate an average of the series based on the count.
Say, for example,
Series 1 (10 values): 5, 1, 2, 3, 4, 5, 4, 1, 2, 3
Average: 30 / 10 = 3
Series 2 (2 values): 3, 4
Average: 7 / 2 = 3.5
Series 2 has the higher average than series 1 but series attempted 10 times which is more than series 2 (2 times).
I need to find a formula to calculate the average based on the counts to make sure the values are perfectly averaged. Can anyone help me achieve this?