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

histogram analysis
 

Hi Douglas,

Use the Analysis Toolpack ... hich does it all .. and even more ...
Make sure to have it up and running, in the main menu Tools Add-ins

HTH
Cheers
Carim