Explore the possibility of a linear relation between advertising expenditures and three-month sales revenue.
Not what you're looking for?
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
($M)
Revenues 105 72 40 44 135 122 88 77 105 67 98 54
($M)
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?
Purchase this Solution
Solution Summary
Regression completed in Excel for you.
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.