\f86300 22200 19860 40500 19250 30000 81678 15500 160125 5950 a. Develop a scatter plot. Describe the relationship between price and mileage. b. Use a simple regression model to predict the price of used BMW. Is there a significant relationship between price and mileage? Use significant level 0.02. c. Develop a quadratic model and determine whether this model is statistically significant. Use significant level 0.05. d. Determine the best model to use for predicting the price of a used BMW. Use significant level 0.02. e. Using the best model to predict the average price of a used BMW with 15,000 miles.A completed Excel printout result- not just data Clear answers for each part: a-e You are expected to provide a clear and readable answer. Necessary and appropriate assumptions (when applicable) * Formulas and graphs # Relevant conclusion(s) In an effort to predict the price of a used BMW series 5 that will be sold to a car dealer at a local auction, a sample of 20 cars that were sold at auction recently was collected. The data is shown below provides the price (dollars), odometer (mileage) of BMW series 5. Odometer Price- mileage dollars 57588 17600 14769 31200 19645 29750 29574 35500 11587 13750 19477 45750 53018 22000 116224 6800 124042 6400 102286 3700 152851 4000 143708 6100 97528 14500 40809 28250 83809 8240