LAB WORK (EXCEL) Date MeDonalds Corp Federal Funds Ratc (Effective) 30-Jan-09 27-Feb-00 31-Mar-09 30-Apr-09 29-May-09 30-Jun-09 31-Jul-09 31-Aug-09 30-Sep-09 30-Oct-09 30-Nov.09 31-Dec-09 S 59.53 $6.21 53.31 55.19 55.01 SR25 $7.07 55.79 55.92 58.02 62.72 62.32 FED 0.15 0.22 0.18 0.15 0.18 0.21 0.16 0.16 0.15 0.12 0.12 0.12 US Industrial Prodaction Index Level (Federal Reserve) IP 88.50 87.20 86.50 85.70 85.50 86.70 87.80 88.40 88.60 89.10 89.60 90.50 From the given data of stock price of McDonald's Corp (S), US Federal Funds Rate (FED), and US Industrial Production Index (IP), provide the answer the following questions - Generate mean, median, mode, standard deviations, variance, range, minimum and maximum values for all the three variables of interest. Also give your interpretations. 6. Generate the correlations matrix from MS excel and interpret the results. Get the excel results for Multiple Regression assuming McDonald's Corp share price (S) as dependent variable and FED and IP as independent variables. Write down the fitted multiple regression equation derived from the MS excel. Interpret two B's Test the Individual significance of the regression hypothesis at the 5% level of significance. Test the Overall significance of the regression hypothesis at the 5% level of significance A. Interpret R Square