For this assignment I made some drastic, and some hopeful, reductions to the budget:
As you can see, I cut out much at the bottom. Of course this is only advisable if the IRA does not have a monthly minimum contribution. This is also only possible if the mortgage can be refinanced.
For this assignment, I took data from the U.S. Census on the number of speakers of Indigenous Languages. Since these are endangered languages, the numbers are quite small. I calculated the percentage of each language population over the total number of speakers of indigenous languages in the US. I also calculated the percentage of each group from the total US Population. The spreadsheet is posted below (google docs):
For this assignments, I graphed data from the spreadsheet that I created in 2 above.
I also have examples of graphs made from spreadsheets in my thesis posted in the File Cabinet. Since the topic is populations of speakers of a language, pie charts made the most sense as a representation of the data.
Chart 1 is of the percent of speakers of an indigenous language in the US out of all speakers of indigenous languages.
1. Endangered languages disappear everyday around the world. The size of the population of native speakers is a factor in the survival of an endangered language. Using the spreadsheet in No. 2 above, compare the population size of Navajo, Dakota, Cherokee, and Apache with Cocomaricopa, Cahuila, Wichita, and Mono. What role do you think these languages' population size has on their futures?
Answer: Navajo, Dakota, Cherokee, and Apache have large populations as compared to Cocomaricopa, Cahuila, Wichita, and Mono. The languages with larger population populations have a better chance of maintaining their speech community.
2. Look at the percent of speakers that live on the reservation. What role do you think having a cohesive speech community has? What languages have the most cohesive speech communities?
Answer: Caddo, Chatemacha, Osage, and Jicarilla are at the top of the list. These languages have a better chance of maintaining their language than other languages with similar number of speakers. Here is a screen grab of the sorted chart: