looking for help making sentences that relate to the problem. I have the whole e
ID: 3228328 • Letter: L
Question
looking for help making sentences that relate to the problem. I have the whole excel chart finished I just dont know how to write it to make sense. (15)(17)(18)(20)(22) thank you
Section 23 Absol ute a nd Relative Change 1 EXCEL Microsoft Excel Insert Page Layout Formulas Data Review View Developer cut Auto Sum Wrap Text Perc tage Merge & cent Past Format Painter rt Delete F Sort & Find & 2 clear Filter Select Formatting as Table Styles pboard Alignment Editing 2 htt Zwww.stats.indiana.edu Submit spreadsheet with changes and 48,248.00 4 Entire state 47,697.00 answers via Blackboard. 48,055.00 50,542.00 5 Carrol 6 Davies 44, S92.00 47,165.00 7 Fountain 42,817.00 45,884.00 41,103.00 43,980.00 Greene 2,877.00 43, S90.00 4S, 003.00 Howard 1,413.00 10 Johnson 61,629.00 61,231.00 (398.00) 39,485.00 42,023.00 Miami 2,538.000 13 Absolute Change from Johnson to Greene for 2013 14 Relative change from Johnson to Greene for 2013 15 write a sentence(s) to explain the meaning of the values you found in cells D13 and D14. What do the values mean forthese countys? 16 17 Consider Carroll and Miami County's median incomes for 2013 write a sentence(s) that compare the two countys using absolute and relativechange statements. What do the values mean for these countys? 20 Insert a bar(column) graph(s) of the median income data for the year 2010 and for 2013. 22 What are some trends that you see in this data? Find at least 2 Sheet1 Ready Type here to search 4 PM 4/26/2017Explanation / Answer
Let’s calculate D13, D14.
Absolute changes from Johnson to Greene in 2013 = 61,231 – 43,980 = 17, 251 (D 13)
Relative changes from Johnson to Greene in 2013 = 17,251/61,231 = 28.17 % (D 14)
Q 15. The result from D13, D14:
As per the results from D13, we can understand that in the year 2013 Johnson county has a higher household income than Greene county by an amount 17,251 per household. As per D14, we can understand that Johnson county’s household income is 28.17% higher than that of Greene county for the same year.
Q 17. Carrol county’s median household income in 2013 = 50,542
Miami county median household income in 2013 = 42,023
Q 18. Absolute difference = 50,542 – 42,023 = 8,519
Absolute difference = 8519/50542 = 16.85 %
Result from the above:
In the year 2013, the absolute difference in the household income of Carrol county is 8,519 higher than that of Miami county.
Carrol county the median household income is higher by 16.85% as compared to that of Miami county for the same year.
Q 20.
Observation 1:
Household income increases for all counties except for Howard and Johnson counties where the household income decreases between the year 2010 and 2013.
Observation 2:
Both in the year 2010 and in 2013, Johnson county has the highest household income and Miami has the lowest household income.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.