cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
diegoc11
Level I

Why is regression output from JMP different from Excel?

Hey everyone,

I've attached an excel file that has some data (One dependent variable = WTP, and two independent variables).

The second tab has the regression output from excel, which we've used in classes at school all the time. What I don't understand is why regressing the same variable as least squares fit in JMP produces a different adjusted R^2, coefficients, p-values, etc.

Can anyone help me address any settings, etc. that might be taking place?

I'm using JMP 9 and excel's data analysis toolkit in Office 2010.

Thanks,

Diego

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Why is regression output from JMP different from Excel?

I tried to reproduce the analysis in JMP and I got exactly the same numbers as in your file's second tab. Run the saved script of the model I used and look for what differ from the model you tried in JMP.

Fit Model(

          Y( :WTP ),

          Effects( :Name( "Frozen/Fresh" ), :Name( "Wild/Farmed" ) ),

          Keep dialog open( 1 ),

          Personality( "Standard Least Squares" ),

          Emphasis( Effect Leverage ),

          Set Alpha Level( 0.05 ), Run

);

View solution in original post

3 REPLIES 3
ms
Super User (Alumni) ms
Super User (Alumni)

Why is regression output from JMP different from Excel?

I tried to reproduce the analysis in JMP and I got exactly the same numbers as in your file's second tab. Run the saved script of the model I used and look for what differ from the model you tried in JMP.

Fit Model(

          Y( :WTP ),

          Effects( :Name( "Frozen/Fresh" ), :Name( "Wild/Farmed" ) ),

          Keep dialog open( 1 ),

          Personality( "Standard Least Squares" ),

          Emphasis( Effect Leverage ),

          Set Alpha Level( 0.05 ), Run

);

diegoc11
Level I

Why is regression output from JMP different from Excel?

Thanks MS,

It looks like my excel isn't set up correctly.

Cheers mate!,

Diego

larryworley
Level I

Why is regression output from JMP different from Excel?

How different are your results? 

Since Excel treats numeric data differently than either JMP and SAS and since it also has its own regression algorithms, I would not be suprised to see differences.  If differences are minor, then I would suspect these might account for the differences.

If the differences are large, I would suspect an issue with Excel and not with your excel setup.

Can you post your JMP results?