Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started