A national chain of consumer electronics stores had the business objective of determining the effectiveness of newspaper

Question:

A national chain of consumer electronics stores had the business objective of determining the effectiveness of newspaper advertising. To promote sales, the chain relies heavily on local newspaper advertising to support its modest exposure in nationwide television commercials. A sample of 20 cities with similar populations and monthly sales totals were assigned different newspaper advertising budgets for one month. The following table on page 581, stored in Advertising, summarizes the sales (in $millions) and the newspaper advertising budgets (in $thousands) observed during the study:
a. Construct a scatter plot for newspaper advertising and sales.
b. Fit a quadratic regression model and state the quadratic regression equation.
c. Predict the monthly sales for a city with newspaper advertising of $20,000.
d. Perform a residual analysis on the results and determine whether the regression assumptions are valid.
e. At the 0.05 level of significance, is there a significant quadratic relationship between monthly sales and newspaper advertising?
A national chain of consumer electronics stores had the business
f. At the 0.05 level of significance, determine whether the quadratic model is a better fit than the linear model.
g. Interpret the meaning of the coefficient of multiple determination.
h. Compute the adjusted r2.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 772

7th Edition

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

Question Posted: