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

- JMP User Community
- :
- Discussions
- :
- How do I do a Chi-Square test with duplicate rows of data?

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

Highlighted

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

Created:
May 30, 2019 7:11 AM
| Last Modified: May 30, 2019 10:32 AM
(2525 views)

I'm trying to do a Chi-Square test. I have multiple rows of data for individual restaurants. I only need one row per restaurant because the type of cuisine for each restaurant is constant between months. Should I reformat the data or is there a way to do the Chi-Square test with the data in the picture?

(I wouldn't have to worrry about this problem if I had the same number of months per restaurant, however I do not.)

- Tags:
- beginner
- chi-square

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

This is a quick way with a summary table.

- Select Tables > Summary.
- Select Ticket, Cuisine, and Sig, then click Group.
- Click OK.

Now use the new summary table,

- Select Analyze > Fit Y by X
- Select Cuisine and click Y
- Select Sig and click X
- Click OK.

Your mosaic plot and contingency table should depict the conditional probabilities and the Chi square test should be at the bottom.

Learn it once, use it forever!

3 REPLIES 3

Highlighted
##

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

Re: How do I do a Chi-Square test with duplicate rows of data?

I test of what, in terms of the variables you show in the picture of the data table?

Learn it once, use it forever!

Highlighted
##

A test of whether there is a significant difference in the frequency of cuisine type between Sig of 0 restaurants and Sig of 1 restaurants.

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

Re: How do I do a Chi-Square test with duplicate rows of data?

Highlighted

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

This is a quick way with a summary table.

- Select Tables > Summary.
- Select Ticket, Cuisine, and Sig, then click Group.
- Click OK.

Now use the new summary table,

- Select Analyze > Fit Y by X
- Select Cuisine and click Y
- Select Sig and click X
- Click OK.

Your mosaic plot and contingency table should depict the conditional probabilities and the Chi square test should be at the bottom.

Learn it once, use it forever!

Article Labels

There are no labels assigned to this post.