Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
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
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
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.
