How to plot regression line graph of Panel data

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

Anita
Posts: 4
Joined: Mon Jun 02, 2014 1:59 am

How to plot regression line graph of Panel data

Postby Anita » Tue Jun 03, 2014 12:21 am

Hi all,

Can anyone help to plot regression lines graph of Panel data, Eviews 8

I used the following model of Panel data and want to plot regression lines in same graph :

Tobin's q = (c0) + (c1)*manager ownership(mo)+(c2)*mo^2+(c3)*mo^3+(c4)*control value1+(c5)*control value2+error term (1)
Capital structure=(c0) + (c1)*manager ownership("mo")+(c2)*mo^2+(c3)*mo^3+(c4)*control value1+(c5)*control value2+error term (2)

I tried to plot the above 2 regression lines in the same graph, but can not found any tool bar in eView can plot the graph. From the user guide, it shows us how to plot bar of Panel data but can not plot a regression line.

Any one call tell me the steps to plot regression lines of Panel data in the same graph, sample attached.

Thank you!!!
Anita
Attachments
plot regrression line sample271.pdf
(52.73 KiB) Downloaded 313 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to plot regression line graph of Panel data

Postby EViews Gareth » Tue Jun 03, 2014 7:48 am

I think what you're trying to do is plot the fitted values from a regression. Just estimate the equation/regression, then hit the forecast button to create the fitted values. Then graph the forecast series.

Anita
Posts: 4
Joined: Mon Jun 02, 2014 1:59 am

Re: How to plot regression line graph of Panel data

Postby Anita » Tue Jun 03, 2014 8:33 am

Thank you Gareth.

I tried but I don't know why there is 2 line and not in "N" shape.

According to the Result of OLS on equation (1) and (2), the line is in "N" shape but it is not.

Please find the result of OLS for your comment and tell me any missing steps. I need to find out the value of turning points in above 2 regression line.
Attachments
Result of OLS on eq(1) and eq(2).pdf
(6.26 KiB) Downloaded 353 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to plot regression line graph of Panel data

Postby EViews Gareth » Tue Jun 03, 2014 9:01 am

I don't understand what you're asking, or what that picture is supposed to show me.

Anita
Posts: 4
Joined: Mon Jun 02, 2014 1:59 am

Re: How to plot regression line graph of Panel data

Postby Anita » Tue Jun 03, 2014 2:57 pm

Gareth, thank you!!

The picture (graph of the regression line of Panel data) is attached.
I also attach descriptive analysis for your information.
Attachments
Descriptive analysis of Q1.pdf
(27 KiB) Downloaded 339 times
Descriptive analysis of Q2.pdf
(26.77 KiB) Downloaded 301 times
plot regrression line sample271.pdf
(52.73 KiB) Downloaded 357 times


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests