https://drive.google.com/drive/folders/1F1VdLvOeg0e5aS1CAKzXMIkiy-CnOx-P?usp=sharing

data if you click

question 3

purses/204852/quizzes/270779/take Data Set . USA cars datasets.csv. + (right-click the link and select to open in new window/tab) Starter Templates You may use either the R Markdown or Jupyter Notebook Starter Template: . R Markdown Starter Template: FALL2021 - Midterm Exam 1 Part 2 Template.Rmd L. (right- click the link and select to open in new window/tab) Jupyter Notebook Starter Template: FALL2021 - Midterm Exam 1 Part 2 Template.ipynb 4 (right-click the link and select to open in new window/tab) Ready? Let's begin. We wish you the best of luck! D Car Price Data Analysis - For this exam, you will be building a model to predict the price of second-hand cars (price). The "USA_cars_datasets.csv" data set consists of the following variables: price: price of the second-hand car brand: brand of the car year: year of the car title_status: clean vehicle or salvage insurance mileage: mileage driven of the car color: color of the car users: number of previous users of the car Read the data and answer the questions below. Assume a significance threshold of 0.05 for hypothesis tests unless stated otherwise. # Read the data set cars - read. csv( 'USA_cars_dataset . csv", header-TRUE) Set brand and title_status as categorical ans theands as factorcans thranch. USA_cars_datas....csvurses/204852/quizzes/270779/take D Question 2 - 4pts A) What can you conclude from the ANOVA table with respect to the test of equal means at a significance level of 0.05 (FAIL TO REJECT or REJECT the null hypothesis)? Explain your answer using the values from the ANOVA Table. B) Given your answer in part A, explain what this conclusion means in the context of the car data analysis problem. D Question 3 - 5.5pts Conduct a pairwise comparison of the mean price for the different brands using the Tukey method. Use a 90% confidence level for this comparison. A) According to the pairwise comparison, are the means of audi and acura plausibly equal? Explain how you came to your conclusion. B) Provide an interpretation of "diff" in the context of the price between audi and acura. (Note: provide this interpretation regardless of the means being statistically significantly different/equal) D Question 4 - 8.5pts Perform a residual analysis on the ANOVA model (anovamodel). State whether each of the three ANOVA model assumptions holds and why you came to the conclusion. A_cars_datas...csv