Fill in the mid-point value for the Estimated Household Income in the column MidEHI (rounded to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Fill in the mid-point value for the "Estimated Household Income" in the column "MidEHI" (rounded to the nearest dollar). This is useful for answering questions about the average (estimated) income of a sample sub-group. One way to do it is to create a Pivot Table to get the different "income brackets". Then extract the upper and lower dollar bounds of each income bracket and find the mid-point. See the homework video titled, "Generating mid-point EHI" for a demonstration (the video does not contain sound). Note: The rows in the demo video (RawData worksheet) won't match the rows in your workbook, but the basic steps and formulae are what we're trying to understand. There are other ways to generate this data, but doing this step manually (i.e., without use of Excel formulas) will lead to a loss of points. During grading, we look for an appropriate formula in the MidEHI column along with supporting data/worksheet(s) in your workbook. Note: you can assume "under 20,000" means to 0-20,000 B D E G LastNan Street Street S City State IEL Park Ave Tucson AZ VELASCO Adelaide Dr Tucson AZ B DOTSON Haven Ln Tucson AZ 4 DOLAN Graybill Dr Tucson AZ 5 FUNG 6 ALBIG Beauchamp Ln Tucson AZ Rancho Fel Pl Tucson AZ 7 Figueroa 46th St Tucson AZ Zip Code H Estimated Hous MidEHI 85719 $30,000-$39,999 85719 $175,000-$199,999 85719 $125,000-$149,999 85719 $20,000-$29,999 85704 $30,000-$39,999 85704 $100,000-$124,999 85713 Under $20,000 Estimated Books/MisMagazin $175,000-$1 Books & Magazines, Magaz $400,000-$449,999 $150,000-$1 Books & Magazines, Magazi $125,000-$1 Books & Magazines, Magazin $250,000-$299,999 $75,000-$99 Books & Magazines, Magazir 8 STANLEY Placita La Vina Tucson AZ 9 MACK Allen Rd Tucson AZ 85719 $30,000-$39,999 85719 Under $20,000 $100,000-$1 Book Buyers, Books & Maga $100,000-$124,999 10 DANG Water St Tucson AZ 85719 $40,000-$49,999 + $100,000-$1 Books & Magazines, Magazin 11 AMBROSE El Camino Del Norte Tucson AZ 12 CURD Edith Blvd 13 TURNER 14 SARONI Pueblo Vill. Dr Northern Ave Tucson Tucson AZ AZ 15 ROMANO Sunterra Ct 16 HUMPHREY Blacklidge Dr Tucson 17 LOVETT Prince Rd. Tucson Oro Valley AZ Tucson AZ AZ AZ 18 LYNGE Prince Rd Tucson AZ 19 RODRIGUE Ellis St Tucson AZ 20 IRWIN Norton Ave Tucson AZ 21 LUCAS Oracle Rd Tucson AZ 22 BRAGG Adelaide Dr Tucson AZ 23 FONTENOT Spring St Tucson AZ 24 MCKAY 25 Hart Helen Rocking Cir St St Tucson Tucson AZ AZ 26 WILKINS Po Box Tucson AZ 27 KNAUFF Speedway Blvd Tucson AZ 28 Hopkins 29 Marsden: Jones Ajo Blvd Tucson AZ 85716 $100,000-$124,999 85716 Under $20,000 85704 $20,000-$29,999 85704 $80,000-$89,999 85719 Under $20,000 85719 $70,000-$79,999 85719 $90,000-$99,999 85716 Under $20,000 85719 $20,000-$29,999 85719 Under $20,000 85704 $100,000-$124,999 85719 Under $20,000 85719 $60,000-$69,999 85719 $80,000-$89,999 85713 $30,000-$39,999 85702 $20,000-$29,999 85716 $80,000-$89,999 85713 Under $20,000 $300,000-$349,999 $200,000-$249,999 In $125,000-$149,999 $250,000-$2 Book Buyers, Books & Maga: In $125,000-$149,999 $250,000-$2 Books & Magazines, Magazine St $150,000-$174,999. $100,000-$124,999 Inte $100,000-$124,999 Inte $150,000-$174,999 Inte $400,000-$449,999 Inte $75,000-$99 Book Buyers, Books & Magai Audi $200,000-$249,999 Inter $250,000-$299,999 Intern $800,000-$1 Books & Magazines, Comic E Audio $125,000-$149,999 Interne Way 30 VANDENBO Kleindale Rd 31 GUTIERREZ 1st Ave 32 Burrows St 33 KEYS Fort Lowell Rd. Tucson Tucson AZ Tucson AZ Tucson AZ Tucson AZ AZ 34 URBAN Greenlee Rd Tucson AZ 35 MOSES 4th: St Tucson AZ 36 MCMAHON Juanita St Tucson AZ 37 Figueroa 30th St Tucson AZ 38 FELIX Windy Peal Pl Tucson AZ 39 KRAEKEL Placita De Los Amigos Tucson AZ 40 BERMAN Park Ave Tucson AZ 41 BACON Seneca St Tucson AZ 85713 Under $20,000 85716 Under $20,000 85719 $40,000-$49,999 85704 $40,000-$49,999 85719 Under $20,000 85719 $125,000-$149,999 85719 $100,000-$124,999 85719 $40,000-$49,999 85713 Under $20,000 85704 $80,000-$89,999 85704 $125,000-$149,999 85719 Under $20,000 85719 Under $20,000 $75,000-$99 Books & Magazines, Magazine Subsc $50,000-$74,999 Interne $175,000-$199,999 Interne $100,000-$124,999 $150,000-$1 Book Buyers, Books & Magazines, Fick $175,000-$1 Book Buyers, Books & Maga: Audio Pr $250,000-$299,999 $300,000-$349,999 Internet $50,000-$74 Book Buyers, Books & Magazines, Mag $250,000-$2 Book Buyers, Books & Maga: Audio Pra Internet U $250,000-$299,999 $300,000-$2 Books & Magazines, Magazine Subscribe $150,000-$174,999 42 TYRRELL 43 ROBBINS Yellowston Ave Roger Tucson AZ 85704 $80,000-$89,999 $200,000-$2 Books & Magazines, Magazir Internet Us Rd Tucson AZ 85719 Under $20,000 $100,000-$124,999 Internet Us 11 BLANCHETI Sunriver Cir Tucson. AZ 85704 $80,000-$89,999 45 HEREFORD Klamath 46 DILL Dr Tucson AZ 85704 $100,000-$124,999 $250,000-$2 Books & Magazines $250,000-$299,999 Placita La Vina Tucson AZ 85719 $40,000-$49,999 Question 3 $100,000-$124,999 Internet Use Question 4 RawData + Fill in the mid-point value for the "Estimated Household Income" in the column "MidEHI" (rounded to the nearest dollar). This is useful for answering questions about the average (estimated) income of a sample sub-group. One way to do it is to create a Pivot Table to get the different "income brackets". Then extract the upper and lower dollar bounds of each income bracket and find the mid-point. See the homework video titled, "Generating mid-point EHI" for a demonstration (the video does not contain sound). Note: The rows in the demo video (RawData worksheet) won't match the rows in your workbook, but the basic steps and formulae are what we're trying to understand. There are other ways to generate this data, but doing this step manually (i.e., without use of Excel formulas) will lead to a loss of points. During grading, we look for an appropriate formula in the MidEHI column along with supporting data/worksheet(s) in your workbook. Note: you can assume "under 20,000" means to 0-20,000 B D E G LastNan Street Street S City State IEL Park Ave Tucson AZ VELASCO Adelaide Dr Tucson AZ B DOTSON Haven Ln Tucson AZ 4 DOLAN Graybill Dr Tucson AZ 5 FUNG 6 ALBIG Beauchamp Ln Tucson AZ Rancho Fel Pl Tucson AZ 7 Figueroa 46th St Tucson AZ Zip Code H Estimated Hous MidEHI 85719 $30,000-$39,999 85719 $175,000-$199,999 85719 $125,000-$149,999 85719 $20,000-$29,999 85704 $30,000-$39,999 85704 $100,000-$124,999 85713 Under $20,000 Estimated Books/MisMagazin $175,000-$1 Books & Magazines, Magaz $400,000-$449,999 $150,000-$1 Books & Magazines, Magazi $125,000-$1 Books & Magazines, Magazin $250,000-$299,999 $75,000-$99 Books & Magazines, Magazir 8 STANLEY Placita La Vina Tucson AZ 9 MACK Allen Rd Tucson AZ 85719 $30,000-$39,999 85719 Under $20,000 $100,000-$1 Book Buyers, Books & Maga $100,000-$124,999 10 DANG Water St Tucson AZ 85719 $40,000-$49,999 + $100,000-$1 Books & Magazines, Magazin 11 AMBROSE El Camino Del Norte Tucson AZ 12 CURD Edith Blvd 13 TURNER 14 SARONI Pueblo Vill. Dr Northern Ave Tucson Tucson AZ AZ 15 ROMANO Sunterra Ct 16 HUMPHREY Blacklidge Dr Tucson 17 LOVETT Prince Rd. Tucson Oro Valley AZ Tucson AZ AZ AZ 18 LYNGE Prince Rd Tucson AZ 19 RODRIGUE Ellis St Tucson AZ 20 IRWIN Norton Ave Tucson AZ 21 LUCAS Oracle Rd Tucson AZ 22 BRAGG Adelaide Dr Tucson AZ 23 FONTENOT Spring St Tucson AZ 24 MCKAY 25 Hart Helen Rocking Cir St St Tucson Tucson AZ AZ 26 WILKINS Po Box Tucson AZ 27 KNAUFF Speedway Blvd Tucson AZ 28 Hopkins 29 Marsden: Jones Ajo Blvd Tucson AZ 85716 $100,000-$124,999 85716 Under $20,000 85704 $20,000-$29,999 85704 $80,000-$89,999 85719 Under $20,000 85719 $70,000-$79,999 85719 $90,000-$99,999 85716 Under $20,000 85719 $20,000-$29,999 85719 Under $20,000 85704 $100,000-$124,999 85719 Under $20,000 85719 $60,000-$69,999 85719 $80,000-$89,999 85713 $30,000-$39,999 85702 $20,000-$29,999 85716 $80,000-$89,999 85713 Under $20,000 $300,000-$349,999 $200,000-$249,999 In $125,000-$149,999 $250,000-$2 Book Buyers, Books & Maga: In $125,000-$149,999 $250,000-$2 Books & Magazines, Magazine St $150,000-$174,999. $100,000-$124,999 Inte $100,000-$124,999 Inte $150,000-$174,999 Inte $400,000-$449,999 Inte $75,000-$99 Book Buyers, Books & Magai Audi $200,000-$249,999 Inter $250,000-$299,999 Intern $800,000-$1 Books & Magazines, Comic E Audio $125,000-$149,999 Interne Way 30 VANDENBO Kleindale Rd 31 GUTIERREZ 1st Ave 32 Burrows St 33 KEYS Fort Lowell Rd. Tucson Tucson AZ Tucson AZ Tucson AZ Tucson AZ AZ 34 URBAN Greenlee Rd Tucson AZ 35 MOSES 4th: St Tucson AZ 36 MCMAHON Juanita St Tucson AZ 37 Figueroa 30th St Tucson AZ 38 FELIX Windy Peal Pl Tucson AZ 39 KRAEKEL Placita De Los Amigos Tucson AZ 40 BERMAN Park Ave Tucson AZ 41 BACON Seneca St Tucson AZ 85713 Under $20,000 85716 Under $20,000 85719 $40,000-$49,999 85704 $40,000-$49,999 85719 Under $20,000 85719 $125,000-$149,999 85719 $100,000-$124,999 85719 $40,000-$49,999 85713 Under $20,000 85704 $80,000-$89,999 85704 $125,000-$149,999 85719 Under $20,000 85719 Under $20,000 $75,000-$99 Books & Magazines, Magazine Subsc $50,000-$74,999 Interne $175,000-$199,999 Interne $100,000-$124,999 $150,000-$1 Book Buyers, Books & Magazines, Fick $175,000-$1 Book Buyers, Books & Maga: Audio Pr $250,000-$299,999 $300,000-$349,999 Internet $50,000-$74 Book Buyers, Books & Magazines, Mag $250,000-$2 Book Buyers, Books & Maga: Audio Pra Internet U $250,000-$299,999 $300,000-$2 Books & Magazines, Magazine Subscribe $150,000-$174,999 42 TYRRELL 43 ROBBINS Yellowston Ave Roger Tucson AZ 85704 $80,000-$89,999 $200,000-$2 Books & Magazines, Magazir Internet Us Rd Tucson AZ 85719 Under $20,000 $100,000-$124,999 Internet Us 11 BLANCHETI Sunriver Cir Tucson. AZ 85704 $80,000-$89,999 45 HEREFORD Klamath 46 DILL Dr Tucson AZ 85704 $100,000-$124,999 $250,000-$2 Books & Magazines $250,000-$299,999 Placita La Vina Tucson AZ 85719 $40,000-$49,999 Question 3 $100,000-$124,999 Internet Use Question 4 RawData +
Expert Answer:
Answer rating: 100% (QA)
To fill in the midpoint value for the Estimated Household Income in the column ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Sketch the graph and draw several vertical and horizontal traces. (x, y) = sin(x y)
-
For each of the following cases, indicate in the chart below the appropriate discount rate (i) and the appropriate number of periods (n) to be used in present value calculations. Show calculations....
-
The space between two metallic coaxial cylinders of length L and radii a and b is completely filled with a material having a resistivity . (a) What is the resistance between the two cylinders? (b)...
-
Composite materials are: (a) Made mainly to improve temperature resistance (b) Used for improved optical properties (c) Made with strong fibers embedded in weaker and softer matrix to obtain strength...
-
In December 1992, Michael Eisner and the late Frank Wells of Walt Disney exercised a large number of stock options. The facts are summarized here. In 1984, Michael Eisner became chairman of Walt...
-
2022 792000 20% 2023 948000 15% The installment income is Crane's only temporary difference. What amount shoul Crane's December 31, 2020 balance sheet?
-
Write a program to sum the series: 1/1 + 22/2 + 33/3 + ....... n"/n
-
A company issued a bond in 30 June of year N. You have the following information about this bond: it was issued at par (50); it has an interest rate of 6%; it will be repaid in 30 June of N+5 and the...
-
In 2020, a certain company's net income was $200,000 . Their net income is projected to increase by 12% each year. This can be modeled by f(x)=200,000(1 0.12)x , where x is the number of years since...
-
Describe some of the following patterns below and how they deal with the creation of objects, identification of common communications patterns between objects, provide identified relationships...
-
In what ways can the Yerkes-Dodson law be applied to optimize employee performance?
-
Blue Sky Ltd. has provided you with the following information about their capital structure: Bonds - the company has 30,000 bonds with a face value of $100 each and a coupon rate of 5% with interest...
-
Joan exchanges a building she uses in her rental business for a building owned by Robert that she will use in her rental business. The adjusted basis of Joan's building is $150,000, and the FMV is...
-
Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH
-
Indicate whether each of the items listed below would be included (I) in or excluded (E) from gross income for the 2012 tax year. ________a. Welfare payments ________b. Commissions ________c. Hobby...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
Kathy Kennedy (age 44) is a single taxpayer and she lives at 212 North Pine Way, Payson, AZ 85541. Her Social Security number is 467-98-9784. Kathy's earnings and income tax withholding as the...
-
Which of the following is a type of plasmid? a. F factor (fertility factor) b. R factor (resistance plasmid) c. Virulence plasmids d. All of the above are types of plasmids.
-
During transduction involving a P1 phage, a. any small fragment of the bacterial chromosome may be transferred to another bacterium by a new phage. b. only a specific fragment of DNA may be...
-
In a diploid species, complete nondisjunction during meiosis I may produce a viable cell that is a. trisomic. b. haploid. c. diploid. d. triploid.
Study smarter with the SolutionInn App