Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Statistical summary of bucketed data
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statistical tests with 2-factor data | Excel Worksheet Functions | |||
statistical data, stdev, Pp& Ppk | Excel Discussion (Misc queries) | |||
statistical data exel templates | New Users to Excel | |||
Statistical tests and data type | Excel Discussion (Misc queries) | |||
help formulating statistical data | Excel Worksheet Functions |