Essentials of Business Analytics (MindTap Course List)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 7P

The file TaxData contains information from federal tax returns filed in 2007 for all counties in the United States (3,142 counties in total). Create a PivotTable in Excel to answer the questions below. The PivotTable should have State Abbreviation as Row Labels. The Values in the PivotTable should be the sum of adjusted gross income for each state.

  1. a. Sort the PivotTable data to display the states with the smallest sum of adjusted gross income on top and the largest on the bottom. Which state had the smallest sum of adjusted gross income? What is the total adjusted gross income for federal tax returns filed in this state with the smallest total adjusted gross income? (Hint: To sort data in a PivotTable in Excel, right-click any cell in the PivotTable that contains the data you want to sort, and select Sort.)
  2. b. Add the County Name to the Row Labels in the PivotTable. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on the top and the highest values on the bottom. Filter the Row Labels so that only the state of Texas is displayed. Which county had the smallest sum of adjusted gross income in the state of Texas? Which county had the largest sum of adjusted gross income in the state of Texas?
  3. c. Click on Sum of Adjusted Gross Income in the Values area of the PivotTable in Excel. Click Value Field Settings…. Click the tab for Show Values As. In the Show values as box, choose % of Parent Row Total. Click OK. This displays the adjusted gross income reported by each county as a percentage of the total state adjusted gross income. Which county has the highest percentage adjusted gross income in the state of Texas? What is this percentage?
  4. d. Remove the filter on the Row Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of New York?
Blurred answer
Students have asked these similar questions
Please help with (d)
. The discharge analysis report of Anywhere Health Care Facility shows 1752 discharges (including deaths) for October 2020. Fifty-two deaths were also shown in the report. Find gross death rate.
The Wall Street Journal’s website, www.wsj.com, reported the number of cars and light-duty trucks sold through October of 2014 and October of 2015. The top sixteen manufacturers are listed here. The sales information for all manufacturers can be accessed in a data file below.  Sales data are often reported in this way to compare current sales to last year’s sales.     Year-to-Date Sales   Manufacturer Through October 2015   Through October 2014   General Motors Corp. 2,562,840   2,434,707   Ford Motor Company 2,178,587   2,065,612   Toyota Motor Sales USA Inc. 2,071,446   1,975,368   Chrysler 1,814,268   1,687,313   American Honda Motor Co Inc. 1,320,217   1,281,777   Nissan North America Inc. 1,238,535   1,166,389   Hyundai Motor America 638,195   607,539   Kia Motors America Inc. 526,024   489,711   Subaru of America Inc. 480,331   418,497   Volkswagen of America Inc. 294,602   301,187   Mercedes-Benz 301,915   281,728   BMW of North America Inc.…
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY