## Excel work 1. Using the data below perform the regression analysis: use an average income as an X variable and Salse in Millions. After getting your results specify what are the coeficients next to X and intercept. 2. Present graphically gregression line (choose an option for it). 3. Create the columns or spearate worksheet to represent th y=a+bX as a trend line. 4. Using you new columns enter the data for average income of 45000 and 54000. What is expected sales of homes in millions?

Excel work
1. Using the data below perform the regression analysis: use an average income as an X variable and Salse in Millions. After getting your results specify what are the coeficients next to X and intercept.
2. Present graphically gregression line (choose an option for it).
3. Create the columns or spearate worksheet to represent th y=a+bX as a trend line.
4. Using you new columns enter the data for average income of 45000 and 54000. What is expected sales of homes in millions?

Average Income Sales in Millions
35000 110
36000 120
34,500 120
36000 130
37000 135
38000 145
38000 145
39000 152
42000 155