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.*

A 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 CB 0.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 12 22.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.53 CB 1.41 19 18 10.88 GE 0.99 20 19 17.23 GE 0.53 21 20 20.77 IN 1.31 22 21 15.33 GE 1.08 23 22 4.41 FI 0.45 24 23 32.70 CB 1.16 25 24 2.37 FI 0.16 26 25 19.16 IN 1.31 27 26 20.70 1,36 28 27 11.32 GE 1.03 29 28 15.31 CB 1.01 310 29 13.98 CB 1.19 31 30 14.4 GE 0.56 32 31 13.57 FI 1.25 33 32 16.91 GE 0.80 34 33 21.25 IN 1.02 35 34 13.50 GE 0.89 36 35 21.99 IN 0.89 37 4.31 FI 0.44 36 37 51.10 CE 1.24 39 38 17.01 GE 0.23 40 39 4.31 FI 0.62 41 40 18.39 IN 0.67 42 41 15.31 GE 1.32 43 42 15 46 GE 1.27 44 43 19.67 IN 1.18 45 4 4 4.63 FI 0.62 46 45 21.77 CB 0.64 47 48 50 52