LTE 10% 11:30 AM 2. Please use Microsoft Excel to analyze the data below The total population for the City of Lethbridge, as of April 2002, is 72,717, an increase of 5.83% or 4,005 over the 1999 figure. The population breakdown by quadrant is shown below Year North-Area South-Area West-Area Total 1961 1971 1976 1981 1983 1985 1987 1989 1992 1994 1997 1999 2002 11,806 14.346 19,126 21,370 21.510 21,706 21,652 21,476 21,863 21,745 21,301 21,821 22,347 23.105 26,422 26,276 25,843 26,326 26,398 26,341 25,720 26,123 26,197 26,188 27.127 27,941 34,911 40,856 46,818 54,624 58,086 59,901 60,610 60,614 63,390 64,938 66,035 68,712 72,717 68 7,411 10.250 11,797 12,617 13.418 15,404 16,996 18,546 19,764 22,429 Using the data above, create an Excel spreadsheet. 1. Verify the 5.83% increase in the statement above (this will verify your knowledge of the calculation) for the population increase between 1999 and 2002 what is the % increase in total population from 1997 to 2002? Plot the data for the total population growth from 1961-2002 Create a linear regression line for the total population from 1997 to 2002. What is the line equation and R- squared value? What does the R-squared value represent? 2, 3. 4. 5. 1 | Page 6. From 1976 to 1981, which area had the greatest % increase in population? Show the table and plot this data What is the line equation and R- squared value for the population growth in each area (question 6)? 7. 8. Compare the slopes of regression lines. What do you observe? 9. Use the regression line equation from question 4 to predict the population in 2020 10. Write a 1 page reflection on what you learned from the assignment Please write a report for ePortfolio submission. First include the above assignment at the beginning of the report, second an introduction on data analysis use in research, followed by third; itemized answers to the questionsthen your reflection on what you learned. Your Blu