Reference no: EM132329965
Assignment
This set of data shows the number of Children whose parents lack secure employment for a select set of states for 2008 and 2016.
Use Excel to calculate the absolute and relative change for each state from 2008 to 2016 in the cells below.
|
2008 |
2016 |
Absolute Change from 2008 to 2016 |
Relative Change from 2008 to 2016 |
Illinois |
836,000 |
772,000 |
|
|
Indiana |
438,000 |
447,000 |
|
|
Kentucky |
327,000 |
332,000 |
|
|
Michigan |
728,000 |
669,000 |
|
|
Ohio |
763,000 |
744,000 |
|
|
Missouri |
384,000 |
362,000 |
|
|
Write a meaningful sentence using the Absolute and Relative change values you found for Indiana from 2008 to 2016.
Write a few sentences about the changes in the states from 2008 to 2016 Which state had the most improvement? Which had the largest increase?
Use Absolute and Relative Change to Compare the state's values to one another for the following:
Compare Illinois to Ohio using Absolute Change for the 2016 (column D) values
Compare Illinois to Ohio using Relative Change for the 2016 (column D) values
Use the values you found for absolute and relative change to compare the two states in a meaningful sentence(s).
Use the 2016 (column D) values to compare Indiana to Missouri using Relative Change.
Use the 2016 (column D) values to compare Missouri to Indiana using Relative Change
Use the values you found for relative change to compare the two states in two meaningful sentences.