+ Reply to Thread
Results 1 to 7 of 7

Thread: Regression help

  1. #1
    Points: 8, Level: 1
    Level completed: 15%, Points required for next Level: 42

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Regression help




    I ran a regression of event sales (y) and advertising spending (x). I got the following results:

    Correlation: .055
    R2: .003
    N: 438
    y = 1.28x + 26492

    I believe this verifies my theory that our advertising is not producing much sales. However, events have some contractual advertising. How can I take this into consideration? Do these obligations matter when considering additional marginal sales? Should I even be running a linear regression for this type of analysis?

  2. #2
    Omega Contributor
    Points: 38,432, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    7,006
    Thanks
    398
    Thanked 1,186 Times in 1,147 Posts

    Re: Regression help

    I would recommend creating a histogram for both variables then just plotting these data together as well to get a general feel for the relationship.
    Stop cowardice, ban guns!

  3. #3
    Points: 900, Level: 15
    Level completed: 50%, Points required for next Level: 100

    Posts
    12
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Regression help

    Hello,

    you might test a moderation effect. You must include in your model the events so that you can determine whether these events significantly influence sales in interaction with the advertising spending.

  4. #4
    Omega Contributor
    Points: 38,432, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    7,006
    Thanks
    398
    Thanked 1,186 Times in 1,147 Posts

    Re: Regression help

    Please describe your variables more thoroughly. You have sales at events (y) and "general" advertising (x), what is contractual advertising? Is it specific advertising for the events, not general advertising?
    Stop cowardice, ban guns!

  5. #5
    Points: 8, Level: 1
    Level completed: 15%, Points required for next Level: 42

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Regression help

    I am trying to determine how much of an affect our advertising spending (print, online, tv, etc) has on generating ticket sales to events. All of these events are individual concerts and have their own advertising budget. I plotted a scatter plot of ad spending against ticket revenue and show a minimal relationship. I am questioning the result of the constant I am getting in the equation. It seems unlikely to me that the vast majority of sales would take place with no advertising. Additionally each concert has some advertising requirements so I am trying to take this into consideration.

  6. #6
    TS Contributor
    Points: 14,811, Level: 78
    Level completed: 91%, Points required for next Level: 39
    Miner's Avatar
    Location
    Greater Milwaukee area
    Posts
    1,171
    Thanks
    34
    Thanked 405 Times in 363 Posts

    Re: Regression help

    Try a plot of ad $s vs. ticket sales by type of advertising. I would expect certain types of advertising to be more/less effective than other forms.

  7. #7
    Omega Contributor
    Points: 38,432, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    7,006
    Thanks
    398
    Thanked 1,186 Times in 1,147 Posts

    Re: Regression help


    The type of event may have hetergeneity of effects (slopes) and intercepts. You may want to collapse event into groups and investigate multilevel modeling. Which could control for these in such a model, though the statistics are much much more complex.
    Stop cowardice, ban guns!

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats