Create a PivotTable to find the mean and standard deviation of the amount of travel expenses for each sales representative in the accompanying travel expenses data.

LOADING... Click the icon to view the data.

Question content area bottom

Part $1$

Complete the table.

$($Type integers or decimals rounded to two decimal places as$$ needed.$)$

Sales Rep

Average of Expenses

StdDev of Expenses

Crawford

$$$

$$

enter your response here

$$$

$$

enter your response here

Jones

$$$

$$

enter your response here

$$$

$$

enter your response here

Rogers

$$$

$$

enter your response here

$$$

$$

enter your response here

Smith

$$$

$$

enter your response here

$$$

$$

enter your response here

Grand Total

$$$

$$

enter your response here

$$$

$$

enter your response here