Cash-Dividend and After-Tax Profits

Order Instructions

Complete Problem 3.14 of Chapter 3 and submit to your instructor. Complete your assignment in Excel and submit your completed Excel workbook to your Instructor for grading.

3.14. Table 3-6 gives data on X (net profits after tax in U.S. manufacturing industries [$, in millions]) and Y (cash dividend paid quarterly in manufacturing industries [$, in millions]) for years 1974 to 1986.

What relationship, if any, do you expect between cash dividend and after-tax profits?

Plot the scattergram between Y and X.

Does the scattergram support your expectations in part (a)?

If so, do an OLS regression of Y on X and obtain the usual statistics.

Establish a 99% confidence interval for the true slope and test the hypothesis that the true slope coefficient is zero; that is, there is no relationship between dividend and the after-tax profit.

excel problems

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.