W2: Frequency distributions and graphs; Data description V 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. Next, add an 11th vehicle to the data set. Choose a "supercar" that costs at least $1 million. Recalculate the summary statistics to include this vehicle. Descriptive statistics: Mean Median Standard DeviationA B C D E F G H Vehicle type/class Year Make Model Price MPG city MPG highway- Color Y qualitative quantitative qualitative qualitative quantitative quantitative quantitative qualitative SUV 2022 GMC Terrain SLT $33,970 25 28 Medium ash gray SUV 2022 Mitsubishi Outlander Spo $26,990 24 30 Black SUV 2022 Chevrolet Equinox LT $28,512 26 31 Cherry Red Tintcoat SUV 2022 Chevrolet Blazer $33,595 22 29 Nitro Yellow Metallic SUV 2022 GMC Acadia SLT $41,567 19 27 Cayenne Red Tintcoat SUV 2022 Honda CRV $26,875 28 34 Platinum White Pearl SUV 2022 Hyundai Tucson $26,175 26 33 Phantom black o Truck 2022 Ford F150 XL $43,735 19 24 Animatter Blue Truck 2022 Chevrolet Silverado 1500 $40,890 19 22 Mosaic Blue Metallic Jeep 2022 Jeep Renegade Lati $28,966 23 29 Bikini Metallic WA B C D E F G H Vehicle type/class Year Make Model Price - MPG city MPG highway Color 2 qualitative quantitative qualitative qualitative quantitative quantitative quantitative qualitative 3 SUV 2022 GMC Terrain SLT $33,970 25 28 Medium ash gray SUV 2022 Mitsubishi Outlander Spo $26,990 24 30 Black 5 SUV 2022 Chevrolet Equinox LT $28,512 26 31 Cherry Red Tintcoat 6 SUV 2022 Chevrolet Blazer $33,595 22 29 Nitro Yellow Metallic 7 SUV 2022 GMC Acadia SLT $41,567 19 27 Cayenne Red Tintcoat 8 SUV 2022 Honda CRV $26,875 28 34 Platinum White Pearl SUV 2022 Hyundai Tucson $26,175 26 33 Phantom black Truck 2022 Ford F150 XL $43,735 19 24 Animatter Blue 11 Truck 2022 Chevrolet Silverado 1500 $40,890 19 22 Mosaic Blue Metallic Jeep 2022 Jeep Renegade Lati $28,966 23 29 Bikini Metallic 13 Supercar 2021 Ferrari SF90 Stradale $1,050,000 16 20 Rosso Dino