Line graph

[Abdullah Baba]

Hey guys, how can I show these results as a line graph? Tried scatter etc. but was not lucky unfortunately.

CEO Succession	Model 2a
Net Income/Total Assets (ROA)	-0.0432* (0.0258)

This shows me that there is * significance and negative ROA leads to CEO succession.

Thanks a lot!

[Abdullah Baba]

Or is it also possible to show two lines in the same graph?

CEO Succession	Model 2a	Model 2b
Net Income/Total Assets (ROA)	-0.0432* (0.0258)
EBIT/Total Assets (ROTA)		-0.0898** (0.0420)

This is the trend over 24 years starting from 1992 to 2015.

Not sure how to show the graph (tbh) in the x and y axis. Any ideas for that?

[Abdullah Baba]

William Lisowski I guess you are the one who can help me here? :/

[William Lisowski]

Well, no, I cannot directly help with your question.

I can tell you that the commands you want to use here are, most likely, margins and marginsplot. Here is a very simple example.

sysuse auto, clear
logit foreign mpg
margins, at(mpg=(12(1)41))
marginsplot

If this is the sort of graph that you are looking for, those are the sort of commands you will want to use. And if it's not exactly what you are looking for, these commands are intensely powerful and they can probably provide what you are looking for. They're certainly the place to start.

If you are not already familiar with margins and marginsplot, you may find the explanation you need, and more, in the nice overview of margins prepared by Richard Williams, a frequent contributor here, at https://www3.nd.edu/~rwilliam/stats3/Margins01.pdf with a more detailed paper in the Stata Journal at http://www.stata-journal.com/article...article=st0260. I'll also note that Margins01.pdf is followed by Margins02.pdf ... Margins05.pdf covering more specialized topics.

And all five of these PDFs, and plenty more of use to someone learning about the analysis of categorical data, are linked to from http://www3.nd.edu/~rwilliam/stats3/ - the material mentioned above is found in the section headed Interpreting results: Adjusted Predictions and Marginal effects.

[Abdullah Baba]

Hi William,

thank you very much for your detailed reply, but this is too complicated for my graph. Just tried it and was not very doable for my regression.

I don't know whether I need to provide more information, but I ran a probit regression analysis where I have CEO succession as my DV and ROA (net income/assets) as my IV. This is the result which I get. Of course I interacted this beforehand over the years and this is my result for 24 years.

Now I want to show this in a graph and really I don't know, which one should be my x and y axis.

Hence, I hope someone did something similar earlier and can help me.

Thank you

[Abdullah Baba]

I hope someone can help out here.

These are my results for 24 years.

I have a probit regression and would like to show these results in a graph. It can be ans graph but I guess my
y axis = ceo succession
x acis = roa

how should then the trend -0.0432 look like?

thanks

[Chris Larkin]

Hey Abdullah,

You're not getting a good answer to your question. If you want one, I strongly suggest you read the FAQs linked at the top left of this page and follow the advice around posting a data example (using dataex [ssc], not by attaching a dataset), the full output you're getting, and the code you used to make it. Also take note of the advice in the FAQs around using CODE delimiters. Your question does not seem intrinsically difficult to answer but in the abstract it becomes tricky to guess the structure of your data and make an appropriate suggestion.

Read the FAQs, follow the guidance it provides, and you will massively increase your chances of a helpful response.

Good luck

[Abdullah Baba]

Hey Chris Larkin ,

thanks a lot for your response. I have now somehow made a graph but don't know whether I am right with this.

First of all,
- CEO Succession gets the value 1 if there was succession. 0 otherwise.

- Net income/total assets (ROA) is a ratio
- BHR is also a percentage (same for BHR CEO).


These are my results of the regression.

CEO Succession	Model 2b
Net Income/Total Assets (ROA)	-0.0299* (0.0167)
Buy Hold Return	-0.0157*** (0.00341)
Buy Hold Return (CEO)	-0.0232*** (0.00517)

This is my graph and I don't know whether my values in the axis are correct?

Would be great to get an info.

[Chris Larkin]

I don't either mate. If you want people to help you, make it easy for them to do so. Read #7 again. As i said, if you follow the advice in the FAQs you will massively increase your chances of a helpful response

Good luck

[Abdullah Baba]

I read topic #7 and it is about the topic title!?

[Chris Larkin]

#7 refers to post 7 in this forum. Not section 7 of the FAQs