Please use the data set that is available at the link below:

https://drive.google.com/file/d/1R_FHpuNPqxGWta_qW_Rwy8pgcTJRKQgx/view?usp=sharing

In all problems on this page and the next, we are going to run a linear regression model on a portion of a dataset from wwwkagglecom. This dataset contains information on the number of crimes that occurred in particular years in several US cities and the non seasonal housing price indices in those cities. Load the data set House Prices and Crime 1.csv which contains the following variables: - Year: The year in question . index_ 1183.: The non seasonal housing price index which is our dependent variable - City, State: The location . Homicides: The number of homicides per 1000 people - Rbberies: The number of robberies per 1000 people . Assaults: The number of assaults per 1000 people Housing Price Index and Crime 2.0 points possible (graded, results hidden) Compute the following quantities from the data using R. - Sample mean of Homicides: {Enter an answer correct to at least 3 decimal places.) . 15th percentile of Homicide: (Enter an answer correct to at least 3 decimal places.) . Sample standard deviation of Homicides: {Enter an answer correct to at least 3 decimal places. Both the biased or unbiased sample standard deviation will be accepted.) Which city has the median value of Housing price index? O Honolulu, HI O Newark, NJ Cambridge, MA O Wichita, KS O Mesa, AZEstimate the following linear model in R, and report the results on Bo and BH. index_nsa; = Bo + #Homicides; + BRRobberies; + BAAssaults; + &; (Enter your answers accurate to at least 1 decimal place.) BO = BH =Recall our linear model : index_nsai = Bo + By Homicides; + BRRobberies; + BA Assaults; + E; (2.2) and recall the the assumption that 81; . ..; En " IN (0, 0?). i.i.d. Bo Let B be the least square estimator of the vector 8 = BH BR BA What kind of distribution does B follow? O t-distribution with 3 degrees of freedom O t-distribution with 332 degrees of freedom O x2-distribution with 3 degrees of freedom O x2-distribution with 332 degrees of freedom Multivariate Gaussian distribution with mean BRecall our linear model : index_ use; = g + ,SHHomjcides; + ,SRRObbeTiESg + AAssaultsg + E; (2.3} You conduct a test with the null hypothesis Hg :A = [l to see if the number of assaults affect the housing price index. From the regression results from R, which of the following significance levels can you reject the null hypothesis? {Choose all that apply.) E 0.1% 1% 15% None of the above l: Cw. C C Construct a 95% confidence level [A, B) (centered at BH ) for BHI. Hint: You may use R to do this. (Enter numerical values up accurate to at least 1 decimal places.) A = B =