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
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
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.
- 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.)
- 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?
- 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?
- 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?
Expert Solution & Answer
Trending nowThis is a popular solution!
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.…
Chapter 3 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 3 - A sales manager is trying to determine appropriate...Ch. 3 - The following table shows an example of gross...Ch. 3 - The following table provides monthly revenue...Ch. 3 - In the file MajorSalary, data have been collected...Ch. 3 - Entrepreneur magazine ranks franchises. Among the...Ch. 3 - The file MutualFunds contains a data set with...Ch. 3 - The file TaxData contains information from federal...Ch. 3 - The file FDICBankFailures contains data on...Ch. 3 - The following 20 observations are for two...Ch. 3 - The file Fortune500 contains data for profits and...
Ch. 3 - The International Organization of Motor Vehicle...Ch. 3 - Prob. 12PCh. 3 - Prob. 13PCh. 3 - The total number of term life insurance contracts...Ch. 3 - An automotive company is considering the...Ch. 3 - Consider the following survey results regarding...Ch. 3 - The Northwest regional manager of Logan Outdoor...Ch. 3 - The Ajax Company uses a portfolio approach to...Ch. 3 - Heat maps can be very useful for identifying...Ch. 3 - The following table shows monthly revenue for six...Ch. 3 - Prob. 21PCh. 3 - Aurora Radiological Services is a health care...Ch. 3 - The motion picture industry is an extremely...
Knowledge Booster
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
- If a data set contains three groups that each have ten people in them, how many rows will the “data view” have? 30 3 100 10arrow_forwardIdentify the steps in creating the Answer Report.arrow_forwardMany countries, especially those in Europe, have significant gold holdings. But many of these countries also have massive debts. The following data show the total value of gold holdings in billions of U.S. dollars and the debt as a percentage of the gross domestic product for nine countries (WordPress and Trading Economics websites, February 24, 2012). Click on the datafile logo to reference the data. Country Gold Value Debt China 63 17.7 France 146 81.7 Germany 203 83.2 Indonesia 33 69.2 Italy 147 119 Netherlands 36 63.7 Russia 50 9.9 Switzerland 62 55 U.S. 487 93.2 Using the entire data set, develop the estimated regression equation that can be used to predict the debt of a country given the total value of its gold holdings. y^ = (to 4 decimals) (to 4 decimals) Gold Value Suppose that after looking at the scatter diagram in part (a) that you were able to visually identify what appears to be an…arrow_forward
- This chart displays the average rate of people living in poverty in the 23 continental states west of the Mississippi River for the years 2014 – 2016. Create a stemplot for these data. Note that a stemplot never shows the decimal symbol and only the rightmost digit is used for the leaf. (https://www.census.gov/data/tables/2017/demo/income-poverty/p60-259.html) Average rate of people living in poverty in the 23 continental states west of the Mississippi River for the years 2014 – 2016 State Rate of Poverty (%) Minnesota 8.3 Utah 9.4 Iowa 10.1 Wyoming 10.1 Colorado 10.2 North Dakota 10.5 Nebraska 10.6 Missouri 11.1 Washington 11.5 Idaho 11.9 Montana 11.9 Kansas 12.5 Oregon 12.7 Nevada 13.4 South Dakota 13.7 California 14.5 Texas 15.0 Oklahoma 15.4 Arkansas 16.8 Arizona 18.2 New Mexico 19.1 Louisiana 20.6 Mississippi 20.8arrow_forwardone standart?arrow_forwardThe U.S. Census Bureau collects data on household size and publishes the information in Current Population Reports. What kind of data is the number of people in your household?arrow_forward
- why is zero important in a place value system?arrow_forwardMarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales. Car Sales Manufacturer Jan.-Nov.2017 Jan.-Nov.2018 GM (Est.) 2,691,493 2,654,568 Ford 2,334,290 2,265,590 Toyota 2,211,533 2,205,762 Fiat Chrysler 1,887,430 2,038,684 Honda 1,492,112 1,449,713 Nissan 1,455,238 1,345,157 Hyundai 621,961 612,225 Subaru 584,614 615,594 Kia 546,629 542,245 Mercedes (includes Sprinter) 332,990 318,012 BMW 271,432 276,657 VW 309,395 322,017 Mazda 262,577 274,455 Audi 199,534 200,558 Tesla (Est.) 40,320 106,050 Land Rover 66,759 81,526 Volvo 71828 89437 Mitsubishi 95,185 109,088 Porsche 51,507 53,116 MINI 42,494 40,887 Jaguar 36,180 27,021 Others 18,901 17,251 smart…arrow_forwardThe boxplots show data for state and local community expenditures on hospitals and highways. Hospitals Estimate Q1, Q2, and Q3 for hospital and highway spending. Highways Billions of Dollarsarrow_forward
- A report states that 45% of American adults were obese. In this report, adults were considered to be 20 years of age or older. If about 71% of Americans are adults (20 and over), use the U.S. population estimate of 301 million people to calculate the number of American adults age 20 and older.arrow_forwardAn insurance company hires an actuary to determine whether the number of hours of safety drivingclasses can be used to predict the number of driving accidents for each driver. Identify theexplanatory variable, if any.arrow_forwarduppose Laura, a facilities manager at a health and wellness company, wants to estimate the difference in the average amount of time that men and women spend at the company's fitness centers each week. Laura randomly selects 13 adult male fitness center members from the membership database and then selects 13 adult female members from the database. Laura gathers data from the past month containing logged time at the fitness center for these members. She plans to use the data to estimate the difference in the time men and women spend per week at the fitness center. The sample statistics are summarized in the table. Population Populationdescription Population mean(unknown) Samplesize Sample mean(min) Sample standarddeviation (min) 1 male ?1 ?1=13 ?⎯⎯⎯1=132.5 ?1=45.3 2 female ?2 ?2=13 ?⎯⎯⎯2=108.7 ?2=31.1 df=21.256 The population standard deviations are unknown and unlikely to be equal, based on the sample data. Laura plans to use the two-sample ?-procedures to estimate the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
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