I have a frequency distribution of a five point scaled question. The data is
not in raw form....just columns of responses....but a set of frequencies
As=22, Bs=13, Cs=24 etc.....if I had a column with 22 As, 13 Bs and 24 Cs I
would just use the Average calculation to calculate the mean of this data.
Short of entering 22 As into the column followed by 13 Bs etc....how can I
calculate a mean. I'm using Excel 2000