Questions- 1)Clearly state your estimated conditional expectation function (sample regression line).Note that you do not need to estimate your equation manually, but rather you should simply write down your sample regression line using the estimated intercept and coefficient of X given in your summary regression output from Excel.2)With reference to your estimated equation, calculate (using a calculator) a 90%confidence interval for the coefficient of X (i.e.?2 ) in the model. In performing this calculation, use the relevant estimated standard error of the estimator of the coefficient of X given in your summary Excel regression output. Give an interpretation of the confidence interval you calculate. 3)Again with reference to your estimated equation, perform a test of the null hypothesis that the coefficient of number of hours of preliminary training provided to a telemarketer ( ?2 ) equals zero against the alternative that it is greater than zero, using the (? 0.05) (i.e. 5%) level of significance. In presenting your answer to this question you are required to use the 6-step hypothesis testing procedure given in the unit summary lecture notes. Again in answering this question, you should use the relevant estimated standard error of the estimator of the coefficient of X given in your summary Excel regression output. 4)Give an interpretation of the realised coefficient of determination value ( r 2 ) given in your summary Excel regression output.?(2 marks) My summary excel regression output is below-question you are required to use the 6-step hypothesis testing procedure given in the unit summary lecture notes. Again in answering this question, you should use the relevant estimated standard error of the estimator of the coefficient of X given in your summary Excel regression output. (3 marks)the? 0.05(i.e. 5%) level of significance. In presenting your answer to this question you are required to use the 6-step hypothesis testing procedure given in the unit summary lecture notes. Again in answering this question, you should use the relevant estimated standard error of the estimator of the coefficient of X given in your summary Excel regression output. (3 marks)confidence interval for the coefficient of X (i.e.?2 ) in the model. In performing this calculation, use the relevant estimated standard error of the estimator of the coefficient of X given in your summary Excel regression output. Give an interpretation of the confidence interval you calculate. (2 marks) (d) Again with reference to your estimated equation, perform a test of the null hypothesis that the coefficient of number of hours of preliminary training provided to a telemarketer ( ?2 ) equals zero against the alternative that it is greater than zero, usingthe? 0.05(i.e. 5%) level of significance. In presenting your answer to this question you are required to use the 6-step hypothesis testing procedure given in the unit summary lecture notes. Again in answering this question, you should use the relevant estimated standard error of the estimator of the coefficient of X given in your summary Excel regression output. (3 marks)

Page Layout Formulas Data Review View Tell me Calibri (Body) v 12 A ab Wrap Text v Paste KY BI UV v MVA FE Merge & Centre v B19 X V fx A B C D E F G H 1 SUMMARY OUTPUT 2 3 Regression Statistics 4 Multiple R 0.54041789 5 R Square 0.2920515 6 Adjusted R S 0.27435278 7 Standard Err 2.3834566 8 Observations 42 9 10 ANOVA 11 SS MS F Significance F 12 Regression 1 93.7415767 93.7415767 16.5012847 0.00022039 13 Residual 40 227.234614 5.68086535 14 Total 41 320.97619 15 16 Coefficients standard Errol t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 17 Intercept -1.9331665 1.99302278 -0.9699671 0.3378918 -5.9612158 2.09488278 -5.9612158 2.09488278 18 4.8014E-05 1.182E-05 4.06217734 0.00022039 2.4126E-05 7.1903E-05 2.4126E-05 7.1903E-05 19