Statistical summary of bucketed data
I am a little unclear exactly what you are trying to do but I think you might
want a pivot table. You can place your values into the rows and calculate
your averages and standard deviations for each value.
--
HTH...
Jim Thomlinson
"vivmaha" wrote:
Hi,
I have two columns of data. The first contains a value, and the 2nd contains
the frequency of this value's occurance.
eg., The 1st 3 rows may look like:
Life Freq
1 4
2 6
3 10
.
.
.
I want to get excel to spit out summary statistics such as mean, std. dev.
etc.
I tried using the data analysis tool, but that works for a bunch of cells
that have the values, not value-frequency pairs. There are more that 1
million data points, so I don't want to create a new sheet and spit out all
the values as many times as they occur, and then use the data analysis tool.
Any suggestions?
|