+ Reply to Thread
Results 1 to 8 of 8

Thread: Independent Variables and Dependent Variable Regression Analysis

  1. #1
    Points: 348, Level: 6
    Level completed: 96%, Points required for next Level: 2

    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Independent Variables and Dependent Variable Regression Analysis




    I came across this question which best explain what a need in one of the forum, however it was not answered. Please assist based on the scenario below:

    I have 3 variables (2 are independent and 1 is dependent). All three variables are measured with questionnaires consisting of multiple questions recorded on 5 point scale. I want to perform regression analysis. How do I go about doing that? My variables are explained below

    Creativity = Q1 + Q2 + Q3 (Do I need to transform Q1-Q3 into single variable representing all three q's of creativity to run regression; if so how to do that?)

    Climate = Q1 + Q2 + Q3 + Q4 + Q5 + Q6 + Q7 + Q8 (Q1-Q8 into single variable)

    Motivation = Q1 + Q2 + Q3 (Q1-Q3 into single variable)

    All the questions (Q1, Q2, ...) are measured on a 5 point scale, 1 for strongly disagree and 5 for strongly agree. I want to run below model.

    Creativity = constant + β1 Climate + β2 Motivation + error

    I am using excel

  2. #2
    Points: 348, Level: 6
    Level completed: 96%, Points required for next Level: 2

    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Independent Variables and Dependent Variable Regression Analysis

    Any help on the question below. I am really starting to panic now.

    Thank you in advance.

  3. #3
    TS Contributor
    Points: 17,749, Level: 84
    Level completed: 80%, Points required for next Level: 101
    Karabiner's Avatar
    Location
    FC Schalke 04, Germany
    Posts
    2,540
    Thanks
    56
    Thanked 640 Times in 602 Posts

    Re: Independent Variables and Dependent Variable Regression Analysis

    Not sure what your actual question is. If several items (e.g. q1, q2, q3)
    jointly represent some construct (e.g. creativity), you can sum them up
    in order to achieve a "creativity" score. You can perform some procedure
    to check if items which are supposed to represent the same construct
    are sufficiently interrelated, e.g. by calculating Cronbach's alpha.

    Or does your question refer to how to perform a regression analysis
    in Excel?

    With kind regards

    K.

  4. #4
    Points: 348, Level: 6
    Level completed: 96%, Points required for next Level: 2

    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Independent Variables and Dependent Variable Regression Analysis

    Thank you for the reply. I have summed up the questions to get a single score for each construct. Thereafter I have performed regression on the summed up score.
    I have attached the excel spreadsheet with the input data tab, Summed Data tab and output tab. May you please review and advise if i have done it correctly?

    Please advise?
    Attached Files

  5. #5
    TS Contributor
    Points: 17,749, Level: 84
    Level completed: 80%, Points required for next Level: 101
    Karabiner's Avatar
    Location
    FC Schalke 04, Germany
    Posts
    2,540
    Thanks
    56
    Thanked 640 Times in 602 Posts

    Re: Independent Variables and Dependent Variable Regression Analysis

    I'm afraid that I can't do it, since I am not accustomed
    with Excel's statstical analyses.

    With kind regards

    K.

  6. The Following User Says Thank You to Karabiner For This Useful Post:

    Mosima (05-14-2015)

  7. #6
    Points: 328, Level: 6
    Level completed: 56%, Points required for next Level: 22

    Posts
    2
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Independent Variables and Dependent Variable Regression Analysis

    Your regression model finds no significant linear relationship: the estimated coefficients of the two independent variables are not significantly different from zero, and adjusted R-squared is actually negative. Some software would just truncate this at zero. I've attached a file with the correlation matrix of the individual question scores. (This created with an add-in available here: http://regressit.com.) There are significant negative correlations between components of the same construct in a few cases. In particular, CLQ1 and CLQ2 have a correlation of -0.448, CLQ5 and CLQ7 have a correlation of -0.653, and MTQ2 and MTQ3 have a correlation of -0.446. Insofar as the construct score is defined as the sum of the relevant question scores, it seems as though you would expect the question scores to be positively correlated with each other. The fact that some of the correlations are negative suggests that the questions are not really measuring the same construct.
    Attached Files

  8. The Following User Says Thank You to fritz For This Useful Post:

    Mosima (05-14-2015)

  9. #7
    Points: 348, Level: 6
    Level completed: 96%, Points required for next Level: 2

    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Independent Variables and Dependent Variable Regression Analysis

    Noted. Thanks Schalke

  10. #8
    Points: 348, Level: 6
    Level completed: 96%, Points required for next Level: 2

    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Independent Variables and Dependent Variable Regression Analysis


    Thanks a lot a Fritz. it means I will need to review my questionnaire.

+ 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