Assignment #1 Cars
xlsx
keyboard_arrow_up
School
Stockton University *
*We aren’t endorsed by this school
Course
1206
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
8
Uploaded by lizjafolla
2013 Ford F-150 XTL
Price
Milage
Ford Option 1
20,988
93,223
Ford Option 2
17,900
104,248
Ford Option 3
12,999
119,721
Ford Option 4
17,990
120,118
Ford Option 5
13,500
170,499
Ford Option 6
11,950
173,491
Ford Option 7
24,995
57,903
2013 GMC Sierra 1500 SLE1
GMC Option 1
20,988
69,053
GMC Option 2
23,995
68,890
GMC Option 3
25,991
37,629
GMC Option 4
15,570
142,181
GMC Option 5
14,999
151,418
GMC Option 6
14,998
142,587
GMC Option 7
12,850
147,210
2013 RAM 1500 SLT
RAM Option 1
12,921
172,702
RAM Option 2
19,263
89,721
RAM Option 3
16,800
106,138
RAM Option 4
16,619
153,156
RAM Option 5
11,999
136,019
RAM Option 6
15,796
114,949
RAM Option 7
15,995
145,100
2013 Chevrolet Silverado 1500 LT
Chevrolet Option 1
15,556
141,065
Chevrolet Option 2
10,990
210,294
Chevrolet Option 3
16,500
140,179
Chevrolet Option 4
11,995
210,995
Chevrolet Option 5
10,985
148,789
Chevrolet Option 6
14,397
142,587
Chevrolet Option 7
15,850
130,415
2013 Toyota Tacoma Base
Toyota Option 1
17,999
164,706
Toyota Option 2
12,500
260,860
Toyota Option 3
15,876
180,270
Toyota Option 4
27,991
24,752
Toyota Option 5
15,798
75,122
Toyota Option 6
18,999
174,725
Toyota Option 7
18,495
100,201
This chart of Excel.
Editing thi
workbook
will perma
This chart i
of Excel.
Editing this
workbook i
permanentl
This chart i
of Excel.
Editing this
workbook permanentl
This chart of Excel.
Editing thi
workbook permanent
This chart i
Excel.
Editing this
Min
10,985
24,752
Q1
13249.5
102224.5
Medium
19,742
96,712
Q3
18247
158931
Max
27,991
260,860
UB
25743.25
243990.75
LB
5753.25
17164.75
IQR
4997.5
56706.5
Mean
19,742
96,712
Models
Insurance
Saftey Rating
Yearly Repair Costs
2013 Ford F-150 1,024
4
870
2013 GMC Sierra 1500 SLE1
1,846
4
693
2013 RAM 1500
1,440
4
698
2013 Chevrolet Silverado 1500 LT
1,237
4
711
2013 Toyota Tacoma Base
1,181
4
509
Min
1,024
509
Q1
1181
693
Median
1,237
698
Q3
1440
711
Max
1,846
870
IQR
259
18
Mean
1,346
696
UB
1828.5
738
LB
792.5
666
To find cars:
Saftey Rating:
https://www.cars.com
https://www.carfax.com
Editing this
into a differ
break the c
Repair and Insurance:
https://www.transportation.gov/
https://caredge.com/gmc/sierra-1500/insurance
https://www.moneygeek.com/insurance/auto/compare-quotes/#compare-quotes-by
https://repairpal.com/
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Graphs
isn't available in your version is shape or saving this k into a different file format anently break the chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
isn't available in your version s shape or saving this into a different file format will ly break the chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
isn't available in your version s shape or saving this into a different file format will ly break the chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
isn't available in your version is shape or saving this into a different file format will tly break the chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
isn't available in your version of s shape or saving this workbook
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format wi
permanently break the chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format w
s shape or saving this workbook rent file format will permanently chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file for
will permanently break the chart.
y-vehicle-type
Editing this shape or saving this workbook into a different file format w
permanently break the chart.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ill will rmat .
will