MGMT 650 UMD Standard Deviation Worksheet

MGMT 650 Spring 2023Week 2 Homework Questions
(Last updated 10/19/2022)
1/27/2023
You are a statistician contracted to sample and analyze weights of the 5 lb bags of coffee. You collect the following data:
5,15
4,83
4,22
5,51
4,29
4,72
5,26
4,99
5,03
4,92
3,85
6,05
5,32
4,93
4,80
5,24
5,10
4,77
5,63
5,10
5,10
4,97
3,87
4,28
4,76
5,01
5,30
4,32
4,80
4,44
5,03
5,84
5,05
5,04
4,60
4,29
5,45
5,36
5,44
5,01
4,71
4,63
5,23
4,54
5,70
5,61
5,98
3,87
5,48
4,41
5,73
5,57
5,30
5,95
5,41
5,48
For all questions, write your answers in the yellow cells.
1)
Compute the following statistics using Excel functions so that Excel calculates for you:
Mean
Median
2)
First quartile using QUARTILE.EXC
Third quartile using QUARTILE.EXC
Interquartile range (IQR)
3)
Maximum
Minimum
Range
4)
Variance
Standard deviation
Coeficient of Variation (CV)
5)
For the standard deviation, when do you use STDEV.S and when do you use STDEV.P?
6)
Explain why the standard deviation is a better measure to use than the variance.
The coefficient of variation (CV) is a measure of relative variability equal to the ratio between the standard deviation
divided by the mean, and formatted to %. It is regularly used to compare risk (volatility) in investing, and is especially
useful in to compare data on different scales or with different units of measure. Consider weights of 10 oz, 13.4 oz, 15.1
oz with SD of 2.597 oz. The corresponding weights in pounds 0.625 lb, 0.838 lb, 0.944 lb have SD 0.162 lb. The SDs
are not equal, yet the sample and its variability are the same. How can we compare variabilities? The CV, unlike other
measures of variability, does not depend on the units of measure. The units are divided out in dividing the standard
deviation by the mean. For a “rule of thumb”, a CV of greater than 5% is considered significant. So, the CV is also used
to assess data with no prior history to compare to evaluate any trends.
When is the Coefficient of Variation (CV) especially useful?
1/27/2023
7)
As a contracted statistician, you have no prior experience with the company’s product.
The company has no prior process history and data with which to compare the sample to evaluate any trends.
The mode is not especially useful for this data, but explain why there is or is not
a concern with bag weight in terms of the other measures of central tendency.
8)
What statistic should you use to assess variability of the product?
Explain why there is or is not a concern with the variability of the product.
1/27/2023
coffee. You collect the following data:
4,58
4,87
4,98
4,54
5,12
5,60
4,80
4,46
5,64
4,60
5,55
5,13
4,39
4,69
4,99
4,59
between the standard deviation
ty) in investing, and is especially
sider weights of 10 oz, 13.4 oz, 15.1
44 lb have SD 0.162 lb. The SDs
variabilities? The CV, unlike other
ded out in dividing the standard
significant. So, the CV is also used
5,05
4,74
4,91
4,76
4,26
4,79
5,11
4,57
1/27/2023
See the tab “Used Car Data”. This list represents a consolidated list from 2021 of used cars for sale o
The data set contains 421 used cars from the year 1995 or newer that sold for $1000 or more. The l
price, condition, manufacturer and other relevant categories a buyer might find of interest.
Note: For the tables in question 9 and 11, you can either create them in a new tab, or place it at the
See the tab “Sample Data for Pivot Table” for an example of creating one-way and two-way tables
9. Create a pivot table showing the frequency and percent frequency of the manufacturer from the Used Car Data.
10. What is the most common used car manufacturer? What is the least common used car manufacturer?
11. Create a two way pivot table showing Year vs. Condition using the Used Car Data.
12. In one paragraph, describe any relationship the data shows between year and condition, and explain why.
021 of used cars for sale on Craigs List in the Athens, GA area.
for $1000 or more. The list also includes columns like
find of interest.
new tab, or place it at the bottom of this tab
way and two-way tables
m the Used Car Data.
manufacturer?
and explain why.
price
year
32590
7500
32990
16990
12995
10995
3995
28990
4900
7995
13995
8995
20649
25990
31990
31990
25990
2200
24990
6600
34590
25990
15590
5000
32590
33990
29990
34590
2600
21000
5000
35590
32990
3000
32990
29990
4500
21500
8999
30990
36990
27990
16590
manufacturer
2015 mercedes-benz
2006 mazda
2019 volkswagen
2016 kia
2011 ford
2011 rover
1997 chevrolet
2017 bmw
2016 ford
2007 infiniti
2013 bmw
2008 mercedes-benz
2012 chevrolet
2013 toyota
2017 jeep
2017 bmw
2014 chevrolet
1997 ford
2016 mazda
2016 nissan
2015 ford
2014 gmc
2016 chevrolet
1997 gmc
2016 subaru
2018 ford
2016 chevrolet
2017 toyota
2000 gmc
2016 subaru
2001 lexus
2010 chevrolet
2013 tesla
1995 ford
2017 ram
2019 chevrolet
2011 ford
2012 gmc
2011 ford
2019 ford
2015 chevrolet
2020 ford
2015 volkswagen
model
condition cylinders
gla-class gla 45
good
miata
excellent
4 cylinders
atlas se 4motion
good
6 cylinders
forte koup exgood
coupe 2d
explorer
excellent
lr2
excellent
lumina
excellent
4 series 440i good
xdrive gran
focus se
good
4 cylinders
m45
excellent
3 series
excellent
e-class
excellent
silverado 1500
excellent
tundra crewmax
goodpickup 4d8 cylinders
wrangler sport
good
s utility 2d6 cylinders
3 series 340i good
sedan 4d
silverado 1500
good
regular 8 cylinders
ranger superfair
cab
6 cylinders
mx-5 miata grand
good touring
versa
like new
4 cylinders
mustang gt premium
good
8 cylinders
sierra 1500 regular
good cab 6 cylinders
cruze limitedgood
1lt
savana 3500 fair
8 cylinders
wrx sti sedangood
4d
f150 super cab
good
xl pickup 4d
6 cylinders
colorado extended
good cab 6 cylinders
tacoma access
good
cab trd 6 cylinders
jimmy
good
6 cylinders
outback 3.6r excellent
limited
6 cylinders
ls430
good
8 cylinders
corvette convertible
good
8 cylinders
model s signature
good
f150 xl
good
6 cylinders
1500 crew cab
good
big horn 6 cylinders
camaro lt coupe
good2d
6 cylinders
focus se
excellent
6 cylinders
sierra 1500 excellent
8 cylinders
ranger xlt excellent
4 cylinders
ranger supercrew
good xl pickup
tahoe lt sportgood
utility
8 cylinders
ranger supercab
goodxl pickup
beetle 1.8t fleet
good
fuel
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
other
other
gas
gas
gas
gas
gas
gas
electric
gas
other
gas
gas
gas
gas
other
other
gas
gas
12800
6995
9495
8995
11500
5495
4400
38990
35990
6800
17990
39990
14700
42995
24590
6300
27990
29590
31590
7500
1500
9495
10995
6995
5995
6000
39590
37990
4495
11495
34990
38990
2850
6500
7300
28590
26000
29990
32990
17990
2000
8500
6500
4200
1995 toyota
2001 chevrolet
2000 chevrolet
2010 mazda
2009 bmw
2003 infiniti
2005 ford
2019 tesla
2020 dodge
2007 toyota
2015 volkswagen
2019 nissan
2015 honda
2017 ford
2013 gmc
2009 chevrolet
2012 toyota
2015 chevrolet
2013 ford
2007 toyota
2009 mercury
2012 mazda
2011 nissan
2005 toyota
2003 toyota
2007 bmw
2018 toyota
2016 toyota
1999 ford
2016 kia
2020 jeep
2017 jeep
1996 jeep
2008 ford
2000 ford
2017 chevrolet
2016 ram
2019 mazda
2018 ford
2012 volkswagen
2002 ford
1995 lexus
2004 mercedes-benz
2002 dodge
pickup
excellent
6 cylinders
silverado 1500
good
6 cylinders
silverado 1500
good
ls
8 cylinders
cx-9
excellent
3 series
excellent
g35
excellent
focus
good
4 cylinders
model 3 standard
good range
challenger r/tgood
coupe 2d 8 cylinders
rav4
good
4 cylinders
golf tdi sel good
370z nismo coupe
good 2d
6 cylinders
cr-v ex-l
excellent
4 cylinders
f150 xlt
excellent
6 cylinders
sierra 1500 extended
good
cab 8sltcylinders
express 3500good
8 cylinders
tacoma double
good
cab pickup6 cylinders
silverado 1500
good
double
f150 supercrew
good
cab fx4
tacoma
good
4 cylinders
grand marquis
fair
8 cylinders
cx-9
excellent
armada
excellent
sienna
excellent
corolla
excellent
z4 convertible
excellent
6 cylinders
4runner limited
good
sport
6 cylinders
tundra double
good
cab sr
8 cylinders
expedition excellent
soul
excellent
wrangler sport
good
s utility 2d
wrangler unlimited
good rubicon
6 cylinders
cherokee good
6 cylinders
f-150
good
ranger xlt good
6 cylinders
silverado 1500
good
regular 6 cylinders
1500 4×4 excellent
8 cylinders
mx-5 miata grand
good touring
mustang gt coupe
good 2d
8 cylinders
touareg tdi sport
goodsuv
6 cylinders
ranger
good
4 cylinders
sc400
excellent
8 cylinders
benz-e500 5.0l
excellent
v8
8 cylinders
1500 good
8 cylinders
gas
gas
gas
gas
gas
gas
gas
electric
gas
gas
diesel
gas
gas
gas
other
gas
gas
other
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
8495
10995
7995
4495
10995
13995
22590
15990
29590
25990
21500
13995
8995
11995
8995
8995
27990
39590
32990
38590
4900
6000
25990
11995
8495
12995
9495
10995
9495
7995
7995
10495
6495
28590
15990
30590
13500
9495
10995
3995
7495
5995
7995
14995
2005 infiniti
2011 mercedes-benz
2011 kia
2006 honda
2008 mercedes-benz
2010 chevrolet
2013 ford
2010 ford
2017 ford
2019 ram
2012 rover
2006 nissan
2011 bmw
2008 ford
2006 infiniti
2005 lexus
2014 toyota
2017 chevrolet
2011 bmw
2011 chevrolet
2007 honda
2007 mazda
2015 buick
2007 chevrolet
2008 honda
2012 ford
2008 mazda
2008 ford
2012 mazda
2006 mitsubishi
2007 infiniti
2010 cadillac
2006 toyota
2018 jaguar
2014 acura
2017 jaguar
2008 toyota
2010 bmw
2011 bmw
1996 ford
2009 jeep
2004 honda
2009 mercedes-benz
2010 ford
g35
excellent
r-class
excellent
sorento
excellent
odyssey
excellent
c-class
excellent
camaro
excellent
f150 super cab
good
xl pickup 4d
6 cylinders
ranger supergood
cab xlt pickup
6 cylinders
expedition xltgood
sport
6 cylinders
1500 classic regular
good cab 8 cylinders
like new
8 cylinders
titan
excellent
3 series
excellent
expedition excellent
g35
excellent
ls 430
excellent
tacoma access
good
cab pickup
camaro ss coupe
good2d
8 cylinders
z4 sdrive35isgood
roadster 2d
corvette grand
good
sport
8 cylinders
cr-v
good
4 cylinders
cx-9
excellent
6 cylinders
enclave premium
good sport 6 cylinders
avalanche excellent
accord
excellent
explorer
excellent
cx-9
excellent
expedition excellent
cx-9
excellent
eclipse
excellent
fx35
excellent
srx
excellent
sienna
excellent
xe 25t premium
good
sedan 4d
ilx 2.0l sedangood
4d
xe 35t r-sportgood
sedan 4d
fj cruiser
good
6 cylinders
3 series
excellent
3 series
excellent
explorer
excellent
liberty
excellent
odyssey
excellent
e-class
excellent
f-150
excellent
gas
gas
gas
gas
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
gas
gas
gas
gas
gas
gas
diesel
gas
39990
16590
1200
28590
37990
25995
14995
24995
13995
14995
11995
6995
12995
3500
33990
12995
7995
13995
3995
8995
25000
21990
29590
24990
13499
12499
3200
5995
5495
25990
30990
14500
22950
25590
16590
31990
35590
1500
18500
26590
27990
26990
47990
4000
2019 audi
2016 hyundai
2006 cadillac
2018 lexus
2020 cadillac
2011 ford
2011 jeep
2013 jeep
2013 ford
2015 nissan
2017 jeep
2008 mercedes-benz
2012 ford
2011 nissan
2019 acura
2010 mercedes-benz
2007 infiniti
2013 bmw
2001 lincoln
2008 mercedes-benz
2016 mercedes-benz
2020 mitsubishi
2019 alfa-romeo
2015 acura
2011 lexus
2007 lexus
2000 honda
2004 ford
2003 infiniti
2018 lincoln
2019 lincoln
2015 honda
2019 honda
2017 ford
2013 honda
2020 mazda
2011 dodge
2006 honda
2015 toyota
2017 bmw
2016 bmw
2018 bmw
2020 bmw
2002 volkswagen
a6 45 tfsi premium
good sedan 4d
sonata eco sedan
good 4d
cts sedan fair
6 cylinders
nx 300 sport good
utility 4d
xt4 sport suvgood
4d
f250 diesel excellent
8 cylinders
wrangler unlimited
excellent
sport 6 cylinders
wrangler unlimited
excellent
sahara6 cylinders
expedition elexcellent
limited
8 cylinders
rogue
excellent
4 cylinders
patriot
excellent
6 cylinders
clk350
excellent
6 cylinders
expedition excellent
8 cylinders
altima
good
rdx sh-awd sport
goodutility
e-class
excellent
m45
excellent
3 series
excellent
ls
excellent
e-class
excellent
gle 350
like new
6 cylinders
outlander se good
sport
romeo stelviogood
ti sport
mdx sh-awd sport
good utility
rx350
good
6 cylinders
ls 460
good
8 cylinders
odyssey
excellent
4 cylinders
explorer
excellent
g35
excellent
mkz premieregood
hybrid
mkz hybrid reserve
good ii
crosstour exlexcellent
passport
like new
4 cylinders
mustang v6 convertible
good
2d6 cylinders
civic si coupegood
2d
mx-5 miata grand
good touring
challenger srt8
good
coupe 2d 8 cylinders
odyssey
good
6 cylinders
tacoma
excellent
4 cylinders
3 series 330i good
xdrive sedan
3 series 340i good
sedan 4d
3 series 330i good
xdrive sedan
3 series m340i
good
sedan 4d
jetta tdi
good
gas
gas
gas
gas
gas
diesel
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
other
other
gas
gas
gas
gas
gas
hybrid
gas
gas
gas
gas
other
gas
gas
gas
gas
other
gas
gas
other
diesel
1000
89000
40590
46990
33990
25990
10995
6495
4495
11995
5495
8495
9495
6995
5995
2500
9200
1000
37990
41990
52990
28990
2000
4995
12495
11495
6495
7995
24950
6500
28990
28590
25990
19590
25999
10995
7995
14995
9495
9495
9995
4495
10995
8995
2003 chrysler
2021 chevrolet
2019 ford
2014 chevrolet
2016 ford
2017 ford
2011 nissan
2006 toyota
2002 mazda
2007 chevrolet
2004 nissan
2008 gmc
2012 mazda
2005 toyota
2003 toyota
2008 kia
2005 toyota
2003 chrysler
2015 ford
2012 bmw
2018 bmw
2016 ford
1998 mercedes-benz
1999 ford
2009 chevrolet
2016 kia
2005 mercury
2009 bmw
1996 ford
2000 chevrolet
2019 acura
2017 buick
2017 jaguar
2017 acura
2014 ford
2011 mercedes-benz
2011 kia
2010 chevrolet
2009 bmw
2005 infiniti
2006 toyota
2006 honda
2008 mercedes-benz
2005 lexus
town & country
excellent
6 cylinders
corvette
new
8 cylinders
f250 super duty
good
regular cab
8 cylinders
corvette stingray
good
8 cylinders
f250 super duty
good
cab xl 8 cylinders
expedition xltgood
sport
armada
excellent
sienna
excellent
protege
excellent
silverado 1500
excellent
xterra
excellent
yukon xl
excellent
cx-9
excellent
sienna
excellent
corolla
excellent
sportage
good
4 cylinders
tundra sr5 excellent
8 cylinders
town & country
excellent
6 cylinders
f150 supercrew
good
cab king
m3 coupe 2dgood
8 cylinders
m3 sedan 4dgood
f150 supercrew
good
cab xl 8 cylinders
c-class
good
4 cylinders
expedition excellent
tahoe
excellent
soul
excellent
mariner
excellent
3 series
excellent
f350
good
8 cylinders
flatbed
good
8 cylinders
ilx technologygood
and a-spec
enclave leather
good
sport
xe 20d sedangood
4d
ilx sedan 4d good
f-150
excellent
6 cylinders
r-class
excellent
sorento
excellent
camaro
excellent
3 series
excellent
g35
excellent
tundra
excellent
odyssey
excellent
c-class
excellent
ls 430
excellent
gas
gas
other
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
gas
other
gas
gas
gas
gas
gas
gas
gas
diesel
gas
gas
other
diesel
diesel
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
32590
17990
24990
31590
3500
8995
11995
4495
9995
24590
11995
8495
12995
9495
9995
19990
27990
36590
1200
22800
22590
17990
13995
34990
40990
4700
20590
33590
26000
3995
14995
7495
9995
7900
9495
10995
5995
7995
11995
11995
12995
10995
3995
3995
2017 audi
2018 hyundai
2016 lexus
2019 cadillac
2004 mazda
2011 bmw
2008 ford
2003 chevrolet
2006 infiniti
2017 acura
2007 chevrolet
2008 honda
2012 ford
2008 mazda
2012 honda
2018 mitsubishi
2018 alfa-romeo
2018 acura
2006 honda
2008 toyota
2017 lincoln
2013 lincoln
2002 mercedes-benz
2018 ford
2014 chevrolet
2011 nissan
2020 toyota
2017 ford
2013 ford
1996 ford
2010 ford
2009 jeep
2011 cadillac
2002 toyota
2010 bmw
2011 bmw
2004 honda
2009 mercedes-benz
2008 chevrolet
2007 gmc
2011 ford
2011 rover
1997 chevrolet
2001 lincoln
a6 3.0t prestige
good
sedan 4d
sonata se sedan
good
4d
nx 200t sportgood
utility 4d
xt4 sport suvgood
4d
rx8
good
3 series
excellent
expedition excellent
malibu
excellent
g35
excellent
rdx sport utility
good
4d
6 cylinders
avalanche excellent
accord
excellent
explorer
excellent
cx-9
excellent
odyssey
excellent
outlander es good
sport
romeo stelviogood
ti sport
mdx advancegood
and
odyssey
good
fj cruiser
excellent
6 cylinders
mkz premieregood
sedan 4d
mkz sedan 4dgood
6 cylinders
benz cl 500 amg
excellent
8 cylinders
mustang gt premium
good
8 cylinders
silverado 2500
good
hd crew 8 cylinders
altima
excellent
4 cylinders
corolla le sedan
good
4d
mustang gt coupe
good 2d
8 cylinders
f-150
excellent
6 cylinders
explorer
excellent
f-150
excellent
liberty
excellent
cts
excellent
4runner
good
6 cylinders
3 series
excellent
3 series
excellent
odyssey
excellent
e-class
excellent
colorado
excellent
yukon
excellent
explorer
excellent
lr2
excellent
lumina
excellent
ls
excellent
other
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
gas
other
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
diesel
gas
gas
gas
gas
gas
gas
6495
27590
27990
26590
24590
23500
8995
5995
5495
12995
7995
13995
30990
30990
52990
5999
7500
39990
8495
10995
11500
7995
9995
43990
38590
33990
5500
16995
23995
13995
12995
15995
5900
43590
23590
43990
8105
14990
31800
6500
22990
10495
12995
5495
2010 mazda
2018 bmw
2018 bmw
2018 bmw
2018 bmw
2013 chevrolet
2008 mercedes-benz
2004 ford
2003 infiniti
2010 mercedes-benz
2007 infiniti
2013 bmw
2018 infiniti
2019 lincoln
2020 jaguar
2008 toyota
2013 mazda
2018 ford
2010 mazda
2003 ford
2009 bmw
2004 infiniti
2011 honda
2015 bmw
2019 ford
2011 bmw
2006 toyota
2012 jeep
2017 jeep
2015 chevrolet
2016 jeep
2013 chevrolet
2005 chevrolet
2016 audi
2020 acura
2020 buick
2012 volvo
2017 bmw
2016 lexus
2011 toyota
2020 hyundai
2007 dodge
2004 chevrolet
2004 nissan
tribute i
good
4 cylinders
3 series 330i good
xdrive sedan
3 series 330i good
xdrive sedan
3 series 330i good
xdrive sedan
3 series 330i good
xdrive sedan
avalanche ltzexcellent
8 cylinders
e-class
excellent
explorer
excellent
g35
excellent
e-class
excellent
m45
excellent
3 series
excellent
qx60 3.5 sport
good
utility
6 cylinders
continental select
good sedan 6 cylinders
e-pace p300 good
r-dynamic se
sienna
good
6 cylinders
6 isport
like new
4 cylinders
f150 supercrew
good
cab xl 8 cylinders
cx-9
excellent
excursion excellent
3 series
excellent
g35
excellent
odyssey
excellent
m3 sedan 4dgood
f150 supercrew
good
cab xlt
m3 coupe 2dgood
8 cylinders
sienna le
good
wrangler sport
excellent
6 cylinders
cherokee trailhawk
excellent
6 cylinders
traverse
excellent
6 cylinders
compass
excellent
4 cylinders
tahoe lt
excellent
8 cylinders
colorado
excellent
5 cylinders
s7 sedan 4d good
8 cylinders
ilx sedan 4d good
enclave premium
good sport
s60 t5
good
i3
good
rx 450h awd like new
6 cylinders
camry
excellent
6 cylinders
sonata se sedan
good
4d
dakota
excellent
silverado 1500
excellent
xterra
excellent
gas
other
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
gas
gas
gas
gas
gas
other
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
other
other
gas
electric
hybrid
gas
gas
gas
gas
gas
35990
30590
41590
38990
37590
8495
10995
9995
11995
6995
19590
35990
4000
28990
37990
27990
30990
9000
35990
34590
25990
34990
33590
29990
37990
36590
6200
32990
20990
35990
16590
3500
31590
39990
17990
23590
25990
36590
28590
28590
4200
30990
22990
35990
2020 cadillac
2019 lexus
2020 audi
2020 acura
2019 acura
2008 gmc
2011 nissan
2005 chevrolet
2009 chevrolet
2005 toyota
2017 mitsubishi
2018 alfa-romeo
2011 kia
2017 bmw
2016 chevrolet
2014 toyota
2019 mazda
2019 nissan
2018 ford
2015 ford
2014 gmc
2010 chevrolet
2019 ford
2016 chevrolet
2016 toyota
2019 tesla
2003 toyota
2013 tesla
2011 jeep
2020 dodge
2015 volkswagen
2002 gmc
2015 toyota
2019 nissan
2015 volkswagen
2012 ford
2019 ram
2018 jeep
2010 chevrolet
2017 chevrolet
2003 gmc
2020 mazda
2012 toyota
2015 ford
xt4 sport suvgood
4d
nx 300 sport good
utility 4d
a6 45 tfsi premium
good plus
rdx advance pkg
goodsport
mdx advancegood
pkg sport
yukon xl
excellent
armada
excellent
silverado 1500
excellent
silverado 1500
excellent
sienna
excellent
outlander se good
sport
romeo stelviogood
ti sport
sorento ex good
4 cylinders
4 series 440i good
xdrive gran
camaro ss coupe
good2d
8 cylinders
tacoma access
good
cab pickup
mx-5 miata grand
good touring
versa
like new
4 cylinders
f150 super cab
good
xlt pickup 6 cylinders
mustang gt premium
good
8 cylinders
sierra 1500 regular
good cab 6 cylinders
corvette coupe
good
2d
8 cylinders
ranger supercrew
good xl pickup
colorado extended
good cab 6 cylinders
tundra double
good
cab sr
8 cylinders
model 3 standard
good range
tacoma
good
4 cylinders
model s signature
good
wrangler sport
good
suv 2d
6 cylinders
challenger r/tgood
coupe 2d 8 cylinders
beetle 1.8t fleet
good
yukon xl
good
tacoma double
good
cab
6 cylinders
370z nismo coupe
good 2d
6 cylinders
golf tdi sel good
f150 supercrew
good
cab xlt 8 cylinders
1500 classic regular
good cab 8 cylinders
wrangler unlimited
good all new6 cylinders
camaro ss coupe
good2d
8 cylinders
silverado 1500
good
regular 6 cylinders
envoy 4×4 good
6 cylinders
mx-5 miata club
good
tacoma access
good
cab pickup
mustang gt premium
good coupe
8 cylinders
2d
gas
other
gas
gas
other
gas
gas
gas
gas
gas
other
gas
gas
gas
gas
other
gas
gas
gas
gas
gas
gas
gas
gas
gas
electric
gas
electric
gas
gas
gas
gas
gas
gas
diesel
gas
gas
diesel
gas
gas
gas
gas
gas
gas
17990
15990
27590
29590
19590
32990
38590
34990
31590
29590
36590
37590
33990
30990
25990
14000
30590
7000
23590
21590
4250
25590
40590
21590
7000
11000
5500
47990
27990
25990
52590
25990
33990
42990
38990
32590
36590
1500
42990
45590
21000
43990
42590
34990
2012 volkswagen
2010 ford
2019 jeep
2017 ford
2013 bmw
2011 bmw
2011 chevrolet
2018 bmw
2018 acura
2018 acura
2020 buick
2020 buick
2020 buick
2019 lincoln
2018 lincoln
2013 ram
2019 alfa-romeo
2010 chrysler
2017 volvo
2017 volvo
2007 honda
2017 ford
2019 ford
2011 mazda
2015 hyundai
2015 honda
2019 nissan
2020 bmw
2016 bmw
2016 bmw
2015 chevrolet
2017 ford
2016 ford
2020 chevrolet
2018 chevrolet
2018 jeep
2018 bmw
2008 nissan
2020 acura
2020 acura
2016 ford
2020 buick
2020 buick
2020 buick
touareg tdi sport
goodsuv
6 cylinders
ranger supergood
cab xlt pickup
6 cylinders
cherokee latitude
good plus 6 cylinders
expedition xltgood
sport
6 cylinders
1 series 135i good
coupe 2d
z4 sdrive35isgood
roadster 2d
corvette grand
good
sport
8 cylinders
4 series 430i good
convertible 2d
mdx sport utility
good4d
mdx sport utility
good4d
6 cylinders
enclave essence
goodsport 6 cylinders
enclave essence
goodsport 6 cylinders
enclave essence
goodsport 6 cylinders
mkz hybrid reserve
good ii
mkz premieregood
hybrid
1500 4×4 good
8 cylinders
romeo stelviogood
sport utility
town & country
excellent
6 cylinders
s60 t5 inscription
good
s60 t5 dynamic
good
sedan 4d
civic
good
4 cylinders
mustang v6 convertible
good
2d6 cylinders
f250 super duty
good
regular cab
8 cylinders
mx-5 miata grand
good touring
veloster
excellent
4 cylinders
accord
like new
4 cylinders
versa
excellent
4 cylinders
3 series m340i
good
sedan 4d
3 series 340i good
sedan 4d
3 series 340i good
sedan 4d
corvette stingray
good
8 cylinders
expedition xltgood
sport
f250 super duty
good
cab xl 8 cylinders
camaro ss coupe
good2d
camaro ss coupe
good2d
8 cylinders
wrangler unlimited
good willys
4 series 430i good
convertible 2d
rogue
fair
4 cylinders
mdx technology
good
pkg sport
mdx sh-awd w/advance
good
pkg
6 cylinders
f150 xlt
like new
6 cylinders
enclave avenir
good
sport
6 cylinders
enclave avenir
good
sport
enclave essence
goodsport 6 cylinders
gas
gas
gas
gas
gas
other
gas
gas
other
gas
gas
gas
gas
gas
hybrid
gas
gas
gas
other
gas
gas
gas
other
gas
gas
gas
gas
other
gas
gas
gas
other
gas
other
gas
other
gas
gas
other
gas
gas
gas
other
gas
16590
29990
37590
18990
35990
40990
35990
33590
27590
24990
21590
28990
52990
41590
23590
33990
26990
37590
20590
5000
36990
31990
42590
31590
26590
38990
2013 lincoln
2018 alfa-romeo
2018 acura
2015 volvo
2020 volvo
2014 chevrolet
2018 ford
2017 ford
2018 bmw
2018 bmw
2013 bmw
2018 infiniti
2020 jaguar
2020 audi
2011 chevrolet
2018 jeep
2020 chevrolet
2019 acura
2015 bmw
2010 honda
2020 buick
2019 buick
2020 buick
2018 alfa-romeo
2018 lincoln
2017 acura
mkz sedan 4dgood
romeo stelviogood
ti sport
mdx sport hybrid
goodsh-awd 6 cylinders
s60 t5 premier
good
sedan 4d
s60 t6 inscription
goodsedan
silverado 2500
good
hd crew 8 cylinders
mustang gt coupe
good 2d
8 cylinders
mustang gt coupe
good 2d
8 cylinders
3 series 330i good
xdrive sedan
3 series 330i good
xdrive sedan
3 series 335i good
xdrive sedan
qx60 3.5 sport
good
utility
6 cylinders
e-pace p300 good
r-dynamic se
a6 45 tfsi premium
good plus
camaro ss coupe
good2d
8 cylinders
wrangler unlimited
good sport s
camaro lt coupe
good2d
6 cylinders
mdx advancegood
pkg sport
4 series 428i good
gran coupe
cr-v
good
enclave essence
goodsport 6 cylinders
enclave essence
goodsport 6 cylinders
enclave premium
good sport 6 cylinders
romeo stelviogood
ti sport
mkz reserve sedan
good 4d
mdx sport hybrid
goodsh-awd
gas
other
hybrid
other
other
gas
gas
gas
other
gas
gas
gas
gas
gas
gas
other
gas
other
gas
gas
gas
gas
gas
other
gas
other
odometer
title_status transmissiondrive
34811 clean
other
100700 clean
manual
rwd
3896 clean
other
17631 clean
other
fwd
166267 clean
automatic fwd
114575 clean
automatic 4wd
0 clean
automatic fwd
49355 clean
automatic
125100 clean
automatic fwd
214740 clean
automatic rwd
135848 clean
automatic rwd
112214 clean
automatic rwd
118600 clean
automatic 4wd
98879 clean
other
891 clean
other
4wd
19366 clean
automatic rwd
82140 clean
automatic 4wd
165000 salvage
manual
rwd
6218 clean
other
rwd
110500 clean
automatic fwd
30970 clean
other
rwd
15575 clean
other
7076 clean
automatic fwd
177000 clean
automatic rwd
21195 clean
other
13670 clean
other
17302 clean
other
4wd
20097 clean
other
4wd
138000 clean
automatic 4wd
87400 clean
automatic 4wd
267000 clean
automatic rwd
31879 clean
other
rwd
62588 clean
other
rwd
211000 clean
manual
rwd
10193 clean
other
4wd
6727 clean
other
rwd
130000 clean
automatic rwd
116500 clean
automatic 4wd
120000 clean
manual
rwd
1834 clean
other
51677 clean
other
10688 clean
other
39649 clean
other
fwd
size
compact
full-size
mid-size
mid-size
full-size
full-size
full-size
mid-size
mid-size
type
paint_color
other
black
convertible blue
other
silver
coupe
SUV
purple
SUV
grey
sedan
coupe
sedan
sedan
sedan
pickup
pickup
other
sedan
pickup
truck
other
sedan
other
pickup
sedan
van
sedan
pickup
pickup
pickup
SUV
sedan
other
sedan
truck
pickup
coupe
sedan
truck
truck
pickup
other
pickup
hatchback
black
white
silver
silver
white
white
red
black
red
blue
white
brown
blue
white
white
black
red
silver
green
silver
red
white
white
red
silver
white
red
black
black
white
black
212000 clean
200920 clean
167393 clean
183761 clean
43280 clean
203067 clean
140000 rebuilt
7609 clean
1548 clean
186000 clean
51482 clean
8373 clean
70672 salvage
41500 clean
80318 clean
194000 clean
67245 clean
43874 clean
68089 clean
270080 clean
160000 clean
183954 clean
172210 clean
180821 clean
188596 clean
183000 clean
34199 clean
22870 clean
272412 clean
114843 clean
131 clean
20676 clean
209356 clean
161000 clean
120000 clean
102 clean
67000 clean
5247 clean
27726 clean
93185 clean
188000 clean
98015 clean
116000 clean
226000 clean
manual
automatic
automatic
automatic
automatic
automatic
automatic
other
other
automatic
other
other
automatic
automatic
other
automatic
other
other
other
manual
automatic
automatic
automatic
automatic
automatic
automatic
other
other
automatic
automatic
other
other
automatic
automatic
automatic
other
automatic
other
other
other
manual
automatic
automatic
automatic
4wd
rwd
rwd
fwd
rwd
rwd
fwd
rwd
rwd
fwd
fwd
rwd
4wd
4wd
compact
full-size
full-size
pickup
pickup
pickup
SUV
sedan
sedan
sub-compactsedan
sedan
coupe
compact
SUV
sedan
coupe
compact
SUV
full-size
truck
pickup
4wd
4wd
rwd
fwd
fwd
fwd
fwd
rwd
4wd
4wd
rwd
fwd
4wd
4wd
4wd
4wd
4wd
full-size
compact
full-size
full-size
mid-size
4wd
rwd
rwd
full-size
rwd
rwd
rwd
rwd
mid-size
mid-size
full-size
white
white
white
white
red
silver
white
black
blue
white
white
brown
black
pickup
silver
pickup
pickup
red
truck
silver
other
SUV
blue
SUV
blue
mini-van
blue
sedan
grey
convertible black
other
red
pickup
black
SUV
wagon
white
other
black
other
red
SUV
red
pickup
grey
truck
brown
pickup
red
truck
silver
other
coupe
red
other
white
pickup
green
coupe
custom
sedan
blue
pickup
grey
146561 clean
171865 clean
151544 clean
238229 clean
99883 clean
91596 clean
14169 clean
48055 clean
70760 clean
12302 clean
79500 clean
172118 clean
172222 clean
144597 clean
153107 clean
213104 clean
17805 clean
10496 clean
45858 clean
30237 clean
236000 clean
194000 clean
33154 clean
195976 clean
177122 clean
148840 clean
161541 clean
182003 clean
175137 clean
116091 clean
213539 clean
184225 clean
200745 clean
4007 clean
73001 clean
17022 clean
173000 clean
121229 clean
105943 clean
185485 clean
191610 clean
179893 clean
168860 clean
179429 clean
automatic
automatic
automatic
automatic
automatic
manual
other
other
other
other
automatic
automatic
automatic
automatic
automatic
automatic
other
other
other
other
automatic
automatic
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
other
other
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
rwd
4wd
fwd
fwd
4wd
rwd
4wd
4wd
4wd
rwd
full-size
rwd
rwd
rwd
rwd
rwd
coupe
wagon
SUV
mini-van
sedan
coupe
pickup
pickup
SUV
pickup
SUV
pickup
sedan
SUV
coupe
sedan
pickup
coupe
other
other
mid-size
4wd
fwd
fwd
fwd
fwd
fwd
4wd
fwd
fwd
rwd
fwd
rwd
rwd
rwd
rwd
4wd
fwd
rwd
red
black
grey
grey
silver
silver
silver
blue
white
silver
grey
grey
orange
white
silver
red
white
red
red
black
SUV
pickup
sedan
SUV
SUV
SUV
SUV
hatchback
SUV
SUV
mini-van
sedan
sedan
sedan
SUV
sedan
sedan
SUV
SUV
mini-van
sedan
pickup
black
black
white
grey
silver
blue
grey
black
black
grey
black
silver
blue
blue
white
red
blue
silver
white
red
8573 clean
39763 clean
150000 clean
30240 clean
1366 clean
261000 clean
218000 clean
115000 clean
154000 clean
59000 clean
99000 clean
171000 clean
126000 clean
228000 clean
11902 clean
103275 clean
214740 clean
135848 clean
204407 clean
112214 clean
85065 clean
12069 clean
60984 clean
61261 clean
121000 clean
112000 clean
136000 clean
180767 clean
203067 clean
17500 clean
7256 clean
60201 rebuilt
7012 rebuilt
11325 clean
81552 clean
2408 clean
16796 clean
187000 clean
108000 clean
14358 clean
46057 clean
13088 clean
9064 clean
185500 clean
other
other
automatic
other
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
other
automatic
automatic
automatic
automatic
automatic
automatic
other
other
other
automatic
automatic
automatic
automatic
automatic
other
other
automatic
automatic
other
other
other
other
automatic
automatic
other
other
automatic
other
automatic
fwd
rwd
fwd
mid-size
4wd
4wd
4wd
rwd
fwd
fwd
rwd
rwd
rwd
rwd
rwd
rwd
rwd
rwd
rwd
full-size
mid-size
full-size
mid-size
rwd
rwd
fwd
fwd
rwd
fwd
rwd
rwd
fwd
rwd
rwd
rwd
mid-size
mid-size
sedan
sedan
sedan
hatchback
hatchback
white
white
black
black
white
grey
orange
red
red
blue
grey
blue
white
white
red
grey
black
white
black
silver
silver
SUV
sedan
sedan
sedan
sedan
sedan
SUV
other
hatchback black
SUV
SUV
black
sedan
white
van
green
SUV
green
sedan
silver
sedan
silver
sedan
hatchback silver
SUV
blue
convertible red
coupe
silver
other
white
coupe
green
mini-van
silver
truck
white
sedan
black
sedan
blue
sedan
sedan
black
170000 clean
175 clean
9313 clean
16966 clean
18380 clean
74795 clean
172210 clean
213998 clean
189035 clean
165315 clean
205269 clean
226071 clean
183954 clean
180821 clean
188596 clean
140000 clean
182000 clean
170000 clean
54520 clean
31572 clean
44724 clean
53251 clean
232000 clean
272412 clean
200039 clean
114843 clean
155394 clean
191536 clean
89887 clean
141750 clean
5736 clean
29324 clean
15718 clean
29014 clean
59000 rebuilt
171865 clean
151544 clean
91596 clean
159656 clean
146561 clean
201461 clean
238229 clean
99883 clean
213104 clean
automatic
automatic
other
other
other
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
other
other
other
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
other
other
other
other
automatic
automatic
automatic
manual
automatic
automatic
automatic
automatic
automatic
automatic
rwd
rwd
4wd
rwd
4wd
fwd
fwd
rwd
4wd
4wd
fwd
fwd
fwd
fwd
rwd
rwd
4wd
rwd
rwd
rwd
4wd
fwd
fwd
rwd
4wd
rwd
fwd
fwd
4wd
4wd
fwd
rwd
4wd
rwd
rwd
fwd
4wd
rwd
full-size
mini-van
coupe
pickup
other
pickup
SUV
SUV
mini-van
sedan
pickup
SUV
SUV
SUV
mini-van
sedan
sub-compactSUV
full-size
truck
full-size
mini-van
pickup
coupe
sedan
pickup
full-size
sedan
SUV
SUV
wagon
SUV
sedan
full-size
truck
full-size
pickup
sedan
other
sedan
sedan
full-size
truck
wagon
SUV
coupe
sedan
coupe
pickup
mini-van
sedan
sedan
grey
white
white
white
red
blue
blue
grey
blue
blue
grey
black
red
grey
brown
blue
white
brown
black
black
white
silver
grey
white
white
black
black
black
grey
black
grey
white
red
grey
silver
silver
34303 clean
17897 clean
34818 clean
12102 clean
4200 clean
172222 clean
144597 clean
113262 clean
153107 clean
36731 clean
195976 clean
177122 clean
148840 clean
161541 clean
165812 clean
15207 clean
16493 clean
19139 clean
201000 clean
117000 clean
20624 clean
41750 clean
53000 clean
18650 clean
53263 clean
136040 clean
1688 clean
10744 clean
99500 clean
185485 clean
179429 clean
191610 clean
108164 clean
269700 clean
121229 clean
105943 clean
179893 clean
168860 clean
137042 clean
203986 clean
166267 clean
114575 clean
0 clean
204407 clean
other
other
automatic
other
manual
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
other
automatic
automatic
automatic
other
automatic
automatic
other
other
automatic
other
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
fwd
fwd
fwd
rwd
fwd
rwd
4wd
fwd
fwd
fwd
fwd
4wd
fwd
rwd
fwd
rwd
rwd
rwd
fwd
rwd
4wd
4wd
4wd
rwd
rwd
fwd
rwd
4wd
fwd
4wd
fwd
rwd
sedan
blue
sedan
silver
hatchback white
hatchback black
sub-compact
red
sedan
grey
SUV
orange
sedan
grey
coupe
white
SUV
pickup
black
sedan
black
SUV
white
SUV
grey
mini-van
grey
SUV
hatchback blue
SUV
full-size
mini-van
black
SUV
sedan
blue
sedan
white
coupe
black
convertible black
pickup
white
full-size
sedan
black
sedan
blue
coupe
full-size
truck
blue
SUV
red
pickup
red
SUV
blue
sedan
silver
sedan
sedan
mini-van
sedan
pickup
SUV
SUV
SUV
sedan
sedan
blue
white
silver
white
silver
blue
purple
grey
black
113464 clean
20845 clean
24379 clean
19980 clean
38872 clean
148000 clean
112214 clean
180767 clean
203067 clean
103275 clean
214740 clean
135848 clean
22821 clean
25786 clean
79 clean
112000 clean
121399 clean
41886 clean
183761 clean
197926 clean
43280 clean
156220 clean
164677 clean
33780 clean
77492 clean
52294 clean
142000 clean
148000 clean
58000 clean
158000 clean
84000 clean
171000 clean
290000 clean
52366 clean
2630 clean
2212 clean
114850 clean
21000 clean
64559 clean
138709 clean
3066 clean
137876 clean
189745 clean
205269 clean
automatic
other
other
automatic
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
automatic
other
other
automatic
manual
other
automatic
automatic
automatic
automatic
automatic
other
other
other
automatic
automatic
automatic
automatic
automatic
automatic
automatic
other
other
other
automatic
automatic
automatic
automatic
other
automatic
automatic
automatic
fwd
mid-size
fwd
rwd
rwd
rwd
rwd
rwd
rwd
fwd
fwd
full-size
fwd
fwd
4wd
fwd
rwd
rwd
4wd
fwd
rwd
full-size
rwd
SUV
sedan
sedan
sedan
sedan
truck
sedan
SUV
sedan
sedan
sedan
sedan
SUV
sedan
other
mini-van
sedan
pickup
SUV
SUV
sedan
sedan
mini-van
sedan
pickup
coupe
mini-van
4wd
4wd
4wd
fwd
rwd
rwd
4wd
rwd
fwd
4wd
4wd
mid-size
mid-size
truck
sedan
sedan
other
sedan
hatchback
SUV
sedan
sedan
pickup
pickup
SUV
black
blue
black
black
black
white
silver
green
silver
grey
black
white
blue
silver
white
silver
black
blue
white
silver
red
white
white
black
black
custom
black
red
white
white
brown
green
black
black
grey
black
white
grey
blue
grey
10647 clean
40251 clean
27160 clean
14028 clean
30356 clean
226071 clean
172210 clean
207449 clean
189611 clean
180821 clean
50473 clean
19988 clean
118000 clean
49355 clean
9704 clean
17805 clean
4936 clean
8000 rebuilt
22812 clean
30970 clean
15575 clean
19502 clean
33424 clean
17302 clean
22870 clean
23057 clean
123165 clean
62588 clean
78712 clean
1548 clean
39649 clean
200000 clean
9567 clean
8373 clean
51482 clean
53752 clean
12302 clean
15813 clean
16903 clean
102 clean
149000 clean
5999 clean
37725 clean
4899 clean
other
other
other
other
other
automatic
automatic
automatic
automatic
automatic
other
other
automatic
automatic
other
other
other
automatic
other
other
other
other
other
other
other
other
automatic
other
other
other
other
automatic
other
other
other
other
other
other
other
other
automatic
other
other
other
fwd
4wd
rwd
fwd
4wd
4wd
mid-size
rwd
rwd
fwd
compact
rwd
rwd
4wd
4wd
4wd
rwd
rwd
rwd
4wd
rwd
fwd
rwd
fwd
4wd
rwd
4wd
rwd
rwd
full-size
hatchback
hatchback
sedan
SUV
other
SUV
SUV
pickup
pickup
mini-van
SUV
hatchback
SUV
coupe
coupe
pickup
other
sedan
pickup
other
pickup
coupe
pickup
pickup
pickup
sedan
pickup
sedan
SUV
coupe
hatchback
black
white
black
white
silver
pickup
coupe
sedan
pickup
pickup
other
coupe
pickup
SUV
other
pickup
coupe
silver
white
white
white
white
white
yellow
red
red
blue
black
blue
brown
white
brown
red
red
black
grey
black
white
brown
blue
white
red
black
white
silver
white
red
black
black
white
red
93185 clean
48055 clean
6955 clean
70760 clean
83600 clean
45858 clean
30237 clean
39650 clean
19370 clean
28921 clean
3993 clean
14745 clean
18748 clean
7256 clean
17500 clean
125000 clean
17304 clean
190000 clean
25484 clean
37202 clean
191400 salvage
11325 clean
9313 clean
23483 clean
72000 rebuilt
60004 rebuilt
25000 rebuilt
9064 clean
46057 clean
45611 clean
9740 clean
74795 clean
18380 clean
9424 clean
5157 clean
17300 clean
29158 clean
165000 clean
12391 clean
21711 clean
45000 rebuilt
21086 clean
24301 clean
18318 clean
other
other
other
other
other
other
other
other
other
other
other
other
other
other
other
automatic
other
automatic
other
other
manual
other
other
other
automatic
automatic
manual
other
other
automatic
other
other
other
other
other
other
other
automatic
other
other
automatic
other
other
other
4wd
4wd
rwd
rwd
rwd
rwd
fwd
fwd
fwd
fwd
fwd
4wd
full-size
fwd
mid-size
fwd
rwd
4wd
rwd
fwd
fwd
fwd
rwd
rwd
rwd
rwd
4wd
compact
compact
mid-size
compact
rwd
4wd
rwd
fwd
4wd
fwd
fwd
full-size
other
white
pickup
silver
SUV
silver
SUV
blue
coupe
black
other
red
other
red
other
black
SUV
other
other
white
other
red
SUV
black
sedan
sedan
silver
pickup
white
hatchback white
mini-van
custom
sedan
sedan
red
sedan
brown
convertible red
pickup
white
convertible red
coupe
red
coupe
blue
sedan
black
sedan
black
sedan
blue
sedan
black
convertible
SUV
red
pickup
white
coupe
orange
coupe
SUV
black
convertible white
black
SUV
brown
other
pickup
grey
other
white
SUV
white
SUV
red
61087 clean
26978 clean
38840 clean
37238 clean
11878 clean
53263 clean
5160 clean
10744 clean
20845 clean
28946 clean
62993 clean
32458 clean
79 clean
27160 clean
38905 clean
42966 clean
18634 clean
30356 clean
65290 clean
137000 clean
11777 clean
23997 clean
1134 clean
21415 clean
19506 clean
9326 clean
other
other
other
other
other
other
other
other
other
other
other
other
other
other
other
other
automatic
other
automatic
automatic
other
other
other
other
automatic
other
fwd
rwd
rwd
fwd
rwd
4wd
rwd
4wd
sedan
hatchback
SUV
sedan
sedan
pickup
coupe
coupe
sedan
sedan
sedan
SUV
other
sedan
coupe
SUV
coupe
other
coupe
SUV
other
SUV
SUV
hatchback
sedan
SUV
red
brown
silver
blue
white
orange
blue
white
silver
black
white
black
red
black
red
silver
black
grey
black
brown
black
blue
red
white
Anticipated
Employment Expected Salary in 5
ID Num Gender
Status
Salary
Years
Spending
ID01
M
PT
45
75
200
ID02
M
FT
120
250
150
ID03
M
FT
85
120
65
ID04
M
FT
100
150
150
ID05
M
FT
80
90
300
ID06
F
FT
100
150
250
ID07
M
FT
100
125
400
ID08
M
FT
60
100
60
ID09
F
FT
50
60
180
ID10
M
PT
50
80
700
ID11
M
FT
60
100
100
ID12
M
FT
65
100
200
ID13
M
FT
80
110
300
ID14
M
FT
100
150
100
ID15
F
UN
50
100
1000
ID16
M
FT
40
65
300
ID17
F
FT
70
100
200
ID18
F
FT
60
75
150
ID19
M
FT
105
120
150
ID20
F
FT
60
100
130
ID21
F
UN
45
65
300
ID22
F
FT
60
80
200
ID23
M
FT
80
140
90
ID24
F
FT
65
85
170
ID25
M
PT
60
150
320
ID26
M
FT
65
135
200
ID27
F
FT
55
90
600
ID28
M
FT
90
130
200
ID29
M
FT
70
100
100
ID30
F
FT
45
80
160
ID31
F
PT
80
110
230
ID32
M
FT
75
150
500
ID33
M
FT
60
85
250
ID34
F
FT
75
95
150
ID35
F
FT
65
90
120
ID36
M
FT
50
85
160
ID37
F
FT
75
100
100
ID38
F
FT
60
90
160
ID39
M
FT
90
160
130
ID40
M
PT
55
85
110
This is a sample raw data file resulting fro
survey. We can create some tables usin
Excel/Pivot Table. Let’s construct a one
table for gender and a two way table for g
and employment status.
For the one way table, click on Insert/Pivo
Table. Select range and highlight all the
columns. Select new worksheet. Drag g
which is to the far right in the pivot table f
down to rows. Next drag gender again d
values. It should show “count”. If not, us
drop down arrow to get value field setting
select “count”.
If you want to show a bar chart, click on I
and look for the picture of a bar chart and
it. Also for a pie chart.
For a two way table, same initial steps as
Drag gender down to rows, drag employm
status down to columns, and drag either
down to values. Again make sure count
A two way table can be used to examine
two categorical variables may be related.
Next let’s construct a one way table that s
the total of all the expected salary of male
females. Same initial steps, drag gender
to rows, drag expected salary down to va
and make sure it shows sum. If not chan
the value field setting.
mple raw data file resulting from a
e can create some tables using
Table. Let’s construct a one way
nder and a two way table for gender
ment status.
way table, click on Insert/Pivot
ect range and highlight all the
Select new worksheet. Drag gender
he far right in the pivot table field list
ws. Next drag gender again down to
hould show “count”. If not, use the
arrow to get value field settings and
nt”.
to show a bar chart, click on Insert
r the picture of a bar chart and select
a pie chart.
ay table, same initial steps as before.
er down to rows, drag employment
n to columns, and drag either variable
ues. Again make sure count shows.
able can be used to examine whether
ical variables may be related.
onstruct a one way table that shows
all the expected salary of males and
ame initial steps, drag gender down
ag expected salary down to values
ure it shows sum. If not change it in
eld setting.
One way table
Count of Gender
Gender
F
M
Grand Total
Total
16
24
40
Two way table
Count of Gender
Gender
F
M
Grand Total
Employment Status
FT
PT
UN
13
1
20
4
33
5
Summary table
sum
Gender
F
M
Grand Total
Total
1015
1785
2800
2
2
Grand Total
16
24
40
13
Frequency Distribution:
Here is a hypothetical list of the number of caramel popcorn
cans sold in 70 scout troops in Maryland. Use Excel’s
capability (=FREQUENCY()) to create a frequency distribution
Number of Caramel popcorn cans sold in each troop
144
105 103
105
148 158 121
153
147 142
110
115 192 158
153
199 174
107
179 183 129
198
164 120
163
163 118 184
180
114 107
107
158 137 184
190
175 159
143
142 152 182
183
119 149
136
172 145 184
MIN
MAX
Use the =MIN() function to find the lowest num
Use the =MAX() function to find the highest nu
Subtract the lowest number of cans sold from the highest number of
The range of number of cans sold is:
14
Decide how many bins to use. Study the data and pick a number bet
See https://www.statisticshowto.com/choose-bin-sizes-statistics/
In one paragraph below explain why you selected the numbers of bin
15
Now divide the range of the cans sold by the number of bins to find t
Size of each bin is
16
Create your bins:
Start with the minimum number of cans sold and add the size of the
Therefore,
plus
is the highest number that the
The =FREQUENCY() function uses the highest number of each bin wh
The next bin highest number starts with the first bin’s highest numbe
Therefore, the second bin begins with
and adds the bin size
Continue adding to get the Bins array for the =FREQUENCY() functio
Follow the instructions in the youtube videos to use the =FREQUENC
You know that you have correctly used the =FREQUENCY() function i
Min
Max
Bins:
Frequency:
Note: Some versions of Excel treat the last bin a bit differently, so the FREQUENCY function may
If you get that, don’t worry about it, we will accept either answer.
mel popcorn
y distribution
old in each troop
130
118
196
149
194
119
134
186
200
189
126
142
168
175
157
140
150
177
103
160
113
o find the lowest number of popcorn cans sold.
to find the highest number of popcorn cans sold.
e highest number of cans sold:
nd pick a number between 5 and 10
n-sizes-statistics/
d the numbers of bins (between 5 and 10)
mber of bins to find the size that each bin should be
est number that the first bin should be.
umber of each bin when calculating the number in each bin.
t bin’s highest number and adds the size of the bins.
to get
use the =FREQUENCY() array function.
EQUENCY() function if Excel automatically puts {} around the function.
he FREQUENCY function may show the last bin as one higher than it should be.
18
As part of the marketing group of a film company, you a
You ask questions of customers who exit the theatre. Fr
165 are 10 to 14, 25 are 15 to 21, and 174 are older tha
a) Make a frequency table of these categorical data.
b) Make a relative frequency table.
c) Make a bar chart using counts in the frequency table.
d) Would a bar chart of relative frequencies look any different?
e) Make a pie chart.
Write a few sentences summarizing the distribution demonstrated by
19
In addition to age grouping information, the audiences interviewed were a
17
never
once
more than once
under 6
42
4
3
6 to 9
62
21
4
10 to 14 15 to 21 over 21
90
20
152
41
5
17
34
0
5
a) Find the marginal distributions of their previous viewing of the mov
b) Verify that the marginal distribution of the ages is the same as that
20
Continue with the data from question 19
c) Find column percentages.
d) Looking at these percentages, does the distribution of how many tim
e) Make a stacked bar chart showing the distribution of viewings for e
f) What is the percentage of all audience members who are over 21? A
g) If these proportions are not the same, what does that mean with r
m company, you are asked to find out the age distribution of the audience of the latest
xit the theatre. From 500 responses, you find that 49 are younger than 6 years old, 87
nterviewed were also asked if they had seen the movie before (Never, Once, More than
viewing of the movie. Margin means total. Create a new column labeled “total”.
s the same as that given previously. Create a bottom row labeled “total”.
on of how many times someone has seen the movie look the same for each age group?
who are over 21? And what percentage of audience members who saw the movie more
s that mean with respect to the variables “age” and “frequency of viewing movies”?
me for each age group? What can you assume from these percentages?