Description
I need help with Excel Auto analysis
Unformatted Attachment Preview
Make
Lincoln
Aston Martin
Toyota
Ford
Chevrolet
Chevrolet
Lamborghini
HUMMER
Toyota
Maserati
Chevrolet
Suzuki
Ford
Chevrolet
Scion
Toyota
Volkswagen
Ford
Lexus
Audi
Volkswagen
Ferrari
Volkswagen
Subaru
Dodge
Acura
FIAT
Buick
Suzuki
Model
MKS
DBS
Camry Solara
Mustang SVT Cobra
Tahoe
Cobalt
Huracan
H3
Sienna
Coupe
C/K 1500 Series
Aerio
Freestar
TrailBlazer
xD
Highlander
Jetta SportWagen
Transit Connect
GS 430
A3
Beetle Convertible
California T
Passat
WRX
Charger
Integra
500L
Verano
X-90
Year Transmission Type
2020 AUTOMATIC
2016 AUTOMATIC
2012 AUTOMATIC
2002 MANUAL
2019 AUTOMATIC
2013 MANUAL
2020 AUTOMATED_MANUAL
2014 AUTOMATIC
2019 AUTOMATIC
2008 MANUAL
2001 MANUAL
2009 MANUAL
2009 AUTOMATIC
2012 AUTOMATIC
2017 AUTOMATIC
2019 AUTOMATIC
2017 AUTOMATIC
2021 AUTOMATIC
2010 AUTOMATIC
2019 AUTOMATED_MANUAL
2019 AUTOMATED_MANUAL
2019 AUTOMATED_MANUAL
2020 AUTOMATIC
2020 AUTOMATIC
2019 AUTOMATIC
2004 MANUAL
2020 MANUAL
2020 AUTOMATIC
2015 MANUAL
Number of Doors
Data from “Car Features and MSRP” compiled by CooperUnion, https://www.kaggle.com/CooperUnion/cardataset
Vehicle Size
4 Large
2 Midsize
2 Midsize
2 Compact
4 Large
2 Compact
2 Compact
4 Midsize
4 Large
2 Compact
2 Large
4 Compact
4 Midsize
4 Midsize
4 Compact
4 Midsize
4 Compact
4 Compact
4 Midsize
2 Compact
2 Compact
2 Compact
4 Midsize
4 Compact
4 Large
2 Compact
4 Compact
4 Midsize
2 Compact
Vehicle Style
Sedan
Convertible
Coupe
Convertible
4dr SUV
Coupe
Coupe
4dr SUV
Passenger Minivan
Coupe
Regular Cab Pickup
Wagon
Passenger Minivan
4dr SUV
4dr Hatchback
4dr SUV
Wagon
Passenger Minivan
Sedan
Convertible
Convertible
Convertible
Sedan
Sedan
Sedan
2dr Hatchback
Wagon
Sedan
2dr SUV
highway MPG city mpg MSRP
26
17 $ 39.010,00
18
12 $ 290.861,00
31
22 $ 21.010,00
24
16 $ 4.059,00
22
16 $ 49.300,00
35
25 $ 15.660,00
21
14 $ 238.500,00
18
14 $ 38.365,00
25
18 $ 28.700,00
15
10 $ 81.013,00
18
14 $ 2.992,00
28
22 $ 15.449,00
21
16 $ 32.755,00
20
14 $ 33.945,00
33
27 $ 16.545,00
25
19 $ 36.590,00
31
24 $ 26.195,00
27
19 $ 25.590,00
23
16 $ 51.375,00
32
23 $ 47.050,00
29
23 $ 32.595,00
23
16 $ 198.973,00
38
25 $ 23.975,00
24
18 $ 31.595,00
25
15 $ 47.995,00
28
22 $ 7.398,00
33
25 $ 19.495,00
32
21 $ 24.475,00
26
22 $ 2.000,00
Field
Sum
Average
Count
Max
Min
Grader – Instructions
Excel 2022 Project
YO22_Excel_Ch06_PS1_Automobiles
Project Description:
Community Auto Sales is considering opening a new location on the east side of town. They need to determine the types of
vehicles that they would like to have on the lot for sale. They have acquired a sample data set of vehicle features and
estimated MSRP (manufacturer’s suggested retail price) and need your help in setting up some analysis so that they can
explore their options.
Steps to Perform:
Points
Possible
Step
Instructions
1
Start Excel. Download and open the file named Excel_Ch06_PS1_Automobiles.xlsx. Grader
has automatically added your last name to the beginning of the filename. Save the file to the
location where you are storing your files.
0
2
Converting plain data sets to Excel Tables can provide easy ways to explore the data.
8
The data on the AutoSample worksheet includes details about vehicles that the company may
be interested in buying for resale. On the AutoSample worksheet, insert a table with headers
using the data.
3
With the table selected, including the headers, create a CarDatabase named range to be
used in database functions later.
2
4
Insert six rows above the table to make room to create an advanced filter.
5
5
In order to create an Advanced Filter you must include the column headings to which you will
be specifying criteria.
Copy the headers in A7:J7 and paste the headings starting in cell A1.
2
6
Using the Advanced Filter, display only the records with an Automatic transmission type, that
are a Midsize vehicle size, with an MSRP of
Purchase answer to see full
attachment
