1

# A portion of a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008 follows. The complete data set is available i...

## Question

###### A portion of a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008 follows. The complete data set is available in the file named MutualFunds. The data set includes the following five variables: Type: The type of fund, labeled DE (Domestic Equity), IE (International Equity), and FI (Fixed Income). Net Asset Value (\$): The closing price per share on December 31, 2007. 5-Year Average Return (\%): The average annual return for the fund over the p A portion of a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008 follows. The complete data set is available in the file named MutualFunds. The data set includes the following five variables: Type: The type of fund, labeled DE (Domestic Equity), IE (International Equity), and FI (Fixed Income). Net Asset Value (\$): The closing price per share on December 31, 2007. 5-Year Average Return (\%): The average annual return for the fund over the past 5 years. Expense Ratio (\%): The percentage of assets deducted each fiscal year for fund expenses. Morningstar Rank: The risk adjusted star rating for each fund; Morningstar ranks go from a low of $1-$ Star to a high of 5 -Stars. a. Develop an estimated regression equation that can be used to predict the 5 -year average return given fund type. At the .05 level of significance, test for a significant relationship. b. Did the estimated regression equation developed in part (a) provide a good fit to the data? Explain. c. Develop the estimated regression equation that can be used to predict the 5 -year average return given the type of fund, the net asset value, and the expense ratio. At the .05 level of significance, test for a significant relationship. Do you think any variables should be deleted from the estimated regression equation? Explain. d. Morningstar Rank is a categorical variable. Because the data set contains only funds with four ranks (2-Star through 5-Star), use the following dummy variables: 3StarRank $=1$ for a 3 -Star fund, 0 otherwise; 4 StarRank $=1$ for a 4 -Star fund, 0 otherwise; and 5 StarRank $=1$ for a 5 -Star fund, 0 otherwise. Develop an estimated regression equation that can be used to predict the 5 -year average return given the type of fund, the expense ratio, and the Morningstar Rank. Using $\alpha=.05,$ remove any independent variables that are not significant. e. Use the estimated regression equation developed in part (d) to estimate the 5 -year average return for a domestic equity fund with an expense ratio of $1.05 \%$ and a $3-$ Star Morningstar Rank. #### Similar Solved Questions

##### (a) sphercal ball How balloon 246 fast 8 the inflated radius with ofthe 8 balloon rate i cubic ac te | Instant ! centimeters the per radingte centimeters?Need 1 cmlmin(b) cm/min How fast the radius 8 belleon changing 8 Instant 3 81 Mancentimeters?
(a) sphercal ball How balloon 246 fast 8 the inflated radius with ofthe 8 balloon rate i cubic ac te | Instant ! centimeters the per radingte centimeters? Need 1 cmlmin (b) cm/min How fast the radius 8 belleon changing 8 Instant 3 8 1 Man centimeters?...
##### Mikai econed Tne colors cfcans Darte" Frobability model Use Mkails prcbability mode answehis apamment parkinglot ever; day formontns He used theze numtersVeop the fcllowingJuzstone Ce Dwanswersnum-2rs detveenColorRedBlomeenUNieGrexIBlac <IBrownProbabilin,What color of car mostottontRedBlueGr2enWhijeBlackBrounWhat color of car i= lastctton?RedBlueGr2enWhijeCreyBlackBroun6e]
Mikai econed Tne colors cfcans Darte" Frobability model Use Mkails prcbability mode answe his apamment parkinglot ever; day for montns He used theze numters Veop the fcllowing Juzstone Ce Dw answers num-2rs detveen Color Red Bl omeen UNie Grex IBlac < IBrown Probabilin, What color of car mos...
##### ~12 points TanApMath5 10.4.020.My NotesFind the absolute maximum value and the absolute minimum value_ if any, of the function_ (If an answer does not exist _ enter DNE:) f (c) = +3r" 1 01l [-3.1]maximumminimumNeed Help?Read ItTalk to Tutor
~12 points TanApMath5 10.4.020. My Notes Find the absolute maximum value and the absolute minimum value_ if any, of the function_ (If an answer does not exist _ enter DNE:) f (c) = +3r" 1 01l [-3.1] maximum minimum Need Help? Read It Talk to Tutor...
##### (b) Finc the Ja} Flind You can Ppon) Conske earn partial Riemann Riemann sum Ine 1 for thls Integral 1 same Integral integral using using right endpoints endpoints and n and n2 +6)d
(b) Finc the Ja} Flind You can Ppon) Conske earn partial Riemann Riemann sum Ine 1 for thls Integral 1 same Integral integral using using right endpoints endpoints and n and n 2 +6)d...
##### 7.A news helicopter is hovering near an accident; The angle of depression to the accident is 21 degrees_ A sensor on the helicopter calculates the distance Irom the helicopler to the accident Is 1000 feet: What is the height of the helicopter? (3 pts)Helght =
7.A news helicopter is hovering near an accident; The angle of depression to the accident is 21 degrees_ A sensor on the helicopter calculates the distance Irom the helicopler to the accident Is 1000 feet: What is the height of the helicopter? (3 pts) Helght =...
##### MculblucebourdicomDent Hc nrHomowonCenl sprinoHomanceme LonnoOndrebrolneTmed TerThls resanat tirve Iirnit of 30 mnutes This test wlll save and submit automatically wen the Warnings appear wnen half thc time mnutes mnurcJa scconosremain Multiple Attcmpts This testalc s attempts- This dttemnt nunmnu Forcr Comnletior Sctung This test can suedandeumica any n Dint unu titne hirenreo Mnetuncr will conuinueRcmainlnz Time: 17 minutes, 54 sccondsDurtlon Comelction statusQUESTIONWhal are (ne mJio producs
Mculblucebourdicom Dent Hc nr Homowon Cenl sprino Homanceme Lonno Ondrebrolne Tmed Ter Thls resanat tirve Iirnit of 30 mnutes This test wlll save and submit automatically wen the Warnings appear wnen half thc time mnutes mnurcJa scconosremain Multiple Attcmpts This testalc s attempts- This dttemnt n...
##### Find the maximum value of the directional derivative for the function h(x,y) xe' at the point (3,0).
Find the maximum value of the directional derivative for the function h(x,y) xe' at the point (3,0)....
##### 23 A nuclear power plant generates MW of power at a reactor tempertuire of 6OOPF: It rejects waste heat into & nearby river; with a flow mte of 6,00Oft? /s, und a upstream temperature of 70PF The power plant operates at 60% of maximum possible efficiency Find the temperature rise of' the rivec
23 A nuclear power plant generates MW of power at a reactor tempertuire of 6OOPF: It rejects waste heat into & nearby river; with a flow mte of 6,00Oft? /s, und a upstream temperature of 70PF The power plant operates at 60% of maximum possible efficiency Find the temperature rise of' the ri...
##### A lawn mower tractor pulls a large and heavy sled during a tpelliorcegame %tna tforrtY dispiaceenence during the pull monitored and recorded by instruments The figure shows force as a function displacement1x(m)What was the total amount of work done by the tractor? 63.254 Submit Answer Incorect: Tries 2/99 Previous TriesWhat was the average power of the tractor; if the pull lasted for 8.80 seconds?Submit AnswerTries 0/99
A lawn mower tractor pulls a large and heavy sled during a tpelliorcegame %tna tforrtY dispiaceenence during the pull monitored and recorded by instruments The figure shows force as a function displacement 1 x(m) What was the total amount of work done by the tractor? 63.254 Submit Answer Incorect: T...
##### Alecor58-34032 umer. _HintChicJn [76412The pH of a solution 73,81 0.04. Whut is thc concentration of H+ Lhe solulon and IL ahenlnta @ncertainry ?a
Alecor 58-340 32 umer . _ Hint Chic Jn [76412 The pH of a solution 73,81 0.04. Whut is thc concentration of H+ Lhe solulon and IL ahenlnta @ncertainry ? a...
##### { 72 { 3F; 2 Bef 9 F 2 U 1 1 1 0 L L 0 { 1 1392
{ 72 { 3F; 2 Bef 9 F 2 U 1 1 1 0 L L 0 { 1 1 3 9 2...
##### Use a known formula to solve. See Example 3.One base of a trapezoid is 2 in. longer than three times the other base. Find the lengths of the bases if the trapezoid is 5 in. high and has an area of 25 in $^{2}$.
Use a known formula to solve. See Example 3. One base of a trapezoid is 2 in. longer than three times the other base. Find the lengths of the bases if the trapezoid is 5 in. high and has an area of 25 in $^{2}$....
##### Question 2Given a continuous f such that fr)dx = 14 and fx)dx = 2,Find {x)dr =?A No correct answer B_12D.-26OE 12
Question 2 Given a continuous f such that fr)dx = 14 and fx)dx = 2, Find {x)dr =? A No correct answer B_12 D.-26 OE 12...
##### The table to the right shows the digits of the octal system (base eight) and their equivalents in the binary system (base two) Use the table to fill in the blanks below_ (a) Write 101100111two in the octal system_Octal digit Binary equivalent (base eight) (base two)000101100111 two001eight010(b) Write 3470eight in the binary system0113470 eighttwo1001012110111
The table to the right shows the digits of the octal system (base eight) and their equivalents in the binary system (base two) Use the table to fill in the blanks below_ (a) Write 101100111two in the octal system_ Octal digit Binary equivalent (base eight) (base two) 000 101100111 two 001 eight 010 ...
##### 25#fLk) =e-25 5+ 1~25 then 'yx) = (s+1)2Mx) - ulx-1)- ux - JJe-2x-1_ ulx - lJe-Zx-Wx-1) Mx) = ulx-2) - ulx -ZJe-(-2)_ ulx- 2)e-Ix-zlx - 2) Mx) = ulx-2) - ulx-2Je-(-1)_ Ux - 2Je-(x-Ix - 1) None of the answers Xx) = 2ulx - 1)- Zulx- lJe-(x-1) 2ulx - 1)e-(x-lx - 1)
25 #fLk) = e-25 5+ 1 ~25 then 'yx) = (s+1)2 Mx) - ulx-1)- ux - JJe-2x-1_ ulx - lJe-Zx-Wx-1) Mx) = ulx-2) - ulx -ZJe-(-2)_ ulx- 2)e-Ix-zlx - 2) Mx) = ulx-2) - ulx-2Je-(-1)_ Ux - 2Je-(x-Ix - 1) None of the answers Xx) = 2ulx - 1)- Zulx- lJe-(x-1) 2ulx - 1)e-(x-lx - 1)...
##### (10 points) Bob makes his first $2,000 deposit into an IRAearning 6.8% interest compounded annually on his 24th birthday andhis last$2,000 deposit on his 35th birthday (12 equal paymentsin all.)How much money will be in the account by his35th birthday?With no additional deposits, the money in the IRA continues toearn 6.8% interest compounded annually until Bob retires on his65th birthday (that is 30 years after the last deposit). How muchis in his IRA when he retires?
(10 points) Bob makes his first $2,000 deposit into an IRA earning 6.8% interest compounded annually on his 24th birthday and his last$2,000 deposit on his 35th birthday (12 equal payments in all.) How much money will be in the account by his 35th birthday? With no additional deposits, the money in...