This assignment will help you learn about data analytics by giving you the opportunity to explore data options for a city planning decision.

This assignment will help you learn about data analytics by giving you the opportunity to explore data options for a city planning decision.

Learning objectives

Create a pivot table in Excel

Format a pivot table

Apply filters to a pivot table

Create sum, count, and average columns in a pivot table

Sort a pivot table

Create a pivot chart in Excel

Analyze transactions using a pivot table and a pivot chart

Tasks

Skim ADA module 1 (1-1 to 1-19), module 9 (9-1 to 9-6), and read ADA module 9, pages 9-6 to9-9 of the Midwest Golf Carts Case. (see the attached file)

Complete the questions in ADA module 9 (pages 9-8) using the Midwest Golf Carts Data. (see the attached file)

Requirements

1. Run descriptives on the disbursements and identify any data exceptions (data totals that do not conform to the totals provided by IT).Table showing data from IT

2. List expenditures by month for each year.

3. Identify expenditures for the top three vendors for each year.

4. Identify the largest 10 disbursements made over the sample period.

5. List any expenditures not made on a business day.

6. List any duplicate payments (payments in the same amount made to the same vendor on the same day).

7. List any duplicate check numbers.

8. List any duplicate vendors.

9. List any payments for round numbers (such as thousands, hundreds, and so on).

Summarize your report in a memo using the data from your analysis. This should be created in such a way that the reader can see the facts without needing to use Excel to do so.

Requirements: As required in the question details | .xls file

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.