如何创建包含原始频数、累计原始频数等四类指标的统计频数表？
Got it, let's walk through how to build that frequency table with all four metrics you need using the GSS dataset on Berkeley SDA. I’ve tinkered with this tool plenty, so I’ll break it down step by step that’s easy to follow:
First, since you’ve already recoded the sexual partner count into your custom groups, head to the variable interface and locate your re-coded variable (you might’ve named something like partners_grouped). Click into it to open the analysis setup page.
On the analysis setup page, find the Table Options section (it might be labeled "Statistics" or "Output Measures" depending on the SDA version):
- Make sure your recoded variable is set as the Row Variable—this is what we’ll calculate frequencies for.
- In the "Frequency Measures" subsection, check these four options explicitly:
- Raw frequency (usually checked by default, but double-confirm)
- Cumulative raw frequency (sometimes called "Cumulative Count" in older SDA interfaces)
- Relative frequency (look for "Proportion" if you want a 0-1 value, or "Percent" for a 0-100 percentage—both count as relative frequency)
- Cumulative percentage (this should be clearly labeled; don’t skip this one)
In the "Row Categories" area, double-check that your custom groups (the ranges you set) are listed correctly. If you want to exclude missing values (like "Don’t know" or "Refused"), tick the "Exclude missing values" box—this keeps your table clean and ensures cumulative percentages add up to 100%.
Scroll to the bottom of the page and hit Run Table (or "Generate Output"). SDA will spit out a formatted table that includes all four metrics you requested. Here’s a quick example of what it might look like:
| Partner Group | Raw Frequency | Cumulative Raw Frequency | Relative Frequency | Cumulative Percentage |
|---|---|---|---|---|
| 0-1 Partners | 1245 | 1245 | 46.2% | 46.2% |
| 2-3 Partners | 872 | 2117 | 32.3% | 78.5% |
| 4+ Partners | 573 | 2690 | 21.5% | 100.0% |
- If you can’t find cumulative metrics: Some SDA versions hide these in an Advanced Statistics dropdown—expand that section and you’ll see them.
- Relative frequency vs. percentage: Pick the format that fits your needs; both are valid relative frequency measures.
- Cumulative percentage doesn’t hit 100%: You probably forgot to exclude missing values—go back and check that box.
内容的提问来源于stack exchange，提问作者yre
