Showing posts with label formula. Show all posts
Showing posts with label formula. Show all posts

April 4, 2012

Fluctuating Migration Rate- Graph/Explanation



This equation represents a fluctuating migration rate to and from an island. This island loses a vast majority of its food every other year due to various, but consistent, weather conditions. The birds responded by migrating to another island for food. Every other year less birds returned to the primary island due to the lack of food. Eventually zero birds returned to the island because there was a constant source of food elsewhere.

Breaking down the equation.
 = Population of the previous year
 = Initial rate of migration (zero)
Reasoning behind "-1.1" = This is a constant. It serves as a 110% change in population; Being negative and raising it to an exponent allows for positive changes every other year and negative changes on the off years.
 = The constant rate of change in the migration rate (.05)
 = **The primary reason this equation prevails. By raising the numerator to the year number, immigration and emigration are introduced.(Raising a negative number to an even term makes it positive; raising it to an odd keeps it negative. This also creates a smaller number in the numerator because decimals(created by the 1.1 constant and the change of migration rate) become smaller when affected by an exponent. Creating a smaller number each time allows for an eventual emigration rate to exceed the immigration rate, bringing the population to zero.
The altered migration rate divided by 100 = The creation of a decimal prevents the migration rate from remaining at percentages over 100. Without dividing by 100 the island would hit a population size of zero after just a few years.

This activity as a whole
Throughout the three days we spent a majority of our time in class creating various graphs and data sets. The graphs progressively got more challenging to make because of the new items introduced into the equations each time. Learning how to create formulas to form graphs on population gave me the right tools I needed to construct the formula that I did. This experience was one of learning and was a big eye opener to my capabilities to extend a thought process into a visible and quantifiable set of data.

Sparrow Population









The formula i created shows the sparrow population fluctuating constantly; it increases and then decreases, then increases and decreases. This is because at certain points the birth/immigration rate is greater than the death/emigration rat, and vice versa. And as the years progress it continues to cycle, until it finally comes to a stop at the 99th year, and the population levels off and remains the same. The population equilibrium could be a result of many factors; the most reasonable factor could be that the birth/immigration rate became equal with the death/emigration rate. This would be an extremely ideal circumstance because this means that a decent amount of birds (2,632) could be sustained in this environment without running out of resources or exceeding the carrying capacity. 

The way we progressed during the course of this activity from simpler to increasingly complex models really made it easy to understand how to work spreadsheets very efficiently. It was a good learning process. Spreadsheets are also a good way to do business from a science standpoint because spreadsheets perform any type of calculation you type in, and everything stays organized and clear, and it processes the information quickly. It is also very easy to go back and make any corrections to your mistakes.