years X i bonus Y i X i Y i X i 2 4 5.7 22.8 16 2 3.5 7 4 7.4 10.1 74.74 54.76 5 9 45 25 2 2.7 5.4 4 12 12 144 144 Are years of service and annual bonuses related? The annual bonuses of 6 randomly...

 Are years of service and annual bonuses related?  The annual bonuses of 6 randomly selected employees (measured in “thousands of dollars”) along their their respective years of service for the company.  Suppose we estimate a linear regression using the Ordinary Least Squares technique of the form:

Bonus_i = b₀ + b₁(years_i)

where the subscript i indicates the i^th employee

Using excel to complete this problem, what is the numerical value of b₁and its associated p value