A Company Has Recorded Data on the Weekly Sales for Its

Essay

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 seven weeks follows. Use Excel to develop a scatter diagram and to compute the least squares estimated regression equation and the coefficient of determination. $$\begin{array} { l l l } \text { Week } & \text { Price } & \text { Sales } \\\hline 1 & 0.33 & 20 \\2 & 0.25 & 14 \\3 & 0.44 & 22 \\4 & 0.40 & 21 \\5 & 0.35 & 16 \\6 & 0.39 & 19 \\7 & 0.29 & 15\end{array}$$ ​