I'm having difficulty finding averages when some numbers in my data repeats over 9000 times. (Sorry, as I'm using google sheets and I'm unwilling to write the value 9989, 9049 times)
When finding an average, or average for standard deviations, or a dataset for IQR is it possible to write a value Nth number of times?
For instance:
11, 11, 11, 14, 15, 16 (repeated 65 times), 17, 18
or
9989^9049 (which isn't correct at all) just an example of how trying to display a single value.
Is there a simply way to calculate an average when you have several multiples of the same value?