Below are data for the median family income in the United States by Race and Hispanic...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Below are data for the median family income in the United States by Race and Hispanic Origin, for the years 1972-1987. The data are in current dollars. 1. Convert the current dollar figures into constant dollars (i.e., control for inflation). The formula for converting constant dollars into current dollars is: constant dollars current dollars/(CPI-U * 0.01) Calculate constant dollars for each of the categories: All Families, White, Black, and Hispanic. (The CPI-U figures have a 1982-84 as the base year. Therefore, the constant dollars will be in 1982-84 dollars.) 2. Create one line graph to compare the trends for the three racial'ethnic groups (i.e., White, Black, Hispanic) (use the constant dollar figures). 3. Create a memo in Word comparing the trend for median family income for the three groups over the past 15 years. Import your graph into your Word memo. Save your documents with the filename: INCXXX (where xXxx are your initials). (Note: You should save two files. One should be an EXCEL document and the other should be a Word document.) Median Family Income by Race and Hispanic Origin, 1960-87 (in current dollars) Year All Families White Black Hispanic CPI-U 1972 11116 11549 6864 8183 41.8 1973 1974 12051 12595 7269 8715 44.4 12902 13408 8006 9540 49.3 1975 13719 14268 8779 9551 53.8 1976 14958 15537 9242 10259 56.9 1977 16009 16740 9563 11421 60.6 1978 17640 18368 10879 12566 65.2 20439 21904 23517 1979 11574 12674 19587 14169 72.6 1980 21023 14716 82.4 90.9 96.5 99.6 1981 22388 23433 13266 16401 1982 24603 13598 16227 1983 24674 25837 14561 16930 1984 26433 27686 15431 18832 103.9 1985 27735 29152 16786 19027 107.6 1986 29458 30809 17604 19995 109.6 1987 30853 32274 18098 20306 113.6 Below are data for the median family income in the United States by Race and Hispanic Origin, for the years 1972-1987. The data are in current dollars. 1. Convert the current dollar figures into constant dollars (i.e., control for inflation). The formula for converting constant dollars into current dollars is: constant dollars current dollars/(CPI-U * 0.01) Calculate constant dollars for each of the categories: All Families, White, Black, and Hispanic. (The CPI-U figures have a 1982-84 as the base year. Therefore, the constant dollars will be in 1982-84 dollars.) 2. Create one line graph to compare the trends for the three racial'ethnic groups (i.e., White, Black, Hispanic) (use the constant dollar figures). 3. Create a memo in Word comparing the trend for median family income for the three groups over the past 15 years. Import your graph into your Word memo. Save your documents with the filename: INCXXX (where xXxx are your initials). (Note: You should save two files. One should be an EXCEL document and the other should be a Word document.) Median Family Income by Race and Hispanic Origin, 1960-87 (in current dollars) Year All Families White Black Hispanic CPI-U 1972 11116 11549 6864 8183 41.8 1973 1974 12051 12595 7269 8715 44.4 12902 13408 8006 9540 49.3 1975 13719 14268 8779 9551 53.8 1976 14958 15537 9242 10259 56.9 1977 16009 16740 9563 11421 60.6 1978 17640 18368 10879 12566 65.2 20439 21904 23517 1979 11574 12674 19587 14169 72.6 1980 21023 14716 82.4 90.9 96.5 99.6 1981 22388 23433 13266 16401 1982 24603 13598 16227 1983 24674 25837 14561 16930 1984 26433 27686 15431 18832 103.9 1985 27735 29152 16786 19027 107.6 1986 29458 30809 17604 19995 109.6 1987 30853 32274 18098 20306 113.6
Expert Answer:
Related Book For
Finite Mathematics and Its Applications
ISBN: 978-0134768632
12th edition
Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair
Posted Date:
Students also viewed these accounting questions
-
Penny is an expected utility maximiser with utility function u(x) = ln(x) and wealth of $300. Paddy makes decisions in accordance with prospect theory, has wealth $300 and value function: X where x ...
-
Compare the general CPI inflation time series with that of the index excluding gas and food. Which inflation rate is more difficult to predict? Calculate the 1-step and 2-step density forecast for...
-
Convert each measurement as indicated. 1. 84 in. to feet 2. 18 yf to feet 3. 36,960 ft to miles 4. 12 1/2ft to inches 5. 25 ft to yards
-
Lauren Smith was relaxing after work with a colleague at a local bar. After a few drinks, she began expressing her feelings about her company's new control initiatives. It seems that as a result of...
-
Explain why GAS technology is popular with most auditors.
-
Explain the criteria for determining whether hyperinflation exists.
-
Calculate the following: \(1.14 \times 10^{-43}+2.56 \times 10^{-46}\)
-
Francis Corporation purchased an asset at a cost of $50,000 on March 1, 2010. The asset has a useful life of 8 years and a salvage value of $4,000. For tax purposes, the MACRS class life is 5 years....
-
Journal entry for the petty cash fund of Rico's automotive. The petty cash fund of Ricco's Automotive contained the following items at the end of September 2021: 12 Currency and coins $ 90 Receipts...
-
Company A is a global company based in the United States that operates in the financial industry. Company A serves its customers with financial products, such as checking accounts, bank cards, and...
-
volume of a spherical hot air balloon expands as the air inside the balloon is heated. The radius of the balloon, in lect, is modeled by the twice differentiable function r of time t, where t is...
-
What are the effects on the auditor's standard report of the decision to (a) make reference and (b) not make reference to another auditor?
-
A person wrote letters to \(n\) addressees, one letter in each envelope, and then, at random, wrote one of the \(n\) addresses on each envelope. What is the probability that at least one of the...
-
A quality control inspector examines items in a lot consisting of \(m\) items of first grade and \(n\) second-grade items. An inspection of the first \(b\) items chosen at random from the lot showed...
-
Prove that if \(F(x)\) is a distribution function, then for any \(h eq 0\) the functions \[ \Phi(x)=\frac{1}{h} \int_{x}^{x+h} F(x) d x, \quad \Psi(x)=\frac{1}{2 h} \int_{x-h}^{x+h} F(x) d x \] are...
-
Golf Technologies, Inc. (GTI) relies on high-level scientific testing to design golf clubs that provide larger sweet spots, resulting in fewer missed hits and maximum yardage. In the last year, GTI...
-
Convert 6.47 x 10 kg/km to its equivalent in lbs /mile. 1 mile is equivalent to 1.609 km) (1 lb is equivalent of 0.4536 kg a. 8.86 x 104 b. 2.30 x 105 c. 5.51 x 104 d. 3.69 x 105
-
For the vector whose polar components are (Vr = 1, Vθ = 0), compute in polars all components of the second covariant derivative Vα;μ;ν. To find...
-
1. Suppose a game has payoff matrix Reduce the determination of an optimal strategy for R into a linear programming problem. Just set up the problem, showing the constraints and the objective...
-
1. Suppose that a pair of dice is rolled. Given that the two numbers are different, what is the probability that one die shows a three? 2. Consider Table 1, with figures in millions, pertaining to...
-
Consider the data points (1, 8), (2, 4), and (4, 3). Find the straight line that provides the least-squares fit to these data.
-
Think of an idea for a new company and prepare a corporate charter for your business. You can find sample charters online. For extra credit, do one charter for your state and one for Delaware. Using...
-
10. ROLE REVERSAL Write a short-answer question that deals with the duty of care under the business judgment rule.
-
Question: Dr. Warfield hired Wolfe, a young carpenter, to build his house. A week or so after they signed the contract, Wolfe filed Articles of Incorporation for Wolfe Construction, Inc. Warfield...
Study smarter with the SolutionInn App