Question: Run a multiple regression of 5 Year Average Return on Net Asset Value ($), Expense Ratio (%) and the Fund-type dummies, Please paste the picture

Run a multiple regression of 5 Year Average Return on Net Asset Value ($), Expense Ratio (%) and the Fund-type dummies, Please paste the picture of excel multiple regression summary outputs on the answer area

Run a multiple regression of 5 Year Average

Fund Type FI DE IE ER&FI ER&IE 2-Star 3-Star 4-Star 5-Star ER & DE 0.67 0 1 0 0 0 1 0 0 0 0 0 0 1.41 1 0 DE IE FI DE 5 Year Average Net Asset Value Expense Ratio Return (%) ($) (%) 12.39 28.88 0.67 30.53 14.37 1.41 3.34 10.73 0.49 10.88 24.94 0.99 11.32 46.39 1.03 24.95 25.52 1.23 15.67 16.92 1.18 1 o 0 0 1 0 0.49 0 o 0.99 0 Morningstar Rank 2-Star 3-Star 4-Star 3-Star 2-Star 3-Star 3-Star 5-Star 0 1 0 0 0 0 1 0 0 0 0 1 0 DE 0 1 0 0 1.03 1 0 0 0 1.23 IE 0 0 1 0 0 1 0 0 1.18 0 0 DE 0 1 0 0 0 0 1 DE 16.77 50.67 1.31 0 1 0 0 1.31 0 0 0 1 DE 0 0 0 0 0 0 1 36.58 35.73 1.08 1.20 1 1 1.08 1.2 0 0 0 0 o 0 0 1 0 0 15.29 1.02 0 0 0 1.02 0 1 0 0 DE DE DE DE FL 18.14 15.85 17.25 17.77 17.23 4.31 1 1 0 0 0 1.32 0 0 1 0 24.32 13.47 12.51 1.32 0.53 0.44 0 1 0 0 0.53 0 1 0 0 1 0 0 0.44 0 0 0 0 1 0 DE 31.86 0 1 0 0 1 0 0 0 0 DE 0 1 0 0 0 0 0 0.89 0 0 0 1 1 1 1 0 0 0 0 18.23 17.99 4.41 23.46 13.50 2.76 0 0.9 1.00 0.89 0.45 0.90 0.89 0.45 0 0 1 0 FI IE DE FI 0 1 73.11 12.58 48.39 45.60 8.60 39.85 0.45 0 0 0.45 0 0.89 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0 1 0 Observation Fund Name 1 Amer Cent Inc & Growth Inv 2 American Century Intl. Disc 3 American Century Tax-Free Bond 4 American Century Ultra 5 Ariel 6 Artisan Intl Val 7 Artisan Small Cap 8 Baron Asset 9 Brandywine 10 Brown Cap Small 11 Buffalo Mid Cap 12 Delafield 13 DFA U.S. Micro Cap 14 Dodge & Cox Income 15 Fairholme 16 Fidelity Contrafund 17 Fidelity Municipal Income 18 Fidelity Overseas 19 Fidelity Sel Electronics 20 Fidelity Sh-Term Bond 21 Fideliy 22 FPA New Income 23 Gabelli Asset AAA 24 Greenspring 25 Janus 26 Janus Worldwide 27 Kalmar Gr Val Sm Cp 28 Managers Freemont Bond 29 Marsico 21st Century 30 Mathews Pacific Tiger 31 Meridan Value 32 Oakmark 33 PIMCO Emerg Mkts Bd D 34 RS Value A 35 T. Rowe Price Latin Am. 36 T. Rowe Price Mid Val 37 Templeton Growth A 38 Thornburg Value A 39 USAA Income 40 Vanguard Equity-Inc 41 Vanguard Global Equity 42 Vanguard GNMA 0 DE 0 1 0 0 0.56 0 0 0 1 0 FI 14.4 4.63 16.70 0.56 0.62 1.36 1 0 0 0.62 0 0 0 1 0 10.95 49.81 0 DE 0 1 0 0 1.36 0 0 0 1 0 DE 0 1 0 0 0 1 0 1.07 0.9 0 0 0 0 0 1 0 DE IE 4-Star 4-Star 3-Star 4-Star 3-Star 4-Star 5-Star 5-Star 5-Star 4-Star 3-Star 3-Star 4-Star 3-Star 4-Star 3-Star 3-Star 2-Star 3-Star 5-Star 5-Star 3-Star 4-Star 2-Star 3-Star 4-Star 4-Star 4-Star 3-Star 4-Star 3-Star 4-Star 5-Star 5-Star 23.59 32.26 54.83 15.30 1 0 0 0.86 0 1 0 1 0 0 0 1.32 DE 0 1 0 0 0 0 1 0 0 1 FI 1 0 0 0 0 0 0.6 0 1.07 0.90 0.86 1.32 0.60 1.31 1.16 1.08 1.05 1.25 0 0 0 0 0 1.31 0 16 DE IE 0 0 1 0 0 1.16 1 0 0 1 0 0 10.56 17.44 27.86 31.92 40.37 10.68 26.27 0 1.08 DE 0 1 0 0 0 0 0 12.46 12.81 12.31 15.31 5.14 15.16 32.70 15.33 9.51 13.57 23.68 51.10 16.91 15.91 15.46 4.31 13.41 1 0 0 DE 0 1 0 1.05 0 1 0 0 1 0 0 0 1.25 0 0 0 0 1 0 0 0 0 1 0 1.36 0 0 1 FI DE IE DE IE 0 1.24 0 0 1 0 0 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 0 1 0 53.89 22.46 24.07 37.53 12.10 24.42 1.36 1.24 0.80 1.01 1.27 0.62 0.29 0.64 0.21 DE 0 1.01 0 0 0 1 0 0 0 0.8 0 1.27 0 0.29 1 0 0 0 0 1 0 0 0 0 0 1 0.62 1 0 1 0 0 0 0 1 FI DE IE FI 0 0 1 0 0 0 0 0.64 0 0 21.77 4.25 1 23.71 10.37 0 0.21 1 0 0 0 0 0 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!