Scenario:You are curious to see if there is a possible relationship between the number of promotions and total sales.You are provided with the following data:

Number of Promotions Total Sales

8 1900

2 1300

3 1800

6 1500

7 1750

12 2934

10 2700

5 1900

11 2412

1 1200

15 3300

14 3100

9 2193

13 2852

4 1712

Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 7.Please show your work.

Is there a significant relationship?Clearly explain your reasoning using the regression results.