Frequency and Trend Analysis Exercise check attachments
If you’re not seeing the two-category coding of CLEARED….
Copy and paste your new variable (with the two categories) to yet a new column.
Delete the old version of your new variable (where you created the two categories).
Run the pivot table with the copied-and-pasted version of the variable (with two categories).
To get around the missing values for FORCE…
Enter them. If force was used to gain entry, then it’s a “Y”. If no force was used to gain entry (or there is no information there telling you force was used), then it’s an “N”.
When there are no blank cells, “Control” + “Shift” + “↓” should work fine.
