I would like to get answers for this MGSC 291 class's Case 3 that requires the use of R. Case 3 explanation: https://canvas.instructure.com/courses/1687814/files/80478791/download?wrap=1 Data Set: https://canvas.instructure.com/courses/1687814/files/80478779/download?wrap=1 Qn1: How many metropolitan areas (rows) are included in the total data file?(Whole number) Qn2: How many metropolitan areas (rows) are part of the Northeast region?(Whole number) Qn3: For metro areas in the Southeast, what was the average 'median home price' for those cities in 2004?(XXX.X) Note: If your column has missing values, NA's, you need to tell R to skip them. Add na.rm=TRUE to your mean statement. For example, mean(data,na.rm=TRUE) wold take the mean of the dataset "data" and skip over the NA values. Qn4: If you wanted to test whether mean home prices are different between two regions (e.g., between Southeast and Central) in 2004, what test would you use?Assume you want to be conservative in your analysis and don't know anything about the prices in a given market. Group of answer choices >t test for one mean, mu >t test for 2 independent samples, assuming equal variances >t test for 2 independent samples, not assuming equal variances >t test for mean difference using dependent samples Qn5: When carrying out a t-test for a difference in means for two regions (e.g., between Southeast and Central), which value in the R output allows us to conclude whether the means are different? Group of answer choices >degrees of freedom >sample mean difference >P-value >hypothesized mean difference Qn6: Now, perform that test. Is there a statistically significant difference (at the0.05 level) between mean home price in the Southeast and the Northeast regions during 2004? What p-value do you get for the two-sample (unequal variances) test?(X.XXX) Qn7: Looking specifically at two states, did home prices for metro areas in South Carolina and Texas differ from one another on average in 2007 (at a = 0.05)?What p-value do you get for the two-sample (unequal variances) test?(X.XXX) Qn8: Now, if you wanted to run one test and determine whether mean home prices are different between any of the four regions in 2011, what test would you use? Group of answer choices t-tests for the 6 pairwise comparisons One-way ANOVA (one factor ANOVA) Two-way ANOVA (two factor ANOVA Qn9: Conduct a one-way ANOVA to see if there are significant differences in mean home price across regions in 2011. What is the P-value? (X.XXX) Qn10: Paste your R code for answering question 1, 2, 3, 6, 7, and 9