Question 2 Besides their known long-term effects, do cigarettes also cause short-term illnesses such as colds? To help answer this question, a sample of smokers was drawn. Each person was asked to report the average number of cigarettes smoked per day and the number of days absent from work due to colds last year. The following output was obtained as a result of conducting regression analysis using Excel. (Some values are hidden, and referred to as x1, x2 and 3 for the purpose of this question.) SUMMARY OUTPUT Regression Statistics Multiple R 0.443696244 R Square X1 Adjusted R Square 0.193359224 Standard Error 3.996685058 Observations 231 ANOVA df Regression Residual Total 1 229 230 SS 896.6418865 x3 4554.571429 MS 896.641886 15.9734915 Intercept Cigarettes Coefficients 7.286531113 0.189742532 Standard Error 0.988867818 0.02532533 t Stat 7.36855926 X2 a) (9 points) What is the estimated regression equation? b) (6 points) What do the coefficients tell you about the relationship between smoking cigarettes and sick days because of cold days? c) (5 points) Find a point estimate for the number of days absent from work due to cold if a person smokes 10 cigarettes per day on the average. d) (15 points) What is the value of coefficient of determination? Comment on its value. (What does that imply in terms of this problem?) e) (15 points) To determine whether there is sufficient evidence to infer that a linear relationship exist, the following test is to be conducted: Ho: B1 = 0, Hai B1 7 0 How do you assess the linear model based on the above test? (Use a=0.05)