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.3.6 cash dividend (Y) and after-tax (X) in U.S. manufacturing industries 1974-1986 year Y X 1974 19467 58747 1975 19968 49135 1976 22763 64519 1977 26585 70366 1978 28932 81148 1979 32491 98698 1980 36495 92579 1981 40317 101302 1982 41259 71028 1983 41624 85834 1984 45102 107648 1985 45517 87648 1986 46044 83121coefficient is zero; that is there is norelationship between dividend and the after-tax profit.
Back