Click on Sheet$1,$ then highlight the cell range B$1$:N$1$ and press CTRL$+$SHIFT$+$DOWN to highlight the cell range B$1$:N$19571$

Select Insert $>$ PivotTable and click OK

Name the new sheet $$Sex vs Subtype$$

On the right side of the window, drag Sex from the list of "PivotTable Fields" to "Rows"

Drag Supervision Offense Type$$from the list of "PivotTable Fields" to "Filters"

Drag Supervision Offense Subtype$$from the list of "PivotTable Fields" to "Columns"

Drag Supervision Offense Subtype$$from the list of "PivotTable Fields" to "Values"

In cell B$1,$ select "Violent" from the pop$-$up menu

In cell A$4,$ type "Sex"

In cell B$3,$ type "Subtype"

Drag the border of cell E$4$ move the Other Violent$$column after the$$Sex column

Under $$Values$,$ select Count of Supervision Offense Subtype $>$ Value Field Settings...

Click the Show Values As$$tab$,$ then change the pop$-$up menu to$\%$ of Column Total and click$$OK

Question at position $13$

$13$

$$

$1$ point$$

Question $13$ is unpinned. Click to pin.$$

View Stimulus$$

Question at position $13$

Of the individuals originally convicted of the following violent crimes, what percentage are female? $($Round to one decimal place.$)$

Assault$$ Question Blank $1$ of $6\%$

Kidnap$$ Question Blank $2$ of $6\%$

Murder$/$Manslaughter$$ Question Blank $3$ of $6\%$

Robbery$$ Question Blank $4$ of $6\%$

Sex$$ Question Blank $5$ of $6\%$

Other Violent$$ Question Blank $6$ of $6\%$