Question
(InYourOwnWordsPlease) Using the data set that you identified in week 1, use Excel to find the following descriptive statistics for the price data. Descriptive statistics:
(InYourOwnWordsPlease)
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?
we save in based we wil be wing theme In a new tab sis will populateStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started