iSixSigma

Regression

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #52852

    Lorax
    Participant

    Morning all,
    A quick questions: I’m doing some linier regression to understand the relationship between individual X variables and my Y.
    I’m doing the regression in Minitab and then again in Excel and am getting very different equations. The R-squared value is the same though.
    What’s happening here?

    0
    #186450

    Robert Butler
    Participant

     I think you will need to provide a bit more information. When you say you get “very different equations” do you mean completely different coefficients, completely different terms, or something else?
     

    0
    #186452

    Lorax
    Participant

    Thanks for replying Robert
    Yeah, everything is different. Excel is saying:
    y = -0.0099x + 0.6148
    with an r-squared of 0.0538
    Minitab is talking about:
    y =  13.58 – 5.404x
    with a r-squared of  0.053
    When I apply a polynomial the equations are still different although the r-squared stays relatively consistent.

     

    0
    #186454

    Ken Feldman
    Participant

    Lorax,
    Send me the data offline and I will look at it.
    [email protected]

    0
Viewing 4 posts - 1 through 4 (of 4 total)

The forum ‘General’ is closed to new topics and replies.