I have no way of uploading the dataset here that is why I uploaded it to google drive.

This question is a continuation of the question in this link:

https://www.coursehero.com/qa/wait/43953484/?question_id=43953484

Please use the dataset at the link below to answer the questions:

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

In the following problems, we will analyze the same data on housing and crime from the previous page. You are interested in finding out more generally whether crime {including Robberies, Assaults and Homicides} have an effect the housing price index. in the problems below, you will conduct an F-test to test this hypothesis: Ho =5H--l9a+l33=0 H1 =53 --l9g+}312 as 0. F-test Concept Checks 1.0 point possible (graded, results hidden} Which of the following is true about the F-test reported in a regression summary in R? Assume a linear model with Y = 50 + 131K1 + )9sz + 53113 + 135154 + E- O The F-test reported is testing whether ,81 = 32 2 g = 54 = D O The F-test reported is testing whether ,80 = ; 2 g = g = E4 = [l O The F-test reported is testing whether any of the coefficients is zero. Which of the following is true about the F-test? The value of the F-statistic will depend on the significance level of the test If we consider the model Y = Bo + 1X1 + , then the F-statistic and the t-statistic for B1 coincide. If we consider the model Y = Bo + 1 X1 + , then the p-value of the -test and the p-value of the t-test for 61 coincide.Restricted Model 1 point possible (graded, results hidden) Recall that you are conducting an F test for the following hypotheses: Ho : BH + BA + BR = 0 H1 : BH + BA + BR # 0. Which of the following restricted model could you use in this F-test? (Choose all that apply.) index_nsai = Bo + BAHomicides; + BARobberies; + BAAssaults; + Ei index_nsai = Bo - BAHomicides; - BARobberies, - BAAssaults; + E; index_nsai = Bo+ (BA + BR) Homicides; + BRRobberies; + BAAssaults; + E; index_nsai = Bo-(BA + BR) Homicides; + BRRobberies; + BAAssaults; + E; index_nsai = Bo + By Homicides; + BRRobberies; - (BR + BH ) Assaults; + E; index_nsai = Bo + ByHomicides; + BRRobberies; + (BR-BH ) Assaults; + EiFstatistic: Formula 1.0 point possible (graded, results hidden} As above, we are testing the hypotheses: Ho iH+A+R=0 HI =5H+5A+3 #0. Let H be the sample size, 1" the number of restrictions, and SEE the sum of squared residuals. Let the subscript U denote the Unrestricted model, e.g. SSRU is the sum of squared residuals for the unrestricted model; and the subscript R denote the Restricted modell e.g. SSRR is the sum of squared residuals for the restricted model. Then the F-statistic for this test _ (33123 SSRU) fr F ' (5533/ (n (k+ 1)} where the parameters are F-statistic 1.5 points possible (graded, results hidden) Based on the given data set, find the values of SSRR, SSRy, and F. (Enter numerical answers accurate to 2 decimal places) SSRU = SSRR The F statistics F =Hypothesis Test Concept Check 1 point possible (graded, results hidden} In which of the following scenario will you reject the hypothesis that crime has no effect on housing index with 95% cont'dence? Choose the best 3 descriptions below. {The answers are not in precise terms] [: When SSRR SSRU is large When SSRR SSRU is small When the fit of the unrestricted model is significantly better than the fit of the restricted model When the fit of the unrestricted model is not significantly better than the fit of the restricted model When F is large (Le. larger than the required critical value of the test llll When F is small ii.e. smaller than the required critical value of the test