7).

C&A has just entered the HDTV market and would like to use Excel to perform a linear regression forecast for the sales of its HDTV. C&A entered the past six month's sales figures in Excel starting in cell A1:

Month	X	Sales (in $'000)
May	1	10
June	2	20
July	3	60
August	4	50
September	5	80
October	6	60

Based on the attached summary output of the regression analysis, what are the values of a and b in the regression equation Y = a + b X

8).

C&A has just entered the HDTV market and would like to use Excel to perform a linear regression forecast for the sales of its HDTV. C&A entered the past six month's sales figures in Excel starting in cell A1:

Month	X	Sales (in $'000)
May	1	10
June	2	20
July	3	60
August	4	50
September	5	80
October	6	60

Answer the following questions based on the attached summary output of the regression analysis. What is the sales forecast for December?

9).

C&A has just entered the HDTV market and would like to use Excel to perform a linear regression forecast for the sales of its HDTV. C&A entered the past six month's sales figures in Excel starting in cell A1:

Month	X	Sales (in $'000)
May	1	10
June	2	20
July	3	60
August	4	50
September	5	80
October	6	60

Based on the attached summary output of the regression analysis, what is the value of the correlation coefficient?

10).

C&A has just entered the HDTV market and would like to use Excel to perform a linear regression forecast for the sales of its HDTV. C&A entered the past six month's sales figures in Excel starting in cell A1:

Month	X	Sales (in $'000)
May	1	10
June	2	20
July	3	60
August	4	50
September	5	80
October	6	60

Based on the attached summary output of the regression analysis, what conclusion can be drawn?