Data (adjacent worksheet) was collected for 45 mutual funds
Data (adjacent worksheet) was collected for 45 mutual funds, which… Data (adjacent worksheet) was collected for 45 mutual funds, which are part of the mutual fund portfolios offered through LMD investments. LMD wants to develop a linear regression model to predict the 3-year average return (%) based upon: the fund type, which is denoted as Indexed Funds (IN), Corporate Bonds (CB), Global Equity (GE) and Fixed-income (FI), as well as the fund’s Expense ratio. Complete the following steps:1. Use Excel to construct an (xy) scatterplot for y=3-year average return versus x=Expense ratio. Be sure to provide a meaningful title and informative axis labels. 2. Run the regression model (use IN as the reference category for the categorical variables). Put your regression output in the worksheet “Regression Data”. Also generate a proper Normal Probability Plot in the Data worksheet. Use the regression output to answer questions a – g below:a. Type the estimated regression function.b. What percentage of the total variability in 3-year average return is explained by the regression model?c. What is the observed significance level of the estimated regression model?d. Interpret the estimated regression coefficient for a ‘GE’ fund.e. List and explain each independent variables (if any) that is not significant at the 0.05 levelf. State and interpret the 90% confidence interval for the coefficient of ‘expense ratio’?g. Predict the 3-year average return for a GE fund with an Expense ratio of 1.12% (report the final answer to one decimal place).h. From the regression output, what is the average marignal value (i.e. 1% increase) in the expense ratio on 3-year average returns? *Please provide step by step directions for the excel regression model and include the Excel work.* Image transcription textA B C 3-Year Expens Arerag Fund Ratio Fod Return Type 18.23 GE 1.00 21.77 IN 1.32 12.81 GE 0.30 12.31 CB0.86 2.76 FI 0.45 24.95 CB 1.23 4.25 FI 0.21 16.46 IN 1.07 19 85 IN 1.20 11 10 5.14 FI 0.60 12 11 3.34 FI 0.43 13 1222.14 IN 1.08 14 13 27.68 IN 1.36 15 14 17.41 IN 0.23 16 15 13.51 IN 1.05 17 16 23.46 CB 0.90 18 17 30…. Show more… Show more Business Economics ECON 3300
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades