Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a PivotTable to find the mean and standard deviation of the amount of travel expenses for each sales representative in the Excel file Travel

Create a PivotTable to find the mean and standard deviation of the amount of travel expenses for each sales representative in the Excel file Travel Expenses.image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & I & J & K \\ \hline 1 & Travel Expenses & & & & & & & & & & \\ \hline 2 & & & & & & & & & & & \\ \hline 3 & Date & Sales Rep & Expenses & & & & & & & & \\ \hline 4 & 3/2/14 & Crawford & $221.25 & & & \multirow{6}{*}{\multicolumn{5}{|c|}{\begin{tabular}{l} Create a PivotTable to find the mean and standard \\ deviation of the amount of travel expenses for each \\ sales representative in the Excel file Travel Expenses. \end{tabular}}} & \\ \hline 5 & 3/6/14 & Crawford & $80.22 & & & & & & & & \\ \hline 6 & 3/7/14 & Crawford & $232.94 & & & & & & & & \\ \hline 7 & 3/12/14 & Crawford & $89.14 & & & & & & & & \\ \hline 8 & 3/13/14 & Crawford & $110.15 & & & & & & & & \\ \hline 9 & 3/16/14 & Crawford & $198.18 & & & & & & & & \\ \hline 10 & 3/18/14 & Crawford & $208.84 & & & & & & & & \\ \hline 11 & 3/19/14 & Crawford & $161.70 & & & & & & & & \\ \hline 12 & 3/20/14 & Crawford & $192.56 & & & & & & & & \\ \hline 13 & 3/21/14 & Crawford & $216.11 & & & & & & & & \\ \hline 14 & 3/24/14 & Crawford & $151.06 & & & & & & & & \\ \hline 15 & 3/25/14 & Crawford & $109.53 & & & & & & & & \\ \hline 16 & 3/26/14 & Crawford & $188.84 & & & & & & & & \\ \hline 17 & 3/29/14 & Crawford & $137.71 & & & & & & & & \\ \hline 18 & 3/3/14 & Jones & $92.69 & & & & & & & & \\ \hline 19 & 3/6/14 & Jones & $232.06 & & & & & & & & \\ \hline 20 & 3/7/14 & Jones & $197.33 & & & & & & & & \\ \hline 21 & 3/12/14 & Jones & $148.84 & & & & & & & & \\ \hline 22 & 3/15/14 & Jones & $273.53 & & & & & & & & \\ \hline 23 & 3/16/14 & Jones & $262.16 & & & & & & & & \\ \hline 24 & 3/17/14 & Jones & $196.93 & & & & & & & & \\ \hline 25 & 3/19/14 & Jones & $81.68 & & & & & & & & \\ \hline 26 & 3/20/14 & Jones & $96.63 & & & & & & & & \\ \hline 27 & 3/22/14 & Jones & $155.57 & & & & & & & & \\ \hline 28 & 3/23/14 & Jones & $256.16 & & & & & & & & \\ \hline 29 & 3/25/14 & Jones & $198.95 & & & & & & & & \\ \hline 30 & 3/28/14 & Jones & $166.08 & & & & & & & & \\ \hline 31 & 3/29/14 & Jones & $266.85 & & & & & & & & \\ \hline 32 & & & & & & & & & & & \\ \hline 33 & & & & & & & & & & & \\ \hline 34 & & & & & & & & & & & \\ \hline 35 & & & & & & & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For Managers

Authors: E. Martinez Abascal

1st Edition

0077140079, 9780077140076

More Books

Students also viewed these Finance questions