We are working on pivot tables with grouping. I have no trouble creating a table with variables and totals however, I cannot figure out how I can include Relative Frequencies and Percentage frequencies in the same pivot table - as shown in the book.
Thanks
We don't have your book.
Relative frequencies are the frequencies within the cell(s) divided by the total frquency. The percentage frequency is that decimal divided by 100.
If you want further input repost with adequate data.
To include both relative frequencies and percentage frequencies in the same pivot table, you will need to adjust the values and settings within your pivot table. Here's a step-by-step explanation of how you can do this:
1. Create your initial pivot table with the variables and totals you want to include.
2. Right-click on a value within the pivot table and select "Value Field Settings" or "Summarize Values By," depending on your Excel version.
3. In the "Value Field Settings" dialog box that appears, you can choose the calculation type for the values. By default, it is set to "Sum." Change this to "Count" and click "OK."
4. Now, right-click on the same value again and select "Value Field Settings" (or "Summarize Values By") once more.
5. This time, change the calculation type to "Show values as" and select "Relative to Grand Total" or "Relative to Row Total" from the drop-down menu, depending on your preference. This will give you the relative frequencies.
6. Finally, to add percentage frequencies alongside the relative frequencies, right-click on the same value yet again, and select "Value Field Settings" (or "Summarize Values By").
7. Under "Show values as," select "% of Column Total" or "% of Row Total" from the drop-down menu. This will give you the percentage frequencies.
By following these steps, you should be able to include both relative frequencies and percentage frequencies in the same pivot table just as shown in the book. Remember to adjust the value field settings for each calculation type to achieve the desired result.