A Company Has Recorded Data on the Weekly Sales for Its

question 6

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}$$ ​

---

Definitions:

Water-Jug Problems

A type of problem that tests one's ability to logically figure out how to measure exact amounts of water using jugs of different sizes.

Unnecessary Constraints

Limitations or restrictions that are not required and may hinder problem-solving or creativity.

Insight

A sudden and often novel realization of the solution to a problem; it contrasts with strategy-based solutions.

Arrangement

The act or process of putting things in a particular order or configuration.