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

Select Insert $>$ PivotTable and click OK

Name the new sheet $$Age vs Type$$

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

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

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

In cell A$4,$ type "Age"

In cell B$3,$ type "Offense Type"

Drag the border of cell C$4$ to move the Other$$column after the$$Violent column

Under $$Values$,$ select Count of Supervision Offense Type $>$ 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 $11$

$11$

$$

$1$ point$$

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

$$

Question at position $11$

What percentage of violent criminals were $27$ years old? $($Round to one decimal place.$)$

What percentage of violent criminals were $27$ years old? $($Round to one decimal place.$)$