Question

In: Statistics and Probability

Q1. The dataset jj.txt contains quarterly earnings per share for Johnson & Johnson. There are 84...

Q1. The dataset jj.txt contains quarterly earnings per share for Johnson & Johnson.
There are 84 quarters (21 years) measured from the first quarter of 1960 to the last quarter of 1980.
1. Make a time plot of the Johnson & Johnson data by using R. Describe the data based on the
graph.


2. Take a logarithm of the Johnson & Johnson data. Make a time plot of the log-
transformed data and describe it.


3. Denote the Johnson & Johnson data at time t as vt. Let xt = log(vt). Fit the regression
model xt = βt + α1Q1t + α2Q2t + α3Q3t + α4Q4t + µt;
where Qit = 1 if time t corresponds to quarter i = 1; 2; 3; 4, and zero otherwise. The Qit's are
called indicator variables. We will assume for now that µt is a Gaussian white noise sequence.
(Hint: Below is an example of R codes for this regression model t. You are welcome to use these
to make your own codes. You are strongly recommended to run each line one at a time and verify
the result.)

4. What is the interpretation of the parameters β, α1, α2, α3, and α4 in the following
regression model?
xt = βt + α1Q1t + α2Q2t + α3Q3t + α4Q4t + µt;


5. What are the least-squares estimates of the parameters β, α1, α2, α3, and α4? Interpret
the values of these estimates in the context of the study.


6. What happens if you include an intercept term in the model in part 3? Write an identifiable regression model in this case. Also, what is the interpretation of the regression parameters in this model?


7. Graph the log-transformed data xt, and superimpose the fitted values, say ^xt, on the
graph.


8. Examine the residuals (xt-^xt), and state your conclusions. Does it appear that the
model fits the data well (do the residuals look white)?

Solutions

Expert Solution

We plot the data in Johnson & Johnson using the following code :

Then we get the graph as following:

From the graph, we can conclude that the time series shows an increasing trend with fluctuations increasing with time thus indicating cyclical fluctuations.

Now by taking logarithm of the data we plot the new series and obtain the following graph:

From the above time series plot it is observed that there is only linear trend, seasonal variation and irregular fluctuation present in the series.

The regression is then obtained as the following code:

The regression equation then obtained as :

Xt=1.3819+0.2285*Q1t+0.2463*Q2t+0.3058*Q3t+0.2201*Q4t

Where, βt= intercept of the regression line

α1= amount of change in the data xt due to an unit change in value of quarter 1

α2= amount of change in the data xt due to an unit change in value of quarter 2

α3= amount of change in the data xt due to an unit change in value of quarter 3

α4= amount of change in the data xt due to an unit change in value of quarter 4


Related Solutions

Q1. The dataset jj.txt contains quarterly earnings per share for Johnson & Johnson. There are 84...
Q1. The dataset jj.txt contains quarterly earnings per share for Johnson & Johnson. There are 84 quarters (21 years) measured from the first quarter of 1960 to the last quarter of 1980. 1. Make a time plot of the Johnson & Johnson data by using R. Describe the data based on the graph. 2. Take a logarithm of the Johnson & Johnson data. Make a time plot of the log- transformed data and describe it. 3. Denote the Johnson &...
According to the Codification, is Earnings per Share (EPS) a required disclosure with the quarterly financial...
According to the Codification, is Earnings per Share (EPS) a required disclosure with the quarterly financial statements of a publicly-traded company? Yes or No?
what was the earnings per common share
Net Income for the period totaled OMR75,000,preferred dividends paid totaled OMR10,000 and common dividends paid totaled OMR30,000.If there 100,000 common shares outstanding throughout the year.What was the earnings per common share (a)44.50 OMR (b)0.35 OMR (c)0.65 OMR (d) 4.50 OMR
The current price of Parador Industries stock is $84 per share.Current sales per share are...
The current price of Parador Industries stock is $84 per share. Current sales per share are $15.40, the sales growth rate is 8.5 percent, and Parador does not pay a dividend. The expected return on Parador stock is 15 percent.a. Calculate the sales per share one year ahead. (Round your answer to 2 decimal places.)b. Calculate the P/S ratio one year ahead.(Do not round intermediate calculations. Round your answer to 2 decimal places.)
QPM has sales per share of $48.08, earnings per share of $7.58, book value per share...
QPM has sales per share of $48.08, earnings per share of $7.58, book value per share of $20.59, and dividends per share of $3.84. You have determined that relevant market multiples for QPM would be a price/sales ratio of 3.6x, a P/E ratio of 22.8x, a price/book ratio of 8.7x, and a dividend yield of 2.22%. You calculate a QPM price per share based on each ratio, and then estimate the value as the simple average of these four prices....
Johnson Products earned $4.30 per share last year and paid a dividend of $1.65 per share....
Johnson Products earned $4.30 per share last year and paid a dividend of $1.65 per share. If ROE was 16 percent, what is the sustainable growth rate?
Johnson Products earned $4.30 per share last year and paid a dividend of $1.65 per share....
Johnson Products earned $4.30 per share last year and paid a dividend of $1.65 per share. If ROE was 16 percent, what is the sustainable growth rate? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Sustanable growth rate:
The stock of Nogro Corporation is currently selling for $20 per share. Earnings per share in...
The stock of Nogro Corporation is currently selling for $20 per share. Earnings per share in the coming year are expected to be $3.00. The company has a policy of paying out 50% of its earnings each year in dividends. The rest is retained and invested in projects that earn an 18% rate of return per year. This situation is expected to continue indefinitely. a. Assuming the current market price of the stock reflects its intrinsic value as computed using...
Suppose that a firm’s recent earnings per share and dividend per share are $3.90 and $2.90,...
Suppose that a firm’s recent earnings per share and dividend per share are $3.90 and $2.90, respectively. Both are expected to grow at 7 percent. However, the firm’s current P/E ratio of 20 seems high for this growth rate. The P/E ratio is expected to fall to 16 within five years. Compute the dividends over the next five years. (Do not round intermediate calculations and round your final answers to 3 decimal places.)     Dividends Years   First year $3.10   Second year...
Suppose that a firm’s recent earnings per share and dividend per share are $3.00 and $2.30,...
Suppose that a firm’s recent earnings per share and dividend per share are $3.00 and $2.30, respectively. Both are expected to grow at 10 percent. However, the firm’s current P/E ratio of 24 seems high for this growth rate. The P/E ratio is expected to fall to 20 within five years. Compute the dividends over the next five years. (Do not round intermediate calculations. Round your final answer to 3 decimal places.)   Dividends Years   First year $   Second year $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT