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
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
10
Draw a block diagram of number 7 and 8
If all the HRDs who completed the survey from the energy industry had their head office in Asia, how many more people is this than we would expect, from what we know about the geographical location of Head offices more generally?
4, 17, 21, 43, or 47?
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
- In the provided table, the education information and incomes of 73,736 people are given. The rows are labeled with education status and the columns are labeled with income range. The total of all entries in each row gives the total number of people with the corresponding education status and similarly, the total of all entries of a particular column gives the number of people with the corresponding income range. Please answer subpart 4 and 5.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_forwardHow many ways can the letters of the word MAILBOX be arranged in a row if the letters ILB must remain together (in order) as a unit?arrow_forward
- wat is the intermdiate demond of the agricultural,manufacutring,and energy sectorarrow_forwardWhat is the sum.of squares for the population of 1, 8, 0, 4, 2arrow_forwardIn the City of Manila, the total population is 1,750,873 and there are six districts within the area. Compute for its average, and the number of people in the clustered group(desire = 90).arrow_forward
- Label the columns of the table of the World Bank, four income groups 2017? Low income 31 Lower middle income 56 Upper middle income 54 High income 53arrow_forwardThe "Medal Tracker" posted on ESPN's website reported the overall medal count for the 2014 Winter Olympics in Sochi. The results are summarized in the attachment two-way table. Which of the following correctly identifies the size of the table? 3 × 5 4 × 6 6 × 4 5 × 3 arrow_forwardList 6 ways of collecting data and state two ways in which each can be usedarrow_forward
- find the agricultural,manufactoring, and enegry sectorarrow_forwardAll parts will definitely upvotearrow_forwardA real estate investment trust (REIT) owns first-class office properties in selected markets. According to its website, the occupancy rates last year for its holdings in four major cities are available below. Complete parts a through c below.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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