Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using Excel to Examine Revenue Trends and Outliers in the U . S . Department of Interior Data First, access the following database: U .
Using Excel to Examine Revenue Trends and Outliers in the US Department of Interior Data
First, access the following database: US Department of Interior Natural Resources Revenue Data Links to an external site.
Next, download the file named: Fiscal year revenue, csvMB
Open the document in Excel or Google Sheets and perform the following tasks to analyze revenue trends and identify outliers in the data:
Sort the document by State. Which states produce the most revenue? How do you interpret the amounts that are marked as zero?
Sort the document by Revenue Type. What are the top revenue types in terms of revenue amount Column L
Use the Filter tool to filter the data for New Mexico, North Dakota, and Wyoming, individually. Which state would you focus on in terms of unexpectedly large revenue increases between and
Filter the sheet by the two largest revenueproducing states and product type: oil. Save a copy of this view or a screenshot to include in your deliverable.
Shift your attention by searching for unusual or outlier observations. Filter the data to identify the two largest oilproducing counties in New Mexico.
Within these two counties, locate the ten smallest ex negative amounts and the ten largest revenue amounts, filtering the revenue into bonuses, other, rents, and royalties. Save a copy of each view to include in your deliverable.
Write a brief page memo to your audit senior explaining your data search, your thoughts on what you observed, and which revenue transactions need further evidence gathering based on their valuation.
Your deliverable will consist of parts:
Part : Answering the questions from Steps and
Part : PDF copies or screenshots from Steps and
Part : A page memo as outlined in Step Be sure to use complete sentences, be clear and concise in how you write, and have a clear introduction and conclusion.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started