Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
It’s World Statistics Day! To honor the theme of the day, the JMP User Community is having conversations about the importance of trust in statistics and data. And we want to hear from you! Tell us the steps you take to ensure that your data is trustworthy.
First of all, I should say that I am an Engineer with a very basic knowledge in statistics (perhaps thats why I am using JMP :-)
I have a data table with 90,000 rows and 12 columns. One of the columns has a pre-selected role as "Weight". The dataset I have has been sampled from a series of events with each event having its own "Weight". In our literature, it is common to publish Tables with "Unweighted N" and "Weighted N". Unweghted N is the actual sample size and Weighted N being always higher than the Unweighted N (please see attached file). In all my analyses, even if I include the Weight column, I could not calculate the "Weighted N". That is, the total number of rows always adds up to the actual number of rows (90,000). However, the Tabulate functions seems to include the Weights, but again would not display the "Weighted N".
Ahh .. got it. Perhaps I got confused between Weight and Freq procedures in JMP. I did additional reading on the SAS documentation website where they distinguish between both the procedures (http://support.sas.com/kb/22/600.html). Thank you.
One more question: is there a way we could "Tabulate" the Weighted and Unweighted N on the same table using the Tabulate procedure?
I would say that you would need to make two different tables, one weighted and the other not weighted and just present them together, "glueing" them side by side. If you inted to present this in an external program all together it would be very simple.
I would like to take this opportunity to ask the members of the group, in what situations would we get different numbers in a tabulate platform between "N" and "sum wgt" and perhaps it is time for JMP to have "N rows" in this platform and in any other case in which analysis is weighted or using a frequency.