# Excel and your personalized data set | My Assignment Tutor

(a) Use the built regression tool in Excel and your personalized data set (see above) toestimate the simple regression of sales revenue in dollars (Y) generated by atelemarketer in his/her first year of completed service on the number of hours ofpreliminary training provided to a new telemarketer (X). (2 marks)(b) Clearly state your estimated conditional expectation function (sample regression line).Note that you do not need to estimate your equation manually, but rather you shouldsimply write down your sample regression line using the estimated intercept andcoefficient of X given in your summary regression output from Excel. (1 mark)(c) Clearly state your estimated conditional expectation function (sample regression line).Note that you do not need to estimate your equation manually, but rather you shouldsimply write down your sample regression line using the estimated intercept andcoefficient of X given in your summary regression output from Excel. (1 mark)(d) 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 thiscalculation, use the relevant estimated standard error of the estimator of thecoefficient of X given in your summary Excel regression output. Give aninterpretation of the confidence interval you calculate. (2 marks)(e) Again with reference to your estimated equation, perform a test of the null hypothesisthat the coefficient of number of hours of preliminary training provided to atelemarketer (β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 thisquestion you are required to use the 6-step hypothesis testing proceduregiven in the unit summary lecture notes. Again in answering thisquestion, you should use the relevant estimated standard error of theestimator of the coefficient of X given in your summary Excel regressionoutput. (3 marks)f) Give an interpretation of the realized coefficient of determinationvalue ( r2 ) given in your summary Excel regression output.(2 marks)

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER