Construct a model to see the capital intensity of industries, and the different amounts of firms invested in those industries.

[Sophie Mandan]

I have a panel data consisting of 16 626 firms over a timespan of 16 years.
I have a dummy variable distinguishing "rich" entrepreneurs from "poor" entrepreneurs.
I also have created 18 dummy variables for different industries these firms are operating in.
I have created a variable "Capital Intensity" = Assets/Revenue.

What I want to create is a model that helps me see the industries that are most capital intensive, and what group of entrepreneur is most heavily invested in the different industries.
I am not too familiar with state, so I have the idea clear, but do not know how to execute this vision. Please help!!!

[Carlo Lazzaro]

Sophie:
see -xtreg- entry in Stata .pdf manual.

[Sophie Mandan]

Yes, I have gone through that. What I am wondering is how to even make all these commands hold for one singular model.

[Sophie Mandan]

I am imagining something like this:
Is that possible to do in Stata??

[Phil Bromiley]

You'll increase your chances of a useful answer by following the FAQ on asking questions - provide Stata code in code delimiters, readable Stata output, and sample data using dataex. You only need enough to show us your problem.
You threw us a curve when you talked about a model when what you wanted was a histogram. Look at the graphics manual's documentation on graph twoway and histogram plots.