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