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

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the assignment requirements. Note: P1 below is the abbreviation for Part 1 of the TechWear Case Study Assignment. The same abbreviation pertains for subsequent Modules, too.  TechWear Case Study Parts I

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the assignment requirements. Note: P1 below is the abbreviation for Part 1 of the TechWear Case Study Assignment. The same abbreviation pertains for subsequent Modules, too.  TechWear Case Study Parts I

Assignment Type: Essay (any type) Service: Writing Words: 3 pages / 800 words (Double spacing) Education Level: Undergraduate Language: English

Assignment Type: Essay (any type) Service: Writing Words: 3 pages / 800 words (Double spacing) Education Level: Undergraduate Language: English (US)  Assignment Topic: Accounting Tools and Techniques Subject: Accounting  Sources: 4 sources required Citation Style: APA 6th edition Instructions: How does managerial accounting contribute to strategic decision-making in modern organizations, and why is

Title: Exploring Global Inequality through the Dollar Street Project. Word Count: The essay to consists of approximately 1,900-2,100 words. Formatting

Title: Exploring Global Inequality through the Dollar Street Project. Word Count: The essay to consists of approximately 1,900-2,100 words. Formatting Style: Font and Size: Times New Roman, 12-point font Headings and Subheadings: Bold for headings (e.g., Introduction, Visual and Quantitative Analysis, Socioeconomic Analysis, Conclusion) and italicized for subheadings (e.g., Low-Income

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild”

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild” is a coming-of-age story, raising provocative questions about sex roles, self-sacrifice, colonization, and species- interdependence. How does this theme of the coming-of-age story function throughout the short story?

Academic Counseling  Assessment Desuсrіption: Educational institutions are evaluated on student outcomes, especially academic achievement. As such, school

Academic Counseling  Assessment Desuсrіption: Educational institutions are evaluated on student outcomes, especially academic achievement. As such, school counselors are tasked with supporting students in the area of academic development through the enhancement of knowledge, skills, and attitudes. The school counselor’s role in academic development focuses on fostering safe and inclusive learning

Wk 1 Environmental Disaster Memo Guide Use the following instructions to help you complete the Wk 1 – Summative Assessment: Environmental Disaster

Wk 1 Environmental Disaster Memo Guide Use the following instructions to help you complete the Wk 1 – Summative Assessment: Environmental Disaster Memo. Instructions Read “Environmental Disasters” from the University Library.   Choose1 environmental incident from “Environmental Disasters.”   Researchthe environmental incident you selected. ·         Find at least 5 additional resources related