Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Interpret the two estimated slope coecients of your regression. Hint: Keep in mind that this is a multivariate regression. Here is the given Excel Sheet

Interpret the two estimated slope coecients of your regression. Hint: Keep in mind that this is a multivariate regression. Here is the given Excel Sheet Fidelity Magellan Fund (CRSP FUNDNO 11943) year month Mgr_Name expenses turnover return net_assets Flow 1968 1 1/1/68 0.00% -5.46% 1968 2 2/1/68 0.00% -8.85% 1968 3 3/1/68 0.00% 0.44% 1968 4 4/1/68 0.00% 15.73% 1968 5 5/1/68 0.00% 17.05% 1968 6 6/1/68 0.00% -2.23% 1968 7 7/1/68 0.00% 3.25% 1968 8 8/1/68 0.00% 5.46% 1968 9 9/1/68 0.00% 7.16% 1968 10 10/1/68 0.00% 1.65% 1968 11 11/1/68 0.00% 12.45% 1968 12 12/1/68 0.00% -1.67% 7.1 1969 1 1/1/69 0.00% -0.76% 7.1 1969 2 2/1/69 0.00% -11.11% 7.1 1969 3 3/1/69 0.00% 3.77% 7.1 1969 4 4/1/69 0.00% 4.08% 7.1 1969 5 5/1/69 0.00% 3.50% 7.1 1969 6 6/1/69 0.00% 42.25% 7.1 1969 7 7/1/69 0.00% -10.77% 7.1 1969 8 8/1/69 0.00% 7.11% 7.1 1969 9 9/1/69 0.00% -0.60% 7.1 1969 10 10/1/69 0.00% 6.38% 7.1 1969 11 11/1/69 0.00% -4.74% 7.1 1969 12 12/1/69 0.00% 0.77% 8.2 1970 1 1/1/70 0.79% -7.97% 8.2 1970 2 2/1/70 0.79% -0.05% 8.2 1970 3 3/1/70 0.79% -8.85% 8.2 1970 4 4/1/70 0.79% -12.22% 8.2 1970 5 5/1/70 0.79% 4.56% 8.2 1970 6 6/1/70 0.79% -7.06% 8.2 1970 7 7/1/70 0.79% 3.63% 8.2 1970 8 8/1/70 0.79% 4.27% 8.2 1970 9 9/1/70 0.79% 12.58% 8.2 1970 10 10/1/70 0.79% 2.71% 8.2 1970 11 11/1/70 0.79% 2.68% 8.2 1970 12 12/1/70 0.79% 6.25% 6.9 1971 1 1/1/71 0.00% 8.54% 6.9 1971 2 2/1/71 0.00% 6.45% 6.9 1971 3 3/1/71 0.00% 7.83% 6.9 1971 4 4/1/71 0.00% 4.02% 6.9 1975 1975 1975 1975 1975 1975 1975 1976 1976 1976 1976 1976 1976 1976 1976 1976 1976 1976 1976 1977 1977 1977 1977 1977 1977 1977 1977 1977 1977 1977 1977 1978 1978 1978 1978 1978 1978 1978 1978 1978 1978 1978 1978 1979 1979 1979 1979 1979 1979 _\ DLOOO'NIO') _\._' AMA 'L ommwmmhmw _L_L _|.N_L _x OCDCD'NIO'JU'I-D-QJN _\_' ANA _\ 00300310301.me _\._' AMA 0301th 6/1/75 7/1/75 8/1/75 9/1/75 10/1/75 11/1/75 12/1/75 1/1/76 2/1/76 3/1/76 4/1/76 5/1/76 6/1/76 7/1/76 8/1/76 9/1/76 10/1/76 11/1/76 12/1/76 1/1/77 2/1/77 3/1/77 4/1/77 5/1/77 6/1/77 7/1/77 8/1/77 9/1/77 10/1/77 11/1/77 12/1/77 1/1/78 2/1/78 3/1/78 4/1/78 5/1/78 6/1/78 7/1/78 8/1/78 9/1/78 10/1/78 11/1/78 12/1/78 1/1/79 2/1/79 3/1/79 4/1/79 5/1/79 6/1/79 Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.49% 1.49% 1.49% 1.49% 1.49% 1.49% 1.49% 1.49% 1.49% 1.49% 1.49% 1.49% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.43% 1.43% 1.43% 1.43% 1.43% 1.43% 1.689 1.689 1.689 1.689 1.689 1.689 1.689 1.689 1.689 1.689 1.689 1.689 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.485 2.485 2.485 2.485 2.485 2.485 5.45% ~6.86% -1.39% -2.94% 1.01% 1.12% 1.48% 15.09% 3.86% 2.49% 0.07% 2.16% 7.57% -3.20% -3.26% 1.86% -2.40% 3.34% 6.27% 1.52% -0.04% -1.45% 3.42% 0.35% 7.52% -2.48% -3.30% 0.26% -3.11% 8.21% 4.00% -6.62% 4.21% 9.17% 12.28% 6.39% ~2.38% 12.50% 8.89% -3.30% -20.84% 10.00% 3.06% 10.38% -4.41% 12.71% 2.01% -2.58% 7.38% 22.2 22.2 22.2 22.2 22.2 22.2 22.2 22.2 22.2 22.2 22.2 22.2 26.4 26.4 26.4 26.4 26.4 26.4 26.4 1979 1979 1979 1979 1979 1979 1980 1980 1980 1980 1980 1980 1980 1980 1980 1980 1980 1980 1981 1981 1981 1981 1981 1981 1981 1981 1981 1981 1981 1981 1982 1982 1982 1982 1982 1982 1982 1982 1982 1982 1982 1982 1983 1983 1983 1983 1983 1983 1983 (BOON 11 12 1 I. owm-qmmhmm _|._; "1. 1 L OLDCONIO'JU'ILOJM _L_L NA 1 A OCDCD'HOEU'I-bO-JM _\_L N-x 1 #0301th 7/1/79 8/1/79 9/1/79 10/1/79 11/1/79 12/1/79 1/1/80 2/1/80 3/1/80 4/1/80 5/1/80 6/1/80 7/1/80 8/1/80 9/1/80 10/1/80 11/1/80 12/1/80 1/1/81 2/1/81 3/1/81 4/1/81 5/1/81 6/1/81 7/1/81 8/1/81 9/1/81 10/1/81 11/1/81 12/1/81 1/1/82 2/1/82 3/1/82 4/1/82 5/1/82 6/1/82 7/1/82 8/1/82 9/1/82 10/1/82 11/1/82 12/1/82 1/1/83 2/1/83 3/1/83 4/1/83 5/1/83 6/1/83 7/1/83 Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch 1.43% 1.43% 1.43% 1.43% 1.43% 1.43% 1.40% 1.40% 1.40% 1.40% 1.40% 1.40% 1.40% 1.40% 1.40% 1.40% 1.40% 1.40% 1.23% 1.23% 1.23% 1.23% 1.23% 1.23% 1.23% 1.23% 1.23% 1.23% 1.23% 1.23% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 0.85% 0.85% 0.85% 0.85% 0.85% 0.85% 0.85% 2.485 2.485 2 .485 2 .485 2 .485 2.485 3.38 3.38 3.38 3.38 3.38 3.38 3.38 3.38 3.38 3.38 3.38 3.38 2.77 2.77 2.77 2.77 2.77 2.77 2.77 2.77 2.77 2.77 2.77 2.77 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .2 1 .2 1 .2 1 .2 1 .2 1 .2 1 .2 2.59% 11.75% -0.68% -9.60% 10.28% 5.32% 8.63% 0.41% -13.50% 8.32% 8.72% 7.83% 8.90% 4.87% 7.82% 6.07% 11.94% -3.00% -0.93% 2.37% 9.59% 3.09% 6.53% -1.01% -0.14% -7.67% -7.00% 10.45% 4.41% -2.54% -2.94% -2.33% 0.00% 8.28% -2.93% 0.37% ~0.47% 9.24% 3.97% 14.38% 10.89% 3.26% 6.07% 6.12% 6.76% 10.51% 3.29% 5.28% -3.47% 26.4 26.4 26.4 26.4 26.4 35.1 35.1 35.1 35.1 35.1 35.1 35.1 35.1 35.1 35.1 35.1 35.1 53.5 53.5 53.5 58.81 58.81 58.81 104.37 104.37 104.37 90.44 90.44 90.44 107.25 107.25 107.25 115.778 115.778 115.778 146.819 146.819 146.819 231.161 231.161 231.161 458.433 458.433 458.433 797.602 797.602 797.602 1351.9 1351.9 1983 1983 1983 1983 1983 1984 1984 1984 1984 1984 1984 1984 1984 1984 1984 1984 1984 1985 1985 1985 1985 1985 1985 1985 1985 1985 1985 1985 1985 1986 1986 1986 1986 1986 1986 1986 1986 1986 1986 1986 1986 1987 1987 1987 1987 1987 1987 1987 1987 8 9 10 11 12 A OCDCDNIODU'I-bmm _'L_|, ANx I. OLDED'NIO'SU'ILCQN _x_. _L|\_')._L L omm-qmmbum _\_' _\M_x mummhwm 8/1/83 9/1/83 10/1/83 11/1/83 12/1/83 1/1/84 2/1/84 3/1/84 4/1/84 5/1/84 6/1/84 7/1/84 8/1/84 9/1/84 10/1/84 11/1/84 12/1/84 1/1/85 2/1/85 3/1/85 4/1/85 5/1/85 6/1/85 7/1/85 8/1/85 9/1/85 10/1/85 11/1/85 12/1/85 1/1/86 2/1/86 3/1/86 4/1/86 5/1/86 6/1/86 7/1/86 8/1/86 9/1/86 10/1/86 11/1/86 12/1/86 1/1/87 2/1/87 3/1/87 4/1/87 5/1/87 6/1/87 7/1/87 8/1/87 Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch 0.85% 0.85% 0.85% 0.85% 0.85% 1.04% 1.04% 1.04% 1.04% 1.04% 1.04% 1.04% 1.04% 1.04% 1.04% 1.04% 1.04% 1.12% 1.12% 1.12% 1.12% 1.12% 1.12% 1.12% 1.12% 1.12% 1.12% 1.12% 1.12% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1 .2 1 .2 1 .2 1 .2 1 .2 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 1 .26 1 .26 1 .26 1 .26 1 .26 1 .26 1 .26 1 .26 1 .26 1 .26 1 .26 1 .26 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 -2.24% 3.35% -4.35% 4.49% -1.56% -0.91% 6.49% 1.79% -0.80% 6.82% 3.23% -1.58% 11.66% 0.18% 1.28% -1.21% 2.90% 10.12% 0.70% 0.88% 0.53% 5.41% 2.99% 0.75% 0.49% 4.69% 6.48% 8.45% 5.19% 3.94% 10.34% 6.73% 0.45% 3.29% 2.38% -6.67% 6.43% -8.50% 5.23% 1.01% -1.48% 13.00% 7.42% 1.29% -1.62% 0.10% 4.14% 4.89% 4.02% 1351 .9 1477.9 1477.9 1477.9 1606 1606 1606 1604.107 1604.107 1604.107 1617.6 1617.6 1617.6 1891 .91 1891 .91 1891 .91 1954.4 1954.4 1954.4 2359.026 2359.026 2359.026 2878.476 2878.476 2878.476 2961 .971 2961 .971 2961 .971 4136 4136 4136 5998.5 5998.5 5998.5 7270.9 7270.9 7270.9 6504 6504 6504 7405.5 7405.5 7405.5 9843.9 9843.9 9843.9 10842.3 10842.3 10842.3 1987 1987 1987 1987 1988 1988 1988 1988 1988 1988 1988 1988 1988 1988 1988 1988 1989 1989 1989 1989 1989 1989 1989 1989 1989 1989 1989 1989 1990 1990 1990 1990 1990 1990 1990 1990 1990 1990 1990 1990 1991 1991 1991 1991 1991 1991 1991 1991 1991 9 10 11 12 \ DLOOO'QOSUIACJMI _\._; AMA I occac-qcncnhmw _L_L ANA _''L Accom-Mmmhmm A AN com-qmmhmru 9/1/87 10/1/87 11/1/87 12/1/87 1/1/88 2/1/88 3/1/88 4/1/88 5/1/88 6/1/88 7/1/88 8/1/88 9/1/88 10/1/88 11/1/88 12/1/88 1/1/89 2/1/89 3/1/89 4/1/89 5/1/89 6/1/89 7/1/89 8/1/89 9/1/89 10/1/89 11/1/89 12/1/89 1/1/90 2/1/90 3/1/90 4/1/90 5/1/90 6/1/90 7/1/90 8/1/90 9/1/90 10/1/90 11/1/90 12/1/90 1/1/91 2/1/91 3/1/91 4/1/91 5/1/91 6/1/91 7/1/91 8/1/91 9/1/91 Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch Peter Lynch 1.08% 1.08% 1.08% 1.08% 1.13% 1.13% 1.13% 1.13% 1.13% 1.13% 1.13% 1.13% 1.13% 1.13% 1.13% 1.13% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.08% 1.01% 1.01% 1.01% 1.01% 1.01% 1.01% 1.01% 1.01% 1.01% 1.01% 1.01% 1.01% 1.06% 1.06% 1.06% 1.06% 1.06% 1.06% 1.06% 1.06% 1.06% 0.96 0.96 0.96 0.96 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 1 .42 1 .42 1 .42 1 .42 1 .42 1 .42 1 .42 1 .42 1 .42 1 .42 1 .42 1 .42 -2.46% -25.81% -7.55% 9.74% 3.97% 6.07% -0.27% 1.79% -0.27% 6.84% 0.65% -3.18% 4.20% 2.09% -1.35% 1.97% 8.11% -1.63% 2.98% 5.03% 5.28% -0.87% 8.40% 2.62% 1.73% -3.14% 1.65% 0.63% 6.45% 2.05% 2.56% -2.53% 8.89% 0.44% -1.13% -9.80% ~6.35% -1.24% 7.57% 3.10% 6.99% 8.68% 3.40% 0.37% 5.70% 5.88% 6.21% 3.07% -0.38% 11589.5 11589.5 11589.5 7800.1 7800.1 7800.1 8434.3 8434.3 8434.3 9257.4 9257.4 9257.4 9016 9016 9016 8971.1 8971.1 8971.1 9622.2 9622.2 9622.2 10756.6 10756.6 10756.6 12427.9 12427.9 12427.9 12699.6 12699.6 12699.6 13176.9 13176.9 13176.9 14038.9 14038.9 14038.9 11318.9 11318.9 11318.9 12325.7 13122.3 14292.5 14805.3 14990 16004.6 15251.8 16384.4 17227.3 17276.5 -0.53% 0.23% 0.19% 0.38% 1 .07% 1 .17% 1.22% 2.07% 0.66%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets and Institutions

Authors: Frederic S. Mishkin, Stanley G. Eakins

8th edition

013342362X, 978-0133423624

More Books

Students also viewed these Finance questions