Order Now

Expert answer:Spreadsheet-Classify, sort, or group the data in a

Uncategorized

Solved by verified expert:PART 1- Use the modified spreadsheet that you submitted in Module 03 for this deliverable. ATTACHED Examine the fields in the spreadsheet. Classify, sort, or group the data in a way that the outliers become apparent. An example would be to sort by the total cancellations. Keep all data, but highlight the sales consultants that are outliers. Submit the newly modified spreadsheet.PART 2- In a one page paper- Word Document , APA formatted with references and citations, you will analyze the data for trends that span over the course of the entire data set. Identify sales consultants that indicate a progression towards noncompliance. Explain why you have identified them. Paper is APA formatted with references and citations
module_03_course_project_data_retrieval_102017.xlsx

Unformatted Attachment Preview

Sales System Number
265801-2014111
265801-2014111
315320-2014111
265980-2014111
329247-2014111
399053-2014111
407197-2014111
407886-2014111
410718-2014111
265005-2014111
265288-2014111
265440-2014111
265778-2014111
265758-2014111
265068-2014111
265609-2014111
265862-2014111
266104-2014111
265823-2014111
330618-2014111
332509-2014111
333704-2014111
407148-2014111
265752-2014111
265848-2014111
266106-2014111
331393-2014111
Date of Sale
Extract Date
Sales Consultant ID
10/1/2014
11/1/2014
35353356
10/1/2014
11/1/2014
66464667
10/3/2014
11/1/2014
57575758
10/3/2014
11/1/2014
75265980
10/5/2014
11/1/2014
83748200
10/10/2014
11/1/2014
26354410
10/11/2014
11/1/2014
33407197
10/12/2014
11/1/2014
40278386
10/13/2014
11/1/2014
41107218
10/14/2014
11/1/2014
26150025
10/20/2014
11/1/2014
26354410
10/20/2014
11/1/2014
26354410
10/20/2014
11/1/2014
26356778
10/20/2014
11/1/2014
26457518
10/20/2014
11/1/2014
26520168
10/20/2014
11/1/2014
26526109
10/25/2014
11/1/2014
12658262
10/25/2014
11/1/2014
26161204
10/25/2014
11/1/2014
26531823
10/26/2014
11/1/2014
33011618
10/26/2014
11/1/2014
33255099
10/28/2014
11/1/2014
33233704
10/28/2014
11/1/2014
43207148
10/30/2014
11/1/2014
26325752
10/30/2014
11/1/2014
26621106
10/30/2014
11/1/2014
26621106
10/31/2014
11/1/2014
33135393
Territory
DOWNSTATE NEW YORK
ATLANTA-NORTH GEORGIA
SOUTH FLORIDA
DOWNSTATE NEW YORK
SAN ANTONIO
SOUTH FLORIDA
ARKANSAS
ARKANSAS
MISSISSIPPI
DOWNSTATE NEW YORK
SOUTH FLORIDA
SOUTH FLORIDA
SOUTH FLORIDA
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ILLINOIS
KENTUCKY
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
ARKANSAS
DOWNSTATE NEW YORK
LOUISIANA
LOUISIANA
KENTUCKY
Tax Type
W2
W2
1099
W2
1099
1099
1099
1099
1099
W2
1099
1099
W2
W2
W2
W2
W2
W2
W2
1099
W2
1099
1099
W2
W2
W2
1099
Total Contracts
10
4
11
4
0
5
0
1
11
13
0
7
1
9
10
25
9
4
1
1
16
0
3
13
7
10
9
Total Sales
Total Cancellations
$30,291.00
1
$39,999.00
0
$92,829.00
1
$44,255.00
2
$0.00
0
$20,100.00
1
$7,881.00
0
$10,000.00
0
$83,641.00
5
$0.00
13
$0.00
0
$44,242.00
0
$555.00
0
$80,000.00
0
$45,000.00
0
$54,535.00
0
$24,222.00
0
$14,344.00
0
$6,566.00
0
$250.00
0
$50,000.00
1
$321.00
0
$600.00
0
$72,990.00
0
$35,000.00
0
$87,382.00
1
$21,222.00
0
Sales System Number
265005-2014111
265068-2014111
265288-2014111
265440-2014111
329247-2014111
399053-2014111
265609-2014111
265758-2014111
265778-2014111
265823-2014111
265862-2014111
266104-2014111
330618-2014111
407197-2014111
407886-2014111
265801-2014111
265801-2014111
265980-2014111
332509-2014111
333704-2014111
315320-2014111
407148-2014111
410718-2014111
265752-2014111
265848-2014111
266106-2014111
331393-2014111
Date of Sale
Extract Date
Sales Consultant ID
11/1/2014
12/1/2014
11/2/2014
12/1/2014
11/2/2014
12/1/2014
11/2/2014
12/1/2014
11/3/2014
12/1/2014
11/4/2014
12/1/2014
11/5/2014
12/1/2014
11/5/2014
12/1/2014
11/5/2014
12/1/2014
11/5/2014
12/1/2014
11/6/2014
12/1/2014
11/7/2014
12/1/2014
11/8/2014
12/1/2014
11/10/2014
12/1/2014
11/10/2014
12/1/2014
11/11/2014
12/1/2014
11/12/2014
12/1/2014
11/13/2014
12/1/2014
11/15/2014
12/1/2014
11/16/2014
12/1/2014
11/17/2014
12/1/2014
11/23/2014
12/1/2014
11/27/2014
12/1/2014
11/29/2014
12/1/2014
11/29/2014
12/1/2014
11/30/2014
12/1/2014
11/30/2014
12/1/2014
26354410
33407197
40278386
41107218
33011618
33255099
66464667
35353356
26520168
26152889
26356778
26354410
26531823
33233704
43207148
26526109
26457518
12658262
75265980
57575758
26161204
83748200
26621106
26150025
33135393
26325752
26621106
Territory
SOUTH FLORIDA
ARKANSAS
ARKANSAS
MISSISSIPPI
KENTUCKY
DOWNSTATE NEW YORK
ATLANTA-NORTH GEORGIA
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
SOUTH FLORIDA
SOUTH FLORIDA
SOUTH FLORIDA
ILLINOIS
DOWNSTATE NEW YORK
ARKANSAS
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
DOWNSTATE NEW YORK
SOUTH FLORIDA
DOWNSTATE NEW YORK
SAN ANTONIO
LOUISIANA
DOWNSTATE NEW YORK
KENTUCKY
DOWNSTATE NEW YORK
LOUISIANA
Tax Type
1099
1099
1099
1099
1099
W2
W2
W2
W2
1099
W2
1099
W2
1099
1099
W2
W2
W2
W2
1099
W2
1099
W2
W2
1099
W2
W2
Total Contracts
Total Sales
5
0
1
4
1
9
1
3
2
14
1
7
1
0
3
16
2
2
4
11
4
0
10
5
7
5
2
Total Cancellations
$20,100.00
$0.00
$10,000.00
$4,000.00
$900.00
$30,000.00
$550.00
$10,300.00
$5,000.00
$1,000.00
$5,000.00
$500.00
$3,000.00
$0.00
$0.00
$20,000.00
$1,010.00
$211.00
$20,100.00
$500.00
$10,000.00
$0.00
$87,382.00
$0.00
$20,000.00
$20,000.00
$1,000.00
1
0
0
0
0
1
0
0
0
13
0
0
0
0
0
0
0
0
1
10
0
0
1
5
0
0
0
Sales System Number
265005-2014111
265288-2014111
410718-2014111
265609-2014111
265440-2014111
266104-2014111
333704-2014111
331393-2014111
407148-2014111
265752-2014111
265823-2014111
407886-2014111
265801-2014111
315320-2014111
399053-2014111
265778-2014111
265758-2014111
265801-2014111
332509-2014111
265068-2014111
329247-2014111
266106-2014111
265862-2014111
265848-2014111
407197-2014111
330618-2014111
265980-2014111
Date of Sale
Extract Date Sales Consultant ID
12/1/2014
1/1/2015
26354410
12/1/2014
1/1/2015
40278386
12/1/2014
1/1/2015
26621106
12/2/2014
1/1/2015
66464667
12/3/2014
1/1/2015
41107218
12/3/2014
1/1/2015
26354410
12/4/2014
1/1/2015
57575758
12/5/2014
1/1/2015
26621106
12/6/2014
1/1/2015
83748200
12/6/2014
1/1/2015
26150025
12/7/2014
1/1/2015
26152889
12/8/2014
1/1/2015
26621106
12/9/2014
1/1/2015
26526109
12/9/2014
1/1/2015
26161204
12/10/2014
1/1/2015
33255099
12/11/2014
1/1/2015
26520168
12/12/2014
1/1/2015
35353356
12/13/2014
1/1/2015
26457518
12/14/2014
1/1/2015
75265980
12/15/2014
1/1/2015
33407197
12/19/2014
1/1/2015
33011618
12/20/2014
1/1/2015
26325752
12/21/2014
1/1/2015
26356778
12/22/2014
1/1/2015
33135393
12/23/2014
1/1/2015
33233704
12/24/2014
1/1/2015
26621106
12/30/2014
1/1/2015
12658262
Territory
Tax Type
SOUTH FLORIDA
1099
ARKANSAS
1099
LOUISIANA
W2
ATLANTA-NORTH GEORGIA
W2
MISSISSIPPI
1099
SOUTH FLORIDA
1099
SOUTH FLORIDA
1099
LOUISIANA
W2
SAN ANTONIO
1099
DOWNSTATE NEW YORK
W2
SOUTH FLORIDA
1099
LOUISIANA
W2
DOWNSTATE NEW YORK
W2
DOWNSTATE NEW YORK
W2
DOWNSTATE NEW YORK
W2
DOWNSTATE NEW YORK
W2
DOWNSTATE NEW YORK
W2
DOWNSTATE NEW YORK
W2
DOWNSTATE NEW YORK
W2
ARKANSAS
1099
KENTUCKY
1099
DOWNSTATE NEW YORK
W2
SOUTH FLORIDA
W2
KENTUCKY
1099
DOWNSTATE NEW YORK
1099
LOUISIANA
W2
DOWNSTATE NEW YORK
W2
Total Contracts
0
5
10
9
3
1
9
1
0
18
14
11
16
4
9
0
3
18
16
0
2
16
1
7
1
2
16
Total Sales
$0.00
$10,000.00
$0.00
$7,000.00
$4,000.00
$500.00
$2,000.00
$1,000.00
$0.00
$7,000.00
$1,000.00
$0.00
$20,000.00
$10,000.00
$30,000.00
$5,000.00
$10,300.00
$7,000.00
$20,000.00
$0.00
$900.00
$20,000.00
$5,000.00
$20,000.00
$0.00
$0.00
$20,000.00
Total Cancellations
0
3
10
3
0
0
5
0
0
5
13
11
0
0
1
0
0
10
0
0
0
0
0
0
0
2
0
Deleted the office column, state column, and region coumn which are not relevant when determining
the compliance of the consultants to the policy. The last name and first name might become as
important as one could imagine because the consultant IDs exist and they could apply when
determining if they are in policy. The columns that are needed for the analysis include the extraction
date, sales consultant ID, Tax type, Total contract, Total sales and Total cancellations.
…
Purchase answer to see full
attachment

How it works

  1. Paste your instructions in the instructions box. You can also attach an instructions file
  2. Select the writer category, deadline, education level and review the instructions 
  3. Make a payment for the order to be assignment to a writer
  4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades

Continue to order Get a quote
Place your order
(550 words)

Approximate price: $22

Recent Comments

No comments to show.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 20% with the discount code ESSAYHELP

Get a plagiarism free paper now