[SOLVED] Graphing Island

Your population is thriving on your island. The data you have collected now needs to be displayed and further analyzed. Use the charts you created in the probability portion in weeks 1-3 for this part of the project. Always show your calculations or explain how you used technology. Take a picture of your calculator if you used that or submit your excel worksheet.1. a. Create a Scatter Plot using the total population for each of the years from the Probability Island. The horizontal axis should always represent time.b. Use linear regression or a trendline in Excel to find the equation of the best fit line.c. Find the Correlation Coefficient. Explain what this means for your data.d. Use the equation to predict the population in year 20.2. a. Use the first and last data points of the total population for each of the years from the Probability Island to find a linear equation to model the data.b. Graph the equation.c. Compare the slope of the Linear Regression Line of question 1 with the slope of this line. Provide an explanation of why they may similar or differ.d. Use the equation to predict the population in year 20.3. a. Assume that (0,150) represents the vertex of a quadratic equation. Find a quadratic equation using the tenth-year population as another point.b. Graph the equation.c. Use the equation to predict the population in year 20.4. Using the equation y = 2×2 -9x +4, explain and demonstrate how to find the x-intercepts, the y-intercept, the axis of symmetry, and the vertex of a quadratic equation.