Statistical help
smartkid
word_stats.docxour output for this should be an Excel file and may also include a word document. If you choose to type your analysis in Excel, please make it easy to read.
Using the tab Entitled “Mutual Funds,” perform the following operations. This data is selected mutual funds from Morningstar Funds 500 in 2008.
1. Create dummy variables for Morningstar Rank and Fund Type.
2. Using Excel for your regression, develop an estimated regression equation to predict 5-year average return given fund type and net asset value. State the estimated regression equation.
3. Using Excel for your regression, develop an estimated regression equation to predict 5-year average return given fund type, net asset value, expense ratio, and Morningstar Rank. State the estimated regression equation.
4. Compare your output for these two regressions. This should include comparing the significance of each of the coefficients as well as the significance and fit of the model as a whole. Which model would you use to predict 5-year average return and why?
Using the tab entitled “Hudson Marine,” perform the following operations.
1. Insert a graph of sales over time (please do not graph time itself) and comment on any trends or seasonality you notice.
2. Using Excel, develop an estimated regression equation to predict sales given which quarter we are in and which time period we are in. State the estimated regression equation.
3. Comment on the significance of each of the coefficients as well as the significance and fit of the model overall.
4. Predict sales for each quarter in year 8.
