LAB#2: Linear Regression 1) Construct a summary table (Descriptive Statistics) i) Population ii) Murder iii) Burglary 2) a) Use excel to regress the following variables: i) Population vs Murder ii) Population vs Burglary iii) Population vs Theft b) State and interpret the following for each regression: (i) r -correlation coefficient (ii) 72 -coefficient of determination (iii) regression equation and their coefficients ( = +) Year Population Murder Rape Robbery Burglary Theft 2011 332000 124 27 147 1094 1024 2012 341000 145 28 487 1106 950 2013 345707 99 26 296 390 1011 2014 353366 123 43 291 835 1123 2015 360926 119 40 214 742 1027 2016 368399 138 23 232 800 857 2017 375775 142 22 258 757 103 2018 383071 143 21 284 783 91 2019 390351 134 30 251 693 89 2020 397621 102 25 160 479 67 2021 405000 125 12 167 456 77