Our Services

Get 15% Discount on your First Order

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

January 18, 2025

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:

Sort the document by State. Which 2 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 2 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 2020 and 2021?
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.
Shift your attention by searching for unusual or outlier observations. Filter the data to identify the two largest oil-producing 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 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

Accounting

Share This Post

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

Related Questions

Topic: Computing Federal Taxes from gross pay using tax Tables In this discussion, please reflect on the previous weeks’ topics. Choose a topic you

Topic: Computing Federal Taxes from gross pay using tax Tables In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Research this topic and present your findings. Include a summary of the topic, why you found the topic

SEC v. Koss Corporation The SEC v. Koss Corporation case sheds light on the intricate relationship between auditors, such as Grant Thornton, and the

SEC v. Koss Corporation The SEC v. Koss Corporation case sheds light on the intricate relationship between auditors, such as Grant Thornton, and the companies they audit. Koss Corporation attempted to shift responsibility onto its auditors for failing to uncover the fraud within the company. This situation prompts a critical examination of

In the process of researching new equipment, Aldo settled on two seemingly viable alternatives: A one-time investment today of $40,000, which should

In the process of researching new equipment, Aldo settled on two seemingly viable alternatives: A one-time investment today of $40,000, which should generate net after-tax cash inflows of $20,000 per year for the next 3 years. A one-time investment today of $50,000, which should generate net after-tax cash flows of

Evaluating the Best Use of Funds for Capital Investments Data analytics can be used to evaluate the best use of funds for capital investments. Joe Fox is

Evaluating the Best Use of Funds for Capital Investments Data analytics can be used to evaluate the best use of funds for capital investments. Joe Fox is the manager of the Gear division and plans to submit a proposal for an expanded production area. Joe has projected various conditions for

Evaluating the Best Use of Funds for Capital Investments Data analytics can be used to evaluate the best use of funds for capital investments. Joe Fox is

The writing assignment will demonstrate writing across the curriculum by responding to the following topic in a 500-700 words in length paper. Topic: Two

The writing assignment will demonstrate writing across the curriculum by responding to the following topic in a 500-700 words in length paper. Topic: Two accounting students were discussing the timing of revenue recognition for long-term construction contracts. The discussion focused on which method was most like the typical revenue recognition method of recognizing

Cookie Business Final Project Assignment objective: Now that your cookie business is well underway, you are going to use the knowledge that you have

Cookie Business Final Project Assignment objective: Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to evaluate the financial information for the company. You will be creating a series of reports and analyzing the results using the

Data Analytics to Predict Solutions Your company is concerned that too much working capital is tied up in inventory, but at the same time are concerned

Data Analytics to Predict Solutions Your company is concerned that too much working capital is tied up in inventory, but at the same time are concerned stockouts. While many companies reorder inventory items based on the number of units they think they will need, a more cost-effective method to determine

Please complete the Week 8 Payroll Assignment paper with a topic or concept in the course. The Paper should be from 3 to 5 pages in length. This does not

Please complete the Week 8 Payroll Assignment paper with a topic or concept in the course. The Paper should be from 3 to 5 pages in length. This does not include the Cover page and the APA reference pages. Some Ideas for Topics and concepts: Identify Legislation That Pertains to

Please discuss similarities and differences between U.S. GAAP and IFRS regarding one of the following: The recognition, measurement, and disposition of

Please discuss similarities and differences between U.S. GAAP and IFRS regarding one of the following: The recognition, measurement, and disposition of receivables. Accounting and reporting for plant assets and intangible assets. Accounting and reporting for current liabilities. Accounting and reporting for long-term liabilities such as bonds and notes. Accounting and

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental agency, their data is available to the public. Excerpts from the public data concerning its changes in pricing for October 2021 are presented in

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental

Using the list below, select ONE company and review their ESG-related reporting. Using this information and your own opinion, write a 400+ word memo that a

Using the list below, select ONE company and review their ESG-related reporting. Using this information and your own opinion, write a 400+ word memo that addresses the following questions. Using the ESG Reporting, explain how the company addresses each aspect – Environmental, Social and Governance In your personal opinion, does information reported

Submission Instructions: Submit your completed work in a Word document or Excel spreadsheet if needed. Your work should be formatted and cited in the

Submission Instructions: Submit your completed work in a Word document or Excel spreadsheet if needed. Your work should be formatted and cited in the current APA style with appropriate references, if necessary. In addition to the solution to mathematical problems, show the equation used to generate the solution and the

3. Should Donut House accept the special order based on your analysis? Explain why. Are there any qualitative considerations that Donut House should make

3. Should Donut House accept the special order based on your analysis? Explain why. Are there any qualitative considerations that Donut House should make prior to accepting the order? Be specific and creative in your answer here. It is important to recognize there are generally always qualitative and quantitative considerations

Using Data Analytics to Determine Costs to Be Used in a Special-Order Analysis For this case, you will use selling price and cost data to determine if a

Using Data Analytics to Determine Costs to Be Used in a Special-Order Analysis For this case, you will use selling price and cost data to determine if a special order from a customer should be accepted. Donut House wants to examine if it should accept a special order by a

Our Services

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

Share This Post

Related Questions

Topic: Computing Federal Taxes from gross pay using tax Tables In this discussion, please reflect on the previous weeks’ topics. Choose a topic you

SEC v. Koss Corporation The SEC v. Koss Corporation case sheds light on the intricate relationship between auditors, such as Grant Thornton, and the

In the process of researching new equipment, Aldo settled on two seemingly viable alternatives: A one-time investment today of $40,000, which should

Evaluating the Best Use of Funds for Capital Investments Data analytics can be used to evaluate the best use of funds for capital investments. Joe Fox is

Evaluating the Best Use of Funds for Capital Investments Data analytics can be used to evaluate the best use of funds for capital investments. Joe Fox is

The writing assignment will demonstrate writing across the curriculum by responding to the following topic in a 500-700 words in length paper. Topic: Two

Cookie Business Final Project Assignment objective: Now that your cookie business is well underway, you are going to use the knowledge that you have

Data Analytics to Predict Solutions Your company is concerned that too much working capital is tied up in inventory, but at the same time are concerned

Please complete the Week 8 Payroll Assignment paper with a topic or concept in the course. The Paper should be from 3 to 5 pages in length. This does not

Please discuss similarities and differences between U.S. GAAP and IFRS regarding one of the following: The recognition, measurement, and disposition of

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental

As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental

Using the list below, select ONE company and review their ESG-related reporting. Using this information and your own opinion, write a 400+ word memo that a

Submission Instructions: Submit your completed work in a Word document or Excel spreadsheet if needed. Your work should be formatted and cited in the

3. Should Donut House accept the special order based on your analysis? Explain why. Are there any qualitative considerations that Donut House should make

Using Data Analytics to Determine Costs to Be Used in a Special-Order Analysis For this case, you will use selling price and cost data to determine if a

Use Our 6 Free Tools

How Our Service is Used:

Subscribe

NO SPAM