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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Statistical summary of bucketed data
I dont think a pivot table is what i want.
I have a column with values, and another which has the frequency of each of these values. Is that what a pivot table is for? "Jim Thomlinson" wrote: 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? |
Reply |
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 |