$\backslash$table$[[1,$OrderDate,$R,$ED$,$Item,Units,Unit Cos,Total$],[2,1/6/14,$East,Jones,Pencil,$95,1\mathrm{.}99,189\mathrm{.}05],[3,\frac{1}{23}\frac{?}{14},$Central,Kivell,Binder,$50,19\mathrm{.}99,999\mathrm{.}50],[,2/9/14,$Central,Jardine,Pencil,$36,4\mathrm{.}99,179\mathrm{.}64],[,\frac{2}{26}\frac{?}{14},$Central,Gill,Pen,$27,19\mathrm{.}99,539\mathrm{.}73],[6,3/15/14,$West,Sorvino,Pencil,$56,2\mathrm{.}99,167\mathrm{.}44],[,4/1/14,$East,Jones,Binder,$60,4\mathrm{.}99,299\mathrm{.}40],[,4/18/14,$Central,Andrews,Pencil,$75,1\mathrm{.}99,149\mathrm{.}25],[,5/5/14,$Central,Jardine,Pencil,$90,4\mathrm{.}99,449\mathrm{.}10],[,5/22/14,$West,Thompsol,Pencil,$32,1\mathrm{.}99,63\mathrm{.}68],[,\frac{6}{8}\frac{?}{14},$East,Jones,Binder,$60,8\mathrm{.}99,539\mathrm{.}40],[,6/25/14,$Central,Morgan,Pencil,$90,4\mathrm{.}99,449\mathrm{.}10],[,\frac{7}{12}\frac{?}{14},$East,Howard,Binder,$29,1\mathrm{.}99,57\mathrm{.}71],[2,7/29/14,$East,Parent,Binder,$81,19\mathrm{.}99,$#####$],[,8/15/14,$East,Jones,Pencil,$35,4\mathrm{.}99,174\mathrm{.}65],[$II$,9/1/14,$Central,Smith,Desk,$2,125\mathrm{.}00,250\mathrm{.}00],[17,9/18/14,$East,Jones,Pen Se$,16,15\mathrm{.}99,255\mathrm{.}84],[10,10/5/14,$Central,Morgan,Binder,$28,8\mathrm{.}99,251\mathrm{.}72],[1.,10/22/14,$East,Jones,Pen,$64,8\mathrm{.}99,575\mathrm{.}36],[,11/8/14,$East,Parent,Pen,$15,19\mathrm{.}99,299\mathrm{.}85],[,11/25/14,$Central,Kivell,Pen Se$,96,4\mathrm{.}99,479\mathrm{.}04],[$Le$,12/12/14,$Central,Smith,Pencil,$67,1\mathrm{.}29,86\mathrm{.}43],[86,12/29/14,$East,Parent,Pen Se$,74,15\mathrm{.}99,$####$],[14,1/15/15,$Central,Gill,Binder,$46,8\mathrm{.}99,413\mathrm{.}54],[,\frac{2}{1}\frac{?}{15},$Central,Smith,Binder,$87,15\mathrm{.}00,$#####$],[26,2/18/15,$East,Jones,Binder,$4,4\mathrm{.}99,19\mathrm{.}96],[27,3/7/15,$West,Sorvino,Binder,$7,19\mathrm{.}99,139\mathrm{.}93],[28,3/24/15,$Central,Jardine,Pen Se$,50,4\mathrm{.}99,249\mathrm{.}50],[29,4/10/15,$Central,Andrews,Pencil,$66,1\mathrm{.}99,131\mathrm{.}34],[30,4/27/15,$East,Howard,Pen,$96,4\mathrm{.}99,479\mathrm{.}04],[(3),5/14/15,$Central,Gill,Pencil,$53,1\mathrm{.}29,68\mathrm{.}37],[62,5/31/15,$Central,Gill,Binder,$80,8\mathrm{.}99,719\mathrm{.}20],[33,6/17/15,$Central,Kivell,Desk,$5,125\mathrm{.}00,625\mathrm{.}00],[34,\frac{7}{4}\frac{?}{15},$East,Jones,Pen Se$,62,4\mathrm{.}99,309\mathrm{.}38],[35,7/21/15,$Central,Morgan,Pen Se$,55,12\mathrm{.}49,686\mathrm{.}95],[36,8/7/15,$Central,Kivell,Pen Se$,42,23\mathrm{.}95,$#####$],[37,8/24/15,$West,Sorvino,Desk,$3,275\mathrm{.}00,825\mathrm{.}00],[38,9/10/15,$Central,Gill,Pencil,$7,1\mathrm{.}29,9\mathrm{.}03],[39,9/27/15,$West,Sorvino,Pen,$76,1\mathrm{.}99,151\mathrm{.}24],[40,10/14/15,$West,Thompsol,Binder,$57,19\mathrm{.}99,$#####$],[41,10/31/15,$Central,Andrews,Pencil,$14,1\mathrm{.}29,18\mathrm{.}06],[42,11/17/15,$Central,Jardine,Binder,$11,4\mathrm{.}99,54\mathrm{.}89],[43,12/4/15,$Central,Jardine,Binder,$94,19\mathrm{.}99,$#####$],[44,12/21/15,$Central,Andrews,Binder,$28,4\mathrm{.}99,139\mathrm{.}72],[,,,,,,,],[,,,,,,,]]$

Task

Using the data set datasetex $3,$darr,

Run descriptive statistics on Total Revenue by Service Rep $($you may need to organize data before running the statistics$).$

Run the appropriate assumption tests. Decide which assumptions you can make for the data set.

Create a pivot table that answers the question, "What items have generated the most total revenue by Sales Rep?"

Be sure to include Grand Totals for each Sales Rep and each item.

Note that many other interesting questions can be answered using a pivot table on this data set.

DO NOT include the data set with your submission.

Criteria for Success

Be sure to include which assumptions you are making for this data set.

Pivot tables should answer the basic questions in order to meet expectations. An extra point $($for a total of $2$ points$)$ will only be given for work that exceeds expectations.

'Exceeding expectations' can be indicated by showing your ability to explore the data beyond the minimum standards in the task.

For instance: Do a little extra by exploring the data in a significantly different way from the exercise and display in an additional pivot table.