+ Reply to Thread
Results 1 to 7 of 7

Thread: Multiple Regression Analysis Issue

  1. #1

    Multiple Regression Analysis Issue




    Hi everyone I have just signed up!

    I am currently doing a thesis & struggling with my regression model. I am examining the link between profit levels debt levels in the oil and gas industry. My Dependent variable is Profitability, Independent variables are Debt/Size of company/Growth rate of sales & a dummy variable for Company Type.

    My data has 66 companies, spanning 11 years.

    I have run individual cross-section regressions across each of the 11 years. However, to test certain hypotheses do I need an 'overall' cross-section which includes all 11 years worth of data? I do not have the software to run panel data analysis (SPSS). Is this even possible? (taking into account the time-series aspect)

    Obviously I do not intend to run 11x4 sets of hypotheses tests! All help is greatly appreciated.

  2. #2
    ggplot2orBust
    Points: 71,220, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    User with most referrers
    trinker's Avatar
    Location
    Buffalo, NY
    Posts
    4,417
    Thanks
    1,811
    Thanked 928 Times in 809 Posts

    Re: Multiple Regression Analysis Issue

    I don't use SPSS but I love the UCLA website and they have a bit about SPSS and repeated measures: http://www.ats.ucla.edu/stat/spss/se...es/default.htm
    "If you torture the data long enough it will eventually confess."
    -Ronald Harry Coase -

  3. #3
    Points: 24, Level: 1
    Level completed: 47%, Points required for next Level: 26

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Regression Analysis Issue

    Wow that all seems awful complex and beyond me at this point!

    Is it possible to run one regression across all years of data and variables? Is this legitimate?

  4. #4
    TS Contributor
    Points: 17,779, Level: 84
    Level completed: 86%, Points required for next Level: 71
    Karabiner's Avatar
    Location
    FC Schalke 04, Germany
    Posts
    2,542
    Thanks
    56
    Thanked 640 Times in 602 Posts

    Re: Multiple Regression Analysis Issue

    Maybe you can create a file with 11*66 cases where in addition to your
    present measurements you add an identifying variable for "company".
    You could then run analyses of covariance where company is included
    as a factor.

    Kind regards

    K.

  5. #5
    Points: 1,980, Level: 26
    Level completed: 80%, Points required for next Level: 20
    derksheng's Avatar
    Posts
    247
    Thanks
    49
    Thanked 35 Times in 28 Posts

    Re: Multiple Regression Analysis Issue

    Quote Originally Posted by 1114368@rgu.ac.uk View Post
    Wow that all seems awful complex and beyond me at this point!

    Is it possible to run one regression across all years of data and variables? Is this legitimate?
    Google "Pooled OLS", and "Panel Data OLS". View this post:

    http://stats.stackexchange.com/quest...se-ols-over-it

    How much longer do you have on your thesis? If you have a while you should invest in a free language like R.

    Or perhaps just ask your supervisor what language they use - use the same and ask for his code that you can learn off. Might be matlab, guass, R, ... Although some corporate finance guys use VBA or Excel for some crazy reason. If this is the case just use R.

    Also you should just ask for what specifications to estimate at this early stage in your thesis. Don't try to surprise your supervisor with a lot of progress to impress them. It'll likely be useless - you're just a 3rd year student, anything you make up won't be good.
    Last edited by derksheng; 09-12-2012 at 03:44 AM.

  6. #6
    Points: 24, Level: 1
    Level completed: 47%, Points required for next Level: 26

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Regression Analysis Issue

    Ok thanks for the help guys.

  7. #7
    Points: 136, Level: 2
    Level completed: 72%, Points required for next Level: 14

    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Regression Analysis Issue


    Hi Guys!

    I have also a problem with multiple regression. I don't how to treat the data I gathered from the respondents of my study. The data for independent variables include range of values (i.e. 1M-1.5M) and so on. Can you help me with this one? I'm guessing I can use arithmetic mean (i.e. 1M+1.5 divided by 2) then use the average as input for the model.

+ Reply to Thread

           




Tags for this 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