Regression: which parameters to use and how to plot the data

  • #1
86
0
Hello!
I am yet very weak in statistics, but I am learning some basic finance, and this requires to create regression.
Please, take a look at attached files - one excel that contains the results of regression and one screen shot of the window of StatPlus that I have to fill in. Before using my own data I would like to replicate the analysis presented in the file. I don't understand which columns are used to perform a regression model. There is part of data that computes variables for regression model, and it contains 4 columns. The goal is to find predicted dividends. So I assume that dividends per share is the dependent variable. But I still don't understand which columns I should use and how.
I will be very grateful for your help!
Thank you very much!
Edit: corrected the excel file, and added my results.
 

Attachments

Last edited:

Answers and Replies

  • #2
RUber
Homework Helper
1,687
344
Hi Ducmod,
In your attached Excel sheet, the columns used for the regression are clearly marked. Columns G-J are titled "Data for Regression Model".

The model was described by:
##D_t = a + bD_{t-1}+cEPS_t+d(\Delta EPS)##
You are correct that the Dividend, ##D_t## is your dependent variable, and you have 3 independent variables for this model, ##D_{t-1}## is called the "lagged DPS", ##EPS_t## is the "annual EPS", and ##\Delta EPS## is the "change in EPS".

The coefficients for the model, a, b, c, and d, are listed in that order in your output table.

Does that address your question?
 
  • #3
86
0
Hi Ducmod,
In your attached Excel sheet, the columns used for the regression are clearly marked. Columns G-J are titled "Data for Regression Model".

The model was described by:
##D_t = a + bD_{t-1}+cEPS_t+d(\Delta EPS)##
You are correct that the Dividend, ##D_t## is your dependent variable, and you have 3 independent variables for this model, ##D_{t-1}## is called the "lagged DPS", ##EPS_t## is the "annual EPS", and ##\Delta EPS## is the "change in EPS".

The coefficients for the model, a, b, c, and d, are listed in that order in your output table.

Does that address your question?
Hello RUber,
Thank you very much for your answer. Yes, your answer does address my problem. I will now try to run regression again. It is very challenging for me )
Thank you!
 

Related Threads on Regression: which parameters to use and how to plot the data

  • Last Post
Replies
11
Views
2K
  • Last Post
Replies
2
Views
1K
Replies
5
Views
928
  • Last Post
Replies
2
Views
2K
Replies
5
Views
294
Replies
1
Views
1K
Replies
0
Views
4K
Replies
6
Views
2K
Replies
1
Views
423
Top