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 Deviation

Which summary statistics were affected the most by the addition of this outlier?

How were they changed, and were you surprised by the results?

I encourage you to review the Week 2 descriptive statistics PDF at the bottom of the discussions.

This will give you a step-by-step example of how to calculate these values using Excel.

I DO NOT recommend doing this by hand.

Let Excel do the heavy lifting for you.

Once you have posted your initial discussion, you must reply to at least two other learner's posts.

Each post must be a different topic.

So, you will have your initial post from one topic, your first follow-up post from a different topic, and your second follow-up post from one of the other topics.

Of course, you are more than welcome to respond to more than two learners.

Year (Quantitative) Make (Qualitative) Model (Qualitative) Price (Quantitative) MPG (city) (Quantitative) MPG (highway) (Quantitative) 2021 Aston Martin V8 VantageRoadster $214,320 18 Miles 24 Miles 2020 Lamborghini Huracan EVO $294,840.00 13 Miles 18 Miles 2020 Ferrari 488 Pista Spider $699,950.00 15 Miles 19 Miles 2021 GMC Yukon Denali $81,825.00 14 Miles 19 Miles 2021 Cadillac Escalade Sport $99,015.00 14 Miles 19 Miles 2018 Mercedes-Benz GLE 43 AMG 4MATIC Coupe $67,777.00 17 Miles 22 Miles 2021 Lexus ES 250 $45,430.00 25 Miles 34 Miles 2018 Honda Accord $21,987.00 30 Miles 38 Miles 2020 Audi A8 L 3.0T $99,245.00 17 Miles 26 Miles 2021 Bentley Bentayga $205,999.00 15 Miles 24 Miles