histogram analysis
I have large data sets with frequencies already determined. Column 1 is the
'bin' value; column 2 is the frequency which that bin value appears in the
data set. There are 200-300 bin values; frequencies range from 0 to 500.
Total frequencies (total data pointsin data set) are 10 to 20,000.
Needed is to determine descriptive stats for these data sets. Excel requires
all data points to be in same column or row,all lised out; not already
binned. Getting mean is easy, I set column 3 = column 1* column 2; sum that;
divide by sum of colunn 2. But, getting skew, kurtosis,etc.. is tough.
any suggestions?
douglas
|