looking at the mean of one variable across another variable

[Anya hewertson]

Within stata i have data on the consumption of 10 different alcohol types. Another variable is the region of the UK (and within this there are 8 different regions). I am trying to look at the mean consumption of each alcohol type across the different regions so that i could create a table with the different alcohol types as the titles of the column and the rows being the different regions of the uk. How would i do this? Thank you

[Nick Cox]

No data example here — do please read and act on FAQ Advice #12 — but possibly tabstat will help.

[David Benson]

Hi Anya,

As Nick mentioned, it will be *much* easier for people to help you if you can share a sample of your data using Stata's dataex command (help dataex). If you're not familiar with dataex (and most Stata users aren't) I created a Youtube tutorial here. (I made it too long--feel free to watch at 2x speed, and you may only need the first 6 minutes) .

To summarize by region and then alcohol type, you're probably going to use table or tabstat. Take a look at the examples here, here, and here for help getting started.

Hope that helps!