# Re: st: Calculate the mean of y if there are many similar x

 From Luhang Wang To statalist@hsphsun2.harvard.edu Subject Re: st: Calculate the mean of y if there are many similar x Date Fri, 18 Mar 2005 16:11:51 -0500

```Not sure whether you are trying to get the group mean of y, grouped by x.

If yes, collapse can do the job, resulting in a data set of 3573
observations and two variables: group mean of y and the corresponding
x.

On Thu, 17 Mar 2005 20:44:50 -0800 (PST), Eik Leong Swee
<eikswee@yahoo.com> wrote:
> Hello. I have a problem here trying to sort my data. I have 2 variables y and x. Each one is of
> length 15000. However, y is unique but x is not i.e. for some values of y, there are more than one
> x. Specifically, there are 3573 unique values of x. I wish to take the mean of y for those x's
> that are the same, so that I end up only with a unique set of 3573 (y,x). I can either manually
> compute the mean 3573 times, or hopefully someone out there knows a command I can use. THANKS A
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```