Using the data set that you identified in week 1, use Excel to find the following descriptive statistics for the price data.

Descriptive statistics:

Mean

Median

Standard Deviation

Use these summary statistics to make two conclusions or observations about the typical vehicle in the sample. One conclusion must relate to the measure of center (mean/median) and one to the variability (standard deviation) of the vehicles.

Vehicle Type SUV SUV SUV SUV SUV SUV SUV SUV SUV SUV Year 2015 2019 2019 2020 2020 2020 2020 2019 2019 2016 Make HONDA TOYOTA TOYOTA HONDA TOYOTA KIA MERCEDES BMW AUDI ACURA Model CR-V RAV4 RAV4 HYBRID CR-V RAV4 TELLURIDE GLE SUV X5 SUV Q8 MDX Price MPG COMBINED $ 14,378.00 28 $ 20,686.00 27 $ 27,046.00 30 $ 26,170.00 30 $ 27,070.00 30 $ 33,060.00 23 $ 54,695.00 22 $ 60,055.00 22 $ 68,395.00 19 $ 23,867.00 22 Drive Type Mileage AWD AWD AWD AWD AWD 4WD AWD AWD AWD AWD SAFETETY 45000 4 STARS 9,023 4.5 STAR 5,232 4.9 STARS 4,320 4.8 STARS 7,082 4.8 STARS 21 4.8 STARS 27 4.8 STARS 16,023 4.8 STARS 15,012 4.8 STARS 39,050 4.8 STARS YEAR Quantitative MAKE Qualitative MODEL Qualitative PRICE Quantitative MILES PG COMBINED DRIVE TYPE Quantitative Qualitative MILEAGE Quantitative SAFETY Quantitative