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.
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.
No comments:
Post a Comment