Displaying 2 results from an estimated 2 matches for "yourtabl".
Did you mean:
yourtable
2006 Feb 17
2
Grouping and Averaging in Table
Dear Rs
I have a single table with three columns in the following form:
1 100 150
1 45 32
1 99 100
2 150 33
2 22 87
2 71 31
....
....
1000 64 32
1 100 150
1 45 32
1 99 100
2 22 89
2 31 44
2 88 11
....
....
1200 64 32
1 100 150
1 45 32
1 99 100
2 150 33
2 22 87
2 71 31
...
...
1100 31 34
Totally 1000+1200+1100 rows. Now, I need to group by first column
and average then second and third column
2004 Mar 17
9
Frequency table
This must be FAQ, but I can't find it in archives or with a site search.
I am trying to construct a frequency table. I guess this should be done with
table. Or perhaps factor and split. Or prop.table. cut? findInterval? Argh!
Please correct me if what I am looking for is not called a "frequency table".
Perhaps it's called grouped data.
> zz$x9
[1] 65 70 85 65 65 65 62 55