The total amount is for ALL 3 PARTS!!! Using Excel to Examine Revenue Trends and Outliers in the U.S. Department of Interior Data First, access the

The total amount is for ALL 3 PARTS!!!

Using Excel to Examine Revenue Trends and Outliers in the U.S. Department of Interior Data

First, access the following database: U.S. Department of Interior Natural Resources Revenue

Next, download the file named: Fiscal year revenue, 2004 – 2023 (csv, 4MB)

Open the document in Excel (or Google Sheets) and perform the following tasks to analyze revenue trends and identify outliers in the data:

  1. Sort the document by State. Which 2 states produce the most revenue? How do you interpret the amounts that are marked as zero?
  2. Sort the document by Revenue Type. What are the top 2 revenue types in terms of revenue amount (Column L)?
  3. 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 2020 and 2021?
  4. Filter the sheet by the two largest revenue-producing states and product type: oil. Save a copy of this view or a screenshot to include in your deliverable.
  5. Shift your attention by searching  for unusual or outlier observations. Filter the data to identify the two largest oil-producing counties in New Mexico.
  6. 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.
  7. Write a brief 1-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 3 parts:

Part 1: Answering the questions from Steps 1, 2, and 3.Part 2: PDF copies or screenshots from Steps 4 and 6.Part 3: A 1-page memo as outlined in Step 6. Be sure to use complete sentences, be clear and concise in how you write, and have a clear introduction and conclusion.

Your deliverable should conform to APA guidelines

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Choose TWO of the following passages: Genesis 3:1-7; Exodus 14:1-12; Leviticus 16:29-34; Numbers 14:11-19; Deuteronomy 30:15-20, and provide a one-page

Choose TWO of the following passages: Genesis 3:1-7; Exodus 14:1-12; Leviticus 16:29-34; Numbers 14:11-19; Deuteronomy 30:15-20, and provide a one-page interpretation of the passage for each based on what you have learned/acquired from the previous assignments performed for this course. As part of this presentation, a clear and concise principle

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following examples: a new company branding initiative; the restructuring of a team, department or business unit; a company-wide community service project; the transition of an executive leader; an emergency

Instructions First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the

Instructions First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following examples: a new company branding initiative; the restructuring of a team, department or business unit; a company-wide community service project; the transition of an executive leader; an

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of business. Create the business case: ·        Determine why funding is needed for the company. ·        Determine the sources of funding. Consider self-funding, borrowing, equity, venture capital, and so on.

Wells Fargo Case Study BACKGROUND: In fall of 2016 federal regulators accused Wells Fargo of falsely opening over 2 million customer credit card and

Wells Fargo Case Study BACKGROUND: In fall of 2016 federal regulators accused Wells Fargo of falsely opening over 2 million customer credit card and checking accounts to meet unrealistic sales quotas (http://money.cnn.com/2016/09/08/investing/wells-fargo-created-phony-accounts-bank-fees/?iid=EL, September 4, 2017).  Since then, Wells Fargo has also been accused of forcing over 500,000 customers into auto insurance policies they did notneed,

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital information to various stakeholders, including investors, creditors, management, and government agencies, enabling them to make informed decisions. Here’s a breakdown of key aspects within accounting: Financial Statements: These are the

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of business. Create the business case: ·        Determine why funding is needed for the company. ·        Determine the sources of funding. Consider self-funding, borrowing, equity, venture capital, and so on.