Use the provided data in Table 1 to fill in the data missing in Table 2 (HINT: You should only have to type in ONE equation to the first cell of the table. If you use proper cell references, you can complete the entire table with that one formula). 1) Which county in Washington State had the highest percentage increase in population from 1920 to 1930? 2) 2000 - 2010? 3) Between which 10 years was the highest percentage increase in population for Washington State? State reasons why there might have been such a large increase during this time period. 4) Use the given information to predict the population in Washington State in 2020.5) Based on population in Washington State today (Google it), do you think that this is a reasonable estimate and why? Highest % Increase in Population 3) Between which period did Washington State have the highest % increase? Why do you think this period had the largest increase? 1) 2) 1920 - 1930 2000 - 2010 4) 2020 Population Prediction: 5) The average annual growth rate for Washington State since 1920 has been about 1%, with a doubling time of approximately 40 years. Use your prediction from question 4 which estimates Washington State population in 2020 (which uses cell references). Based on today's population (Google it), do you think that this is a reasonable estimate and why? Table 1: Data obtained from WA State Office of Financial Management - Decennial census counts of population 1890 - 2010 G H B CUUINTI D 1930 2010 Adams Asotin Benton Chelan Clallam Clark Columbia Cowlitz Douglas Ferry Franklin Garfield Grant Grays Harbor Island Jefferson King Kitsap Kittitas Klickitat Lewis Lincoln Mason Okanogan Pacific Pend Oreille Pierce San Juan Skagit Skamania 1920 9,623 6,539 10,903 20,906 11,368 32,805 6,093 11,791 9,392 5,143 5,877 3,875 7,771 44,745 5,489 6,557 389,273 33,162 17,737 9,268 36,840 15,141 4,919 17,094 14,891 6,363 144,127 3,605 33,373 2,357 7,719 8,136 10,952 31,634 20,449 40,316 5,325 31,906 7,561 4,292 6,137 3,662 5,666 59,982 5,369 8,346 463,517 30,776 18,154 9,825 40,034 11,876 10,060 18,519 14,970 7,155 163,842 3,097 35,142 2,891 E 1940 6,209 8,365 12,053 34,412 21,848 49,852 5,549 40,155 8,651 4,701 6,307 3,383 14,668 53,166 6,098 8,918 504,980 44,387 20,230 11,357 41,393 11,361 11,603 24,546 15,928 7,156 182,081 3,157 37,650 4,633 1950 6,584 10,878 51,370 39,301 26,396 85,307 4,860 53,369 10,817 4,096 13,563 3,204 24,346 53,644 11,079 11,618 732,992 75,724 22,235 12,049 43,755 10,970 15,022 29,131 16,558 7,413 275,876 3,245 43,273 4,788 1960 9,929 12,909 62,070 40,744 30,022 93,809 4,569 57,801 14,890 3,889 23,342 2,976 46,477 54,465 19,638 9,639 935,014 84,176 20,467 13,455 41,858 10,919 16,251 25,520 14,674 6,914 321,590 2,872 51,350 5,207 1970 12,014 13,799 67,540 41,103 34,770 128,454 4,439 68,616 16,787 3,655 25,816 2,911 41,881 59,553 27,011 10,661 1,159,375 101,732 25,039 12,138 45,467 9,572 20,918 25,867 15,796 6,025 412,344 3,856 52,381 5,845 1980 13,267 16,823 109,444 45,061 51,648 192,227 4,057 79,548 22,144 5,811 35,025 2,468 48,522 66,314 44,048 15,965 1,269,898 147,152 24,877 15,822 56,025 9,604 31,184 30,663 17,237 8,580 485,667 7,838 64,138 7,919 1990 13,603 17,605 112,560 52,250 56,204 238,053 4,024 82,119 26,205 6,295 37,473 2,248 54,798 64,175 60,195 20,406 1,507,305 189,731 26,725 16,616 59,358 8,864 38,341 33,350 18,882 8,915 586,203 10,035 79,545 8,289 K 2000 16,428 20,551 142,475 66,616 64,179 345,238 4,064 92,948 32,603 7,260 49,347 2,397 74,698 67,194 71,558 26,299 1,737,046 231,969 33,362 19,161 68,600 10,184 49,405 39,564 20,984 11,732 700,818 14,077 102,979 9,872 18,728 21,623 175,177 72,453 71,404 425,363 4,078 102,410 38,431 7,551 78,163 2,266 89,120 72,797 78,506 29,872 1,931,249 251,133 40,915 20,318 75,455 10,570 60,699 41,120 20,920 13,001 795,225 15,769 116,901 11,066 Snohomish Spokane Stevens Thurston Wahkiakum Walla Walla Whatcom Whitman Yakima WA State Population 67,690 141,289 21,605 22,366 3,472 27,539 50,600 31,323 63,710 1,356,621 78,861 150,477 18,550 31,351 3,862 28,441 59,128 28,014 77,402 1,563,396 88,754 164,652 19,275 37,285 4,286 30,547 60,355 27,221 99,019 1,736,191 111,580 221,561 18,580 44,884 3,835 40,135 66,733 32,469 135,723 2,378,963 172,199 278,333 17,884 55,049 3,426 42,195 70,317 31,263 145,112 2,853,214 265,236 287,487 17,405 76,894 3,592 42,176 81,983 37,900 145,212 3,413,250 337,720 341,835 28,979 124,264 3,832 47,435 106,701 40,103 172,508 4,132,353 465,628 361,333 30,948 161,238 3,327 48,439 127,780 38,775 188,823 4,866,663 606,024 417,939 40,066 207,355 3,824 55,180 166,826 40,740 222,581 5,894,143 713,33 471,22 43,53 252,26 3,97 58,78 201,14 44,77 243,23 6,724,54 22 Table 2 Percent Change in Population 1950-1960 1960 - 1970 1970 - 1980 23 24 25 COUNTY 1920 - 1930 1930 - 1940 1940 - 1950 1980 - 1990 1990 - 2000 2000 - 2010 Adams 26 Asotin 27 28 29 30 31 32 33 34 35 36 37 38 Benton Chelan Clallam Clark Columbia Cowlitz Douglas Ferry Franklin Garfield Grant Grays Harbor Island Jefferson King Kitsap Kittitas Klickitat Lewis Lincoln Mason Okanogan Pacific Pend Oreille 39 40 41 42 43 44 45 46 47 48 49 50 Use the provided data in Table 1 to fill in the data missing in Table 2 (HINT: You should only have to type in ONE equation to the first cell of the table. If you use proper cell references, you can complete the entire table with that one formula). 1) Which county in Washington State had the highest percentage increase in population from 1920 to 1930? 2) 2000 - 2010? 3) Between which 10 years was the highest percentage increase in population for Washington State? State reasons why there might have been such a large increase during this time period. 4) Use the given information to predict the population in Washington State in 2020.5) Based on population in Washington State today (Google it), do you think that this is a reasonable estimate and why? Highest % Increase in Population 3) Between which period did Washington State have the highest % increase? Why do you think this period had the largest increase? 1) 2) 1920 - 1930 2000 - 2010 4) 2020 Population Prediction: 5) The average annual growth rate for Washington State since 1920 has been about 1%, with a doubling time of approximately 40 years. Use your prediction from question 4 which estimates Washington State population in 2020 (which uses cell references). Based on today's population (Google it), do you think that this is a reasonable estimate and why? Table 1: Data obtained from WA State Office of Financial Management - Decennial census counts of population 1890 - 2010 G H B CUUINTI D 1930 2010 Adams Asotin Benton Chelan Clallam Clark Columbia Cowlitz Douglas Ferry Franklin Garfield Grant Grays Harbor Island Jefferson King Kitsap Kittitas Klickitat Lewis Lincoln Mason Okanogan Pacific Pend Oreille Pierce San Juan Skagit Skamania 1920 9,623 6,539 10,903 20,906 11,368 32,805 6,093 11,791 9,392 5,143 5,877 3,875 7,771 44,745 5,489 6,557 389,273 33,162 17,737 9,268 36,840 15,141 4,919 17,094 14,891 6,363 144,127 3,605 33,373 2,357 7,719 8,136 10,952 31,634 20,449 40,316 5,325 31,906 7,561 4,292 6,137 3,662 5,666 59,982 5,369 8,346 463,517 30,776 18,154 9,825 40,034 11,876 10,060 18,519 14,970 7,155 163,842 3,097 35,142 2,891 E 1940 6,209 8,365 12,053 34,412 21,848 49,852 5,549 40,155 8,651 4,701 6,307 3,383 14,668 53,166 6,098 8,918 504,980 44,387 20,230 11,357 41,393 11,361 11,603 24,546 15,928 7,156 182,081 3,157 37,650 4,633 1950 6,584 10,878 51,370 39,301 26,396 85,307 4,860 53,369 10,817 4,096 13,563 3,204 24,346 53,644 11,079 11,618 732,992 75,724 22,235 12,049 43,755 10,970 15,022 29,131 16,558 7,413 275,876 3,245 43,273 4,788 1960 9,929 12,909 62,070 40,744 30,022 93,809 4,569 57,801 14,890 3,889 23,342 2,976 46,477 54,465 19,638 9,639 935,014 84,176 20,467 13,455 41,858 10,919 16,251 25,520 14,674 6,914 321,590 2,872 51,350 5,207 1970 12,014 13,799 67,540 41,103 34,770 128,454 4,439 68,616 16,787 3,655 25,816 2,911 41,881 59,553 27,011 10,661 1,159,375 101,732 25,039 12,138 45,467 9,572 20,918 25,867 15,796 6,025 412,344 3,856 52,381 5,845 1980 13,267 16,823 109,444 45,061 51,648 192,227 4,057 79,548 22,144 5,811 35,025 2,468 48,522 66,314 44,048 15,965 1,269,898 147,152 24,877 15,822 56,025 9,604 31,184 30,663 17,237 8,580 485,667 7,838 64,138 7,919 1990 13,603 17,605 112,560 52,250 56,204 238,053 4,024 82,119 26,205 6,295 37,473 2,248 54,798 64,175 60,195 20,406 1,507,305 189,731 26,725 16,616 59,358 8,864 38,341 33,350 18,882 8,915 586,203 10,035 79,545 8,289 K 2000 16,428 20,551 142,475 66,616 64,179 345,238 4,064 92,948 32,603 7,260 49,347 2,397 74,698 67,194 71,558 26,299 1,737,046 231,969 33,362 19,161 68,600 10,184 49,405 39,564 20,984 11,732 700,818 14,077 102,979 9,872 18,728 21,623 175,177 72,453 71,404 425,363 4,078 102,410 38,431 7,551 78,163 2,266 89,120 72,797 78,506 29,872 1,931,249 251,133 40,915 20,318 75,455 10,570 60,699 41,120 20,920 13,001 795,225 15,769 116,901 11,066 Snohomish Spokane Stevens Thurston Wahkiakum Walla Walla Whatcom Whitman Yakima WA State Population 67,690 141,289 21,605 22,366 3,472 27,539 50,600 31,323 63,710 1,356,621 78,861 150,477 18,550 31,351 3,862 28,441 59,128 28,014 77,402 1,563,396 88,754 164,652 19,275 37,285 4,286 30,547 60,355 27,221 99,019 1,736,191 111,580 221,561 18,580 44,884 3,835 40,135 66,733 32,469 135,723 2,378,963 172,199 278,333 17,884 55,049 3,426 42,195 70,317 31,263 145,112 2,853,214 265,236 287,487 17,405 76,894 3,592 42,176 81,983 37,900 145,212 3,413,250 337,720 341,835 28,979 124,264 3,832 47,435 106,701 40,103 172,508 4,132,353 465,628 361,333 30,948 161,238 3,327 48,439 127,780 38,775 188,823 4,866,663 606,024 417,939 40,066 207,355 3,824 55,180 166,826 40,740 222,581 5,894,143 713,33 471,22 43,53 252,26 3,97 58,78 201,14 44,77 243,23 6,724,54 22 Table 2 Percent Change in Population 1950-1960 1960 - 1970 1970 - 1980 23 24 25 COUNTY 1920 - 1930 1930 - 1940 1940 - 1950 1980 - 1990 1990 - 2000 2000 - 2010 Adams 26 Asotin 27 28 29 30 31 32 33 34 35 36 37 38 Benton Chelan Clallam Clark Columbia Cowlitz Douglas Ferry Franklin Garfield Grant Grays Harbor Island Jefferson King Kitsap Kittitas Klickitat Lewis Lincoln Mason Okanogan Pacific Pend Oreille 39 40 41 42 43 44 45 46 47 48 49 50