View the step-by-step solution to:

The Art of Modeling with Spreadsheet Home work due 19th, 2010 The center for disease control has collected the following data on cigarette...

How much does advertising impact market penetration? To assess the
impact of advertising in the tobacco industry, a study looked at the
amount of money spent on advertising a particular brand of cigarettes
and brand preference among adolescents and adults. The data are shown
below: (Source: Center for Disease Control Website).
Brand Advertising ($ millions) % Adolescents % Adults
Marlboro 75 60 23.5
Camel 43 13.3 6.7
Newport 35 12.7 4.8
Kool 21 1.2 3.9
Winston 17 1.2 3.9
Benson & Hedges 4 1 3
Salem 3 0.3 2.5

a) Explore the possibility of a linear relation between advertising and brand preference for adults and for adolescent separately. Do there seem to be strong linear relationships, base on a scatter plot and the correlation?
b) Build linear models to represent the relation between advertising and brand preference for these two groups. What preferences would the models predict for advertising of $60 million?
c) Build nonlinear models to represent the relation between advertising and brand preference for these two groups, using the power function y = axB? what preference would the model predict for advertising of $60 million? What are the advantages and disadvantages of a nonlinear model for this relationship?
"
- Sent to Other Homework Expert Tutor on 5/19/2010 at 7:36am

The Art of Modeling with Spreadsheet Home work due 19th, 2010 The center for disease control has col ected the fol owing data on cigarette advertising and brand preferences among adolescents and adults Advertising Brand preference Advertising Brand preference Brand ($ mil ion) Adolescent Brand ($ mil ion) Adult (%) (%) Marlboro 75 60.0 Marlboro 75 23.5 Camel 43 13.3 Camel 43 6.7 Newport 35 12.7 Newport 35 4.8 Kool 21 1.2 Kool 21 3.9 Winston 17 1.2 Winston 17 3.9 Benson & Hedges 4 1.0 Benson & Hedges 4 3.0 Salem 3 0.3 Salem 3 2.5 a) Explore the possibility of a linear relation between advertising and brand preference for adults and for adolescent separately. Do there seem to be strong linear relationships, base on a scatter plot and the correlation? b) Build linear models to represent the relation between advertising and brand preference for these two groups. What preferences would the models predict for advertising of $60 mil ion? c) Build nonlinear models to represent the relation between advertising and brand preference for these two groups, using the power function y = axB? what preference would the model predict for advertising of $60 mil ion? What are the advantages and disadvantages of a nonlinear model for this relationship?
Background image of page 1

Top Answer

We need you to clarify your question for our tutors! Clarification request: Dear Student, We... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online