Section 7 Absolute and Relative Change State's Data.xlsx

# Section 7 Absolute and Relative Change State's Data.xlsx -...

• 3
• 100% (1) 1 out of 1 people found this document helpful

This preview shows page 1 - 2 out of 3 pages.

This set of data shows the number of Children whose parents lack secure employment for a select Use Excel to calculate the absolute and relative change for each state from 2008 to 2 1.) 2008 2016 Absolute Change from 2008 to 2016 Florida 1,112,000 1,230,000 118,000 Illinois 836,000 772,000 (64,000) Indiana 438,000 447,000 9,000 Iowa 151,000 159,000 8,000 Kentucky 327,000 332,000 5,000 Louisiana 350,000 393,000 43,000 Michigan 728,000 669,000 (59,000) Mississippi 269,000 249,000 (20,000) Missouri 384,000 362,000 (22,000) Ohio 763,000 744,000 (19,000) 2.) 3.) Create a set of bar graphs (column charts) using the original data (column C & D) for the states for 2 4.) Write a few sentences about the changes in the states from 2008 to 2016 Which state had the most 5.) Use Absolute and Relative Change to Compare the state's values to one another for the following: 6.) 7.) 8.) Write a meaningful sentence using the Absolute and Relative change values you found for Indiana In 2016 there were 9,000 more parents with out secure employment than in 2009. The number o employment increased by 2% from 2008 to 2016. According to the bar graph there was more absolute change than there was relative. Illinios, Michigan, and Ohio's num decreased, but the biggest improvement overall relatively was michigan. Michigan had decreased the number of children

Subscribe to view the full document.

• Spring '17
• Phyllis Wiegmann
• U.S. state, Use Excel

{[ snackBarMessage ]}

###### "Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern