turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Why is regression output from JMP different from Excel?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jan 12, 2012 7:09 PM
(3190 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

**)**;

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

**)**;

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Thanks MS,

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

Cheers mate!,

Diego

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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?