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
a. Create a scattergram complete with trend line and regression equation
b. If the competitors price increases to .48, what would be the estimate of sales
c. Perform a t test and determine whether or not x and y are related. Use 0.05
d. Find and interpret the coefficient of determination.
