INTRODUCTION TO LINEAR CORRELATION AND REGRESSION ANALYSIS.

An economist with a major bank wants to learn, quantitatively, how much spending on luxury goods and services can be explained based on consumers' perception about the current state of the economy and what do they expect in the near future (6 months ahead).Consumers, of all income and wealth classes, were surveyed.Every year, 1500 consumers were interviewed.The bank having all of the data from the 1500 consumers interviewed every year, computed the average level of consumer confidence (an index ranging from 0 to 100, 100 being absolutely optimistic) and computed the average dollar amount spent on luxuries annually.Below is the data shown for the last 24 years.

DateXY (in thousands of dollars)

199479.155.6

19957954.8

199680.255.4

199780.555.9

199881.256.4

199980.857.3

200081.257

200180.757.5

200280.356.9

200379.455.8

200478.656.1

200578.355.7

200678.355.7

200777.855

200877.754.4

200977.654

201077.656

201178.556.7

201278.356.3

201378.557.2

201478.957.8

201579.858.7

201680.459.3

201780.759.9

Questions:

(i)Measure the strength of the linear association between consumers' moods and the dollar amounts spent on luxury items.

(ii)Construct the linear regression model for the dollar amount spent on luxury goods and services.

(iii)Explain how you would interpret the slope and the intercept of the regression model.

(iv)How well does our model fit the data? Explain what it means.

(v)Do you think that measuring the level of optimism is a good predictor for trying to forecast future spending on luxury items?Explain why or why not.

(vi)How would you be able to improve on the model?You must provide a minimum of two specific ways to go about improving the model.

(vii)If the economist expects that, by year's end, the average level of consumer confidence will hit 81.5 points, how much will be expected by consumers to spend on luxury items?