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

- Start Article
- 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
(4053 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 3

- 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

Why is regression output from JMP different from Excel?

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

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?