{"id":226646,"date":"2018-09-17T08:04:22","date_gmt":"2018-09-17T08:04:22","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/17\/mat-106-module-5-assignment-1-lasa-2-exponential-growth\/"},"modified":"2018-10-24T09:02:21","modified_gmt":"2018-10-24T09:02:21","slug":"mat-106-module-5-assignment-1-lasa-2-exponential-growth","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/mat-106-module-5-assignment-1-lasa-2-exponential-growth\/","title":{"rendered":"MAT 106 Module 5 Assignment 1 LASA 2 Exponential Growth"},"content":{"rendered":"<p>In\u00a0Module 4, you were introduced to the concept of exponential functions that can be used to model growth and decay. Recall what you learned in\u00a0The Number e\u00a0lecture.\u00a0In this exercise, you will use a Microsoft Excel spreadsheet to calculate the exponential growth of a population of your choosing. (If you use the linked spreadsheet below, it is recommended that you\u00a0consider relatively small populations and not those of entire nations.)\tClick\u00a0here\u00a0to open the Microsoft Excel spreadsheet that you will use to perform the calculations for this assignment.\tIn the spreadsheet, perform the following operations:\t1. \ufffd Input a population value into the box next to\u00a0Initial Population\u00a0on the spreadsheet. This population should be anything such as the people, animals, microorganisms, or plants.\t2. \ufffd Input a rate of growth for your population into the box next to\u00a0Rate 1. Since we are interested in a positive annual percent growth rate per year, this number should be greater than zero percent. Be sure to input this number in the form of a decimal.\t3. \ufffd Repeat the above procedure for\u00a0Rate 2\u00a0and\u00a0Rate 3. Make sure that the values you select differ by two percent. For example, the values 0.01, 0.03, and 0.05 would be good choices.\t4. \ufffd Under the\u00a0Time (years)\u00a0column, input three different year values. Make sure that your values increase by a minimum of ten years. For example, 10, 20, 30 years would be good choices. If you want to see a more dramatic change, select a longer time frame such as 10, 50, and 100 years.\t5. \ufffd When you input all of your data, you&#8217;ll see that the spreadsheet has performed the calculations for the future size of each population, rate of growth, and time interval. Additionally, this information will be presented graphically in the chart. To draw an exponential curve for each series, do the following:\t1. \ufffd Right click on the middle point for one of the series.\t2. \ufffd Click on add\u00a0trendline.\t3. \ufffd Under Trendline Options, select\u00a0Exponential.\t4. \ufffd Click Close\t5. \ufffd Repeat these steps for the other series.\tNow that you&#8217;ve completed your analysis, it is now time to report the results and examine your findings.\tIn a Microsoft Word document, respond to the following:\t1. \ufffd Calculate what the future size of the population will be, given a specific initial population, rate of growth, and time interval.\tUse the exponential equation: Future value = Present value * exp(rt)\t\u00b7 \ufffd\u00a0\u00a0\u00a0 \u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 exp is the base &#8220;e&#8221;\t\u00b7 \ufffd\u00a0\u00a0\u00a0 r = annual rate of growth expressed as a percent\t\u00b7 \ufffd\u00a0\u00a0\u00a0 t = years\tNote: The spreadsheet performed these calculations for you, so you can check the answer you obtain with those in the spreadsheet. In order to perform this calculation, you&#8217;ll need to have access to a scientific calculator that will have an ex button in order to perform the exp(rt) calculation. There are a number of free scientific calculators available over the Internet. Additionally, all smartphones have calculator apps that have a scientific mode. Check with your instructor for a list of currently available free options if you do not own a scientific calculator.\u00a0\t1. \ufffd Repeat the calculation for at least two other values of t; make sure they are at least two years apart from one another. Use the same values you input into the spreadsheet and compare the answers you obtain to those that appear in the spreadsheet.\t1. \ufffd Repeat the calculations using two more selections of population growth rate; ensure that each population growth rate is at least two percent different than the others. Use the same values you input into the spreadsheet and compare the answers you obtain to those that appear in the spreadsheet.\t1. \ufffd Examine the graph that your spreadsheet produced based upon the calculations. Did this graph consist of straight lines or curved lines? Describe the shape of these lines for each growth rate. How did they differ? Why?\t2. \ufffd Explain the implications of growth rate for your population. What do you think will happen over a long period of time if a given population of organisms is allowed to increase without limits? Are there environmental factors that keep populations from growing exponentially unchecked? What would be the impact on environmental resources?\u00a0\t3. \ufffd Explain the likelihood of your results. Would it be expected that the percent growth rate would stay constant over long periods? Is exponential growth an appropriate assumption for long periods? If not, what other changes in population size might be expected?\tFor this assignment, you will submit a spreadsheet and a report. The spreadsheet will be the Microsoft Excel file containing your analysis. Name your Microsoft Excel file as follows: LastnameFirstInitial_M5_A1.xls.\tThe report will be a Microsoft Word document in which you will address all of the questions in this assignment in the form of a narrative. Name your Microsoft Word document as follows: LastnameFirstInitial_M5_A1.docx.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In\u00a0Module 4, you were introduced to the concept of exponential functions that can be used to model growth and decay. Recall what you learned in\u00a0The Number e\u00a0lecture.\u00a0In this exercise, you will use a Microsoft Excel spreadsheet to calculate the exponential <a href=\"https:\/\/www.benedictsol.com\/blogs\/mat-106-module-5-assignment-1-lasa-2-exponential-growth\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-226646","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/226646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=226646"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/226646\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=226646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=226646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=226646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}