MovieFlix - Advertising and Subscriptions Year  Advertising Expenditure       $ 000   Membership Subscriptions 2013                    51 62 2014                    58 68 2015 62 66 2016 65 66 2017                    68 67 2018                    76 72 2019                    77 73 2020                    78 72 2021                    78 78 2022                    84 73 2023                    85 76                     (i) Plot the scattergraph for the data.           (ii) Use the data, to develop a regression equation relating advertising expenditure to membership.   (iii)  Estimate the membership if $40 000 is spent on advertising.              (iv)  How much must be spent on advertising to obtain a membership of 80 (000)?                                                        (iv)  What is the nature of the relationship between advertising expenditure and membership?   (v)  Forecast 2024 membership using an alternative method, clearly explaining the limitations of your selected method.        (vi) What are the limitations of the method used in (i)?

Principles Of Marketing
17th Edition
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Kotler, Philip, Armstrong, Gary (gary M.)
Chapter1: Marketing: Creating Customer Value And Engagement
Section: Chapter Questions
Problem 1.1DQ
icon
Related questions
Question

MovieFlix - Advertising and Subscriptions

Year  Advertising Expenditure
      $ 000
  Membership Subscriptions
2013                    51 62
2014                    58 68
2015 62 66
2016 65 66
2017                    68 67
2018                    76 72
2019                    77 73
2020                    78 72
2021                    78 78
2022                    84 73
2023                    85 76
     
     
     

 

(i) Plot the scattergraph for the data.          

(ii) Use the data, to develop a regression equation relating advertising expenditure to membership.  

(iii)  Estimate the membership if $40 000 is spent on advertising.             

(iv)  How much must be spent on advertising to obtain a membership of 80 (000)?                                                       

(iv)  What is the nature of the relationship between advertising expenditure and membership?  

(v)  Forecast 2024 membership using an alternative method, clearly explaining the limitations of your selected method.       

(vi) What are the limitations of the method used in (i)?         

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 8 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
Principles Of Marketing
Principles Of Marketing
Marketing
ISBN:
9780134492513
Author:
Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:
Pearson Higher Education,
Marketing
Marketing
Marketing
ISBN:
9781259924040
Author:
Roger A. Kerin, Steven W. Hartley
Publisher:
McGraw-Hill Education
Foundations of Business (MindTap Course List)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing: An Introduction (13th Edition)
Marketing
ISBN:
9780134149530
Author:
Gary Armstrong, Philip Kotler
Publisher:
PEARSON
MKTG 12:STUDENT ED.-TEXT
MKTG 12:STUDENT ED.-TEXT
Marketing
ISBN:
9781337407595
Author:
Lamb
Publisher:
Cengage
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning