School of Math/Stat Data from a British government survey of household spending may be used to examine the relationship between household spending on tobacco products and alcoholic beverages. You can find this data on the Canvas website. The dataset is called \"tobacco.xls\". 1. (2 points) Tobacco spending is the explanatory variable, and alcohol spending is the response variable. What is the equation of the least-squares regression line? 2. (4 points) Show a scatterplot of the data. Include the least square regression line on the graph. Describe the form, direction and strength of your data. 3. (1 point) What % of the variation in alcohol spending is explained by the least squares regression line? 4. (3 points) Give a 98% confidence interval for the average rate of change of alcohol spending. (Hint: This is another way to say \"slope\") 5. (3 points) Are tobacco spending and alcohol spending independent? Perform a test and state the hypotheses, P-value, and conclusion in terms of the question. 6. (3 points) Make a normal probability plot. Do the points fall around a straight line? (Yes or No) Does the distribution look normal? (Yes or No) 7. (4 points) Make a residual plot. Do the residuals fall randomly around the 0 reference line? (Yes or No) Can you find any clear pattern in the residual plot? (Yes or No) Are there any outliers? (Yes or No) If \"Yes egion alcohol tobacco North 9.47 Yorkshire 9.13 Northeast 9.19 East Midlands 7.89 West Midlands 8.63 East Anglia 7.52 Southeast 8.89 Southwest 7.79 Wales 8.27 Scotland 9.08 North Ireland 9.00 7.03 6.76 6.77 6.34 6.47 5.92 6.20 5.71 6.53 7.51 7.56