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

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

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
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Spring '17
  • Phyllis Wiegmann
  • U.S. state, Use Excel

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"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

Ask a question for free

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern