+ Reply to Thread
Results 1 to 8 of 8

Thread: Is Slope A statistically different from Slope B? *URGENT*

  1. #1
    Points: 325, Level: 6
    Level completed: 50%, Points required for next Level: 25

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Is Slope A statistically different from Slope B? *URGENT*




    Hey everyone,

    Really need urgent help here.

    I am trying to determine if the change in the slope of a line (beta) is statistically significant due to a particular event. As such, how do you test if the slope of line A is statistically different from the slope of line B?

    For instance, let's say i'm investigating the beta of Apple's stock, when regressed against the S&P 500.
    Regression 1 - 2005-2006 (24 monthly observations), Beta = 0.8
    Regression 2 - 2007-2009 (36 monthly observations), Beta = 0.5 (decrease)

    How do I determine if this change in beta is statistically different over the two different time periods? Do I apply a t-test? If so, what's the formula to do so?

    (I have also deliberately used 2 different sample sizes for the 2 regressions. Please highlight to me if this affects the statistical testing.)

    Also, I've noticed that the t-test has always been applied to means or proportions, but never to the slope (beta). As such, is there something wrong with my concept or use of terminologies? Hope you experts can clarify this with me. I really need your help! Thanks in advance everyone
    Last edited by explicit; 03-06-2012 at 01:03 AM.

  2. #2
    ggplot2orBust
    Points: 36,337, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    User with most referrers
    trinker's Avatar
    Location
    Buffalo, NY
    Posts
    4,000
    Thanks
    1,416
    Thanked 769 Times in 687 Posts

    Re: Is Slope A statistically different from Slope B? *URGENT*

    You can go in and delete the double post yourself.

    I think you want to compare two independant correlations. If so this is the formula:



    where:

    {S}_{\hat{\beta}_{A}-\hat{\beta}_{B}}=\sqrt{S^{2}_{{\beta}_{A}} + S^{2}_{{\beta}_{B}}}


    and for degrees freedom:



    where:

    "If you torture the data long enough it will eventually confess."
    -Ronald Harry Coase -

  3. The Following User Says Thank You to trinker For This Useful Post:

    explicit (03-06-2012)

  4. #3
    Points: 325, Level: 6
    Level completed: 50%, Points required for next Level: 25

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Is Slope A statistically different from Slope B? *URGENT*

    Thanks for your reply!! Been looking all over the net but to no avail.

    Basically, i'm comparing the pre-event beta and post-event beta and I want to determine if this change in beta is statistically significant.

    Are you able to explain or direct me to your source? I'm quite clueless with the symbols in the formula. Or is there any excel file or youtube video to illustrate this?

    If let's say:
    Beta(A) = 0.8
    Standard error of regression line (A) = 0.015

    Beta (B) = 0.5
    Standard error of regression line (B) = 0.012

    Then do I take (0.8 - 0.5) / (0.015 - 0.012)? Kindly clarify. Thanks in advance!

    Will go delete the previous double post now!
    Last edited by explicit; 03-06-2012 at 12:46 AM.

  5. #4
    Points: 325, Level: 6
    Level completed: 50%, Points required for next Level: 25

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Is Slope A statistically different from Slope B? *URGENT*

    Anyone able to provide some input to help me out?

  6. #5
    Points: 785, Level: 14
    Level completed: 85%, Points required for next Level: 15

    Posts
    10
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Is Slope A statistically different from Slope B? *URGENT*

    Hi,
    The easiest way to do that is to run an ANCOVA model with 1 factor (with as categories 1 value per regression line you want to create) and your explanatory variables (X1, X2,...). In the model you will have Stock value (Y)= intercept + Factor+Factor*X1+Factor*X2...
    Then you can use a test to compare the slopes.
    This is all done in XLSTAT if you select the compare slopes option in the Ouputs tab.
    Hope it helps,
    Camille

  7. #6
    R must die
    Points: 26,177, Level: 96
    Level completed: 83%, Points required for next Level: 173
    noetsi's Avatar
    Posts
    4,701
    Thanks
    316
    Thanked 742 Times in 712 Posts

    Re: Is Slope A statistically different from Slope B? *URGENT*

    Within subject ANOVA (also called repeated measures) is a way to address this as I think camille suggested above
    Advanced Idea Mechanics: The Ideas of Tomorow. Today

  8. #7
    Cookie Scientist
    Points: 9,403, Level: 65
    Level completed: 18%, Points required for next Level: 247
    Jake's Avatar
    Location
    Boulder, CO
    Posts
    1,143
    Thanks
    46
    Thanked 480 Times in 367 Posts

    Re: Is Slope A statistically different from Slope B? *URGENT*

    Quote Originally Posted by explicit View Post
    How do I determine if this change in beta is statistically different over the two different time periods?
    Add and test an interaction term.

    Stock_i = \beta_0 + \beta_1*Month_i + \beta_2*Period_i + \beta_3*Month_i*Period_i + \epsilon_i

    You want to test \beta_3.
    “In God we trust. All others must bring data.”
    ~W. Edwards Deming

  9. #8
    ggplot2orBust
    Points: 36,337, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    User with most referrers
    trinker's Avatar
    Location
    Buffalo, NY
    Posts
    4,000
    Thanks
    1,416
    Thanked 769 Times in 687 Posts

    Re: Is Slope A statistically different from Slope B? *URGENT*


    Oh yeah my suggestion definitely wrong as your betas certainly aren't independent. My apologies.
    "If you torture the data long enough it will eventually confess."
    -Ronald Harry Coase -

+ 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