Posted: September 16th, 2017
Create a scattergram complete with trend line and regression equation
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.
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.