Author:
Christine Farr

School of Math/StatData from a British government survey of household spending may be used to examinethe relationship between household spending on tobacco products and alcoholicbeverages.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 isthe 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 lineon 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 leastsquares regression line?4.(3 points) Give a 98% confidence interval for the average rate of change ofalcohol spending. (Hint: This is another way to say “slope”)5.(3 points) Are tobacco spending and alcohol spending independent? Perform atest 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”, where is the outlier? Please circle the outlier point in the residual plot,(and if you have time, find its corresponding region in the dataset).1SPSS instructions for Lab 9Download the dataset from course website and save it on your desktop and open it by SPSS.(1)

Tutorial