302 Wk5 Discussion Excel Insert

.xlsx

School

American Public University *

*We aren’t endorsed by this school

Course

302

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

14

Uploaded by HighnessElephantMaster98

Vehicle Type Year Make Model Price Sedan 2020 KIA Optima 4S 22,960 19 Sedan 2024 KIA Niro Hybrid LX 26,840 45 SUV 2015 Jeep Wrangler Unlimted 23,000 11 SUV 2024 Jeep Wrangler 30,295 15 Truck 2023 Chevrolet Silverado 1500 55,300 18 Sports 2023 Dodge Challenger CT 33,027 19 SUV 2005 Jeep Wrangler Unlimted 10,130 16 SUV 2022 Mitsubishi Eclipse Cross 23,695 25 SUV 2022 Toyota RAV4 26,525 28 Sedan 2023 Honda Accord Hybrid 31,736 44 Qualitative Quantitative Qualitative Qualitative Quantitative Quantitative    MPG - City 
Cylinder Liter Drivetrain 42 4 Cyl 2.4 Liter FWD 53 4 Cyl 1.6 Liter FWD 14 V6 3.6 Liter 4WD 21 V6 3.6 Liter 4WD 21 8 Cyl 5.3 Liter 4WD 30 6 Cyl 3.6 Liter RWD 19 6 Cyl 4.0 Liter 4WD 27 4 Cyl 1.5 Liter FWD 30 4 Cyl 2.5 Liter FWD 48 4 Cyl 2.0 Liter FWD Quantitative Quantitative Quantitative Qualitative     MPG - Highway
Price $22,960 $26,840 $23,000 $30,295 $55,300 $33,027 $10,130 $23,695 $26,525 $31,736 Mean: $28,351 Median: $26,840 SD: 10367.9572 Sample Size: 10
Price Mean 28350.8 Standard Error 3621.46010087399 Median 26682.5 Mode #N/A Standard Deviation 11452.0623741849 Sample Variance 131149732.622222 Kurtosis 3.78737401968821 Skewness 1.22535714696287 Range 45170 Minimum 10130 Maximum 55300 Sum 283508 Count 10 Confidence Level(95.0%) 8192.31190698
Price $22,960 $26,840 $23,000 $30,295 $55,300 $33,027 $10,130 $23,695 $26,525 $31,736 $1,000,000 Mean: $116,683 Median: $26,840 SD: 293164.637 Sample Size: 11
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