Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
A B C D E F G H K 1 INDIVIDUALS GRANTED ASYLUM AFFIRMATIVELY BY REGION AND COUNTRY OF NATIONALITY: FISCAL YEARS 2003 TO 2012 L M N 0 P Q R 2 3 Region of nationality 2003 4 Africa 4031 2004 3846 2005 2676 2006 2040 2007 2008 2009 2010 2011 2012 Amount change Pct change 2505 2644 2819 2631 3025 5031 5 Asia 5224 3039 3863 3330 4422 4841 5543 5406 6454 8070 6 Europe 1060 862 676 548 675 753 811 727 960 1219 7 North America 1510 2207 2909 3595 2239 1750 1481 1426 1537 1689 8 Oceania 60 64 23 18 27 23 17 8 19 20 9 South America 3422 4265 3308 3383 2439 1978 1125 928 10 Unknown 60 57 36 41 53 92 129 52 1328 46 1437 40 11 12 Totals 13 14 15 16 17 18 19 20 21 22 23 24 25 You have 10 years of data for grants of affirmative asylum. 1. In Column L, calculate the amount or raw change for 2003-2012 2. In Column M, calculate the percent change for 2003-2012. 3. Which region saw the biggest growth in raw numbers? Which region had the biggest percent change? 4. Calculate totals for each year, including the amount change and percent change. 26 27

A B C D E F G H K 1 INDIVIDUALS GRANTED ASYLUM AFFIRMATIVELY BY REGION AND COUNTRY OF NATIONALITY: FISCAL YEARS 2003 TO 2012 L M N 0 P Q R 2 3 Region of nationality 2003 4 Africa 4031 2004 3846 2005 2676 2006 2040 2007 2008 2009 2010 2011 2012 Amount change Pct change 2505 2644 2819 2631 3025 5031 5 Asia 5224 3039 3863 3330 4422 4841 5543 5406 6454 8070 6 Europe 1060 862 676 548 675 753 811 727 960 1219 7 North America 1510 2207 2909 3595 2239 1750 1481 1426 1537 1689 8 Oceania 60 64 23 18 27 23 17 8 19 20 9 South America 3422 4265 3308 3383 2439 1978 1125 928 10 Unknown 60 57 36 41 53 92 129 52 1328 46 1437 40 11 12 Totals 13 14 15 16 17 18 19 20 21 22 23 24 25 You have 10 years of data for grants of affirmative asylum. 1. In Column L, calculate the amount or raw change for 2003-2012 2. In Column M, calculate the percent change for 2003-2012. 3. Which region saw the biggest growth in raw numbers? Which region had the biggest percent change? 4. Calculate totals for each year, including the amount change and percent change. 26 27

Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 3.3CP
See similar textbooks
icon
Related questions
Question
A B C D E F G H K 1 INDIVIDUALS GRANTED ASYLUM AFFIRMATIVELY BY REGION AND COUNTRY OF NATIONALITY: FISCAL YEARS 2003 TO 2012 L M N 0 P Q R 2 3 Region of nationality 2003 4 Africa 4031 2004 3846 2005 2676 2006 2040 2007 2008 2009 2010 2011 2012 Amount change Pct change 2505 2644 2819 2631 3025 5031 5 Asia 5224 3039 3863 3330 4422 4841 5543 5406 6454 8070 6 Europe 1060 862 676 548 675 753 811 727 960 1219 7 North America 1510 2207 2909 3595 2239 1750 1481 1426 1537 1689 8 Oceania 60 64 23 18 27 23 17 8 19 20 9 South America 3422 4265 3308 3383 2439 1978 1125 928 10 Unknown 60 57 36 41 53 92 129 52 1328 46 1437 40 11 12 Totals 13 14 15 16 17 18 19 20 21 22 23 24 25 You have 10 years of data for grants of affirmative asylum. 1. In Column L, calculate the amount or raw change for 2003-2012 2. In Column M, calculate the percent change for 2003-2012. 3. Which region saw the biggest growth in raw numbers? Which region had the biggest percent change? 4. Calculate totals for each year, including the amount change and percent change. 26 27
Transcribed Image Text:A B C D E F G H K 1 INDIVIDUALS GRANTED ASYLUM AFFIRMATIVELY BY REGION AND COUNTRY OF NATIONALITY: FISCAL YEARS 2003 TO 2012 L M N 0 P Q R 2 3 Region of nationality 2003 4 Africa 4031 2004 3846 2005 2676 2006 2040 2007 2008 2009 2010 2011 2012 Amount change Pct change 2505 2644 2819 2631 3025 5031 5 Asia 5224 3039 3863 3330 4422 4841 5543 5406 6454 8070 6 Europe 1060 862 676 548 675 753 811 727 960 1219 7 North America 1510 2207 2909 3595 2239 1750 1481 1426 1537 1689 8 Oceania 60 64 23 18 27 23 17 8 19 20 9 South America 3422 4265 3308 3383 2439 1978 1125 928 10 Unknown 60 57 36 41 53 92 129 52 1328 46 1437 40 11 12 Totals 13 14 15 16 17 18 19 20 21 22 23 24 25 You have 10 years of data for grants of affirmative asylum. 1. In Column L, calculate the amount or raw change for 2003-2012 2. In Column M, calculate the percent change for 2003-2012. 3. Which region saw the biggest growth in raw numbers? Which region had the biggest percent change? 4. Calculate totals for each year, including the amount change and percent change. 26 27
Expert Solution
steps

Step by step

Solved in 2 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS