Regression Analysis

solve with explanation

Richard Nodel owns a construction company that builds offices in Detroit. Over time, the company has found that its dollar volume of renovation work is dependent on Detroit area salary levels. The following date is given 1988-1993. Forecast the sales payroll relationship. If the salary will be $600 million, sales will be?

Find the coefficient of correlation also.

Nodels sales ($00,000), y	Local payroll ($00,000,000), x
2.0	1
3.0	3
2.5	4
2.0	2
2.0	1
3.5	7