A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor's product (x). The data resulting from a random sample of 7 weeks follows. Use Excel's Regression Tool to answer the following questions. Week Price Sales 1 .33 20 2 .25 14 3 .44 22 4 .40 21 5 .35 16 6 .39 19 7 .29 15 What is the estimated regression equation

y = 41.603X + 3.582

Step-by-step explanation:

Given the data:

Week ___Price Sales

1 .33 20

2 .25 14

3 .44 22

4 .40 21

5 .35 16

6 .39 19

7 .29 15

Using the linear regression calculator ; The regression equation obtained is :

y = 41.603X + 3.582

Where ;

y = sales (predicted variable)

x = price (predictor variable)

Slope = 41.603

Intercept = 3.582

step-by-step explanation:

fwms@lil_ben06

step-by-step explanation: