ESSEN OF BUSINESS ANALYTICS (LL) BOM
2nd Edition
ISBN: 9781337128629
Author: Camm
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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
Note: The purpose of this problem below is to use computational techniques (Excelspreadsheet, Matlab, R, Python, etc.) and code the dynamic programming ideas seen inclass. Please provide the numerical answer to the questions as well as a sample of yourwork (spreadsheet, code file, etc.).We consider an N-period binomial model with the following properties: N = 60, thecurrent stock price is S0 = 1000; on each period, the stock price increases by 0.5% whenit moves up and decreases by 0.3% when it moves down. The annual interest rate on themoney market is 5%. (Notice that this model is a CRR model, which means that thebinomial tree is recombining.)(a) Find the price at time t0 = 0 of a (European) call option with strike price K = 1040and maturity T = 1 year.(b) Find the price at time t0 = 0 of a (European) put option with strike price K = 1040and maturity T = 1 year.(c) We consider now, that you are at time t5 (i.e. after 5 periods, which represents 1month later). Assume that the stock…
show work in paper
show all work (...or what you entered into your calculator...)
Chapter 3 Solutions
ESSEN OF BUSINESS ANALYTICS (LL) BOM
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
- answerarrow_forwardQuestion 2 The data below provides the battery life of thirty eight (38) motorcycle batteries. 100 83 83 105 110 81 114 99 101 105 78 115 74 96 106 89 94 81 106 91 93 86 79 103 94 108 113 100 117 120 77 93 93 85 76 89 78 88 680 a. Test the hypothesis that mean battery life is greater than 90. Use the 1% level of significance. b. Determine if the mean battery life is different from 80. Use the 10% level of significance. Show all steps for the hypothesis test c. Would your conlcusion in part (b) change at the 5% level of significance? | d. Confirm test results in part (b) using JASP. Note: All JASP input files and output tables should be providedarrow_forwardSuppose that 80% of athletes at a certain college graduate. You randomly select eight athletes. What’s the chance that at most 7 of them graduate?arrow_forward
- Suppose that you flip a fair coin four times. What’s the chance of getting at least one head?arrow_forwardSuppose that the chance that an elementary student eats hot lunch is 30 percent. What’s the chance that, among 20 randomly selected students, between 6 and 8 students eat hot lunch (inclusive)?arrow_forwardBob’s commuting times to work are varied. He makes it to work on time 80 percent of the time. On 12 randomly selected trips to work, what’s the chance that Bob makes it on time at least 10 times?arrow_forward
- Your chance of winning a small prize in a scratch-off ticket is 10 percent. You buy five tickets. What’s the chance you will win at least one prize?arrow_forwardSuppose that 60 percent of families own a pet. You randomly sample four families. What is the chance that two or three of them own a pet?arrow_forwardIf 40 percent of university students purchase their textbooks online, in a random sample of five students, what’s the chance that exactly one of them purchased their textbooks online?arrow_forward
- A stoplight is green 40 percent of the time. If you stop at this light eight random times, what is the chance that it’s green exactly five times?arrow_forwardIf 10 percent of the parts made by a certain company are defective and have to be remade, what is the chance that a random sample of four parts has one that is defective?arrow_forwardQuestion 4 Fourteen individuals were given a complex puzzle to complete. The times in seconds was recorded for their first and second attempts and the results provided below: 1 2 3 first attempt 172 255 second attempt 70 4 5 114 248 218 194 270 267 66 6 7 230 219 341 174 8 10 9 210 261 347 218 200 281 199 308 268 243 236 300 11 12 13 14 140 302 a. Calculate a 95% confidence interval for the mean time taken by each individual to complete the (i) first attempt and (ii) second attempt. [la] b. Test the hypothesis that the difference between the two mean times for both is 100 seconds. Use the 5% level of significance. c. Subsequently, it was learnt that the times for the second attempt were incorrecly recorded and that each of the values is 50 seconds too large. What, if any, difference does this make to the results of the test done in part (b)? Show all steps for the hypothesis testarrow_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