2. an analyst for a large corporation wants to determine if there is a regression relationship between sales (dependent variable) and advertising expenditure. there is data from 9 years which you tabulate as follows:

Year	Advertising (millions of $)	Sales (millions of $)
1	4	41
2	6	43
3	10	45
4	12	47
5	14	49
6	17	54
7	21	59
8	23	61
9	26	64

a) Do a linear regression analysis by hand.

b) Use an F-test to determine whether your regression is significant for alpha = 0.05 Do by hand.