A toy company has been marketing souvenir toys in conjunction with various professional sports teams in a number of cities. Over the past few years, this experience has provided some data on the effect of advertising on sales revenues because the advertising expenditures have tended to be different in each case. Although the lengths of advertising campaigns vary, the vast majority of the sales occur within the first three months, which is the time period covered in the data. A summary is shown in the table
Advertising 18 12 5 4 24 26 15 12 16 10 15 12
Revenues 105 72 40 44 135 122 88 77 105 67 98 54
a. Explore the possibility of a linear relation between advertising expenditures and three-month sales revenue. Does there seem to be a strong linear relationship, based on a scatter plot and the correlation?
b. Build a linear model to represent the relationship between advertising and revenue. What revenues would the model predict for expenditures of $2 million and $30 million?
c. As an alternative to the linear model n (b), build a nonlinear model using the power function y=abX. What revenues would the model predict for expenditures of $2 MILLION AND $30 million? What are the advantages and disadvantages of a nonlinear model for this relationship?
Regression completed in Excel for you.