1.Linear Regression

A British government survey of households in Great Britain on weekly household spending on tobacco products and alcohol was conducted. The average results for each item for regions in Great Britain are listed in the table below. Note that amounts are in British pounds sterling ( GBP) written with the symbol () we are not converting to US dollars ($). Your answer will be in pounds sterling. This data can be found in SPSS on Blackboard in the SPSS data tab: Table 9.3.sav

Region Alcohol Tobacco

North 6.47 4.03

Yorkshire. 6.13. 3.76

Northeast. 6.19. 3.77

East Midlands. 4.89 3.34

West Midlands 5.63 3.47

East Anglia. 4.52. 2.92

Southeast 5.89. 3.20

Southwest. 4.79. 2.71

Wales. 5.27 3.53

Scotland. 6.08 4.51

Northern Ireland. 4.02. 4.56

Graph the data with and without the regression line. Do the variables appear to be related? YesNo

Calculate r, the correlation coefficient. Do the variables appear to be related? YesNo

Report r, the correlation coefficient____________

The relationship appears to be PositiveNegativeNot related

If the value of r indicates that average spending on alcohol is a good predictor for average spending on tobacco products, find and report the linear regression equation and predict the amount spend on tobacco for a household that spends 5.50 per week.