Data is collected on the number of building permits issued each month and the mortgage interest rate in that particular month. Following is an EXCEL output of the regression of BP on Int (where BP is number of building permits issued and Int is the interest rate at the time the building permit is issued. Use this output when answering the following questions. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square 0.917 Standard Error 63.385 Observations 12 ANOVA of 55 MS F Significance F Regression 1 492710.6 492710.6 122.635 0.000 Residual 10 40177.09 4017.709 Total 11 532887.7 Coefficientstandard Erro t Stot P-value Lower 95% Upper 95% Lower 99.0% Upper 99.016 Intercept 2084.028 118.707 17.556 0.000 1819 531 2348 524 1707 813 2460.242 Int 7.821 -11 074 0.000 -104.036 69.184 -111 397 61 823 i) Unfortunately, they are two values missing from the table (they are the letters A and B in bold). Calculate the missing values A and B. ii) State the equation showing that building permits are a function of the interest rate. Give a brief interpretation of the equation. Is this result as you expected? iii) Test whether there is a relationship between number of building permits issued and interest ret and hence whether interest rate should be included in the regression model to explain number of building permits issued. iv) It is believed that the higher the interest rate, the few the number of building permits issued. Is the slope coefficient consistent with this hypothesis? Briefly justify your answer. v) Use the information from the ANOVA table to test if R-=0. Briefly explain whether this is the same as testing the coefficient on interest rate equals to zero or not vi) What is the 95% confidence interval for the coefficient on Int? What is a 99% confidence interval. Why do they differ