complete short statistics discussion apu

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 discussion forums. This will give you a step by step example on how to calculate these values using Excel. I DO NOT recommend doing this by hand. Let Excel do the heavy lifting for you.

Instructions: Your initial post should be at least 150 words

PREVIOUS DISCUSSION FROM WEEK 1:

STATISTICS

Vehicle Type

Year

Make

Model

Price

MPG (City)

MPG (highway)

Cylinders

SUV

2019

Ford

Escape

$24,105

23

30

4

SUV

2020

Chevrolet

Traverse

$29,800

18

27

4

SUV

2020

Subaru

Ascent

$31,995

21

27

4

SUV

2019

Toyota

4runner

$35,310

17

21

6

Car

2018

Ford

Focus

$17,950

30

40

4

Car

2020

Toyota

Prius

$24,200

58

53

4

Car

2019

Hyundai

Sonata

$22,650

28

37

4

Car

2019

Chevrolet

Impala

$28,020

22

29

6

Truck

2019

Ford

F-150

$28,155

22

30

6

Truck

2019

Chevrolet

Silverado

$28,300

20

23

6

Qualitative

Qualitative

Qualitative

Qualitative

Quantitive

Quantitive

Quantitive

Quantitive

The 2019 Escape is a compact crossover SUV that comes in S, SE, SEL, and Titanium trim levels. The SUV offers an upgraded engine, nicer wheels, a power-adjustable driver seat, and more available options.

The 2020 Traverse makes every drive worth the trip. This mid-size SUV is spacious enough to accommodate a big family yet doesn’t compromise on style.

The 2020 Subaru Ascent is available in base, Premium, Limited and Touring trim levels. All use a turbocharged 2.4-liter four-cylinder engine paired with a CVT automatic.

The 2019 Toyota 4Runner is a midsize SUV available in seven trim levels: SR5, SR5 Premium, TRD Off-Road, TRD Off-Road Premium, TRD Pro, Limited and Limited Nightshade.

The Focus serves as Ford’s entry in the compact car class; it’s available in sedan and hatchback body styles. Most models come with a 2.0-liter four-cylinder engine, but the SE sedan offers a turbocharged three-cylinder engine.

Toyota’s Prius has become the quintessential hybrid, but it’s given up ground to other hybrids over the years. The Toyota Prius is ranked #4 in Hybrid and Electric Cars by U.S. News & World Report.

The 2019 Hyundai Sonata Hybrid features a new design & advanced safety features like Blind Spot Detection. The 2020 Impala offers a standard 305HP V6 engine and a spacious, sophisticated interior.

The F150 XL offers a more efficient 3.3L TiVCT V6 and more potent 3.5L EcoBoost®. Plus added features like 10-speed automatic transmission. 2019 Chevrolet Silverado the strongest, most advanced Chevrolet Silverado ever. This truck offers multiple trim levels, a high-strength Durabed.

https://www.kbb.com/

https://cars.usnews.com/cars-trucks/rankings

https://cars.usnews.com/cars-trucks/best-cars-for-

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.