Monarch Learning Series 2023 Exercise 5 - Electric Vehicle Population Analysis

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
• Skills/Features Tested: Merge Columns, Show Statistics, Filter, GroupBy, Pivot, Duplicate
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 10 mins
• Exercise files required are attached
  • Electric_Vehicle_Population_Data.xlsx

Exercise Overview

You are a Research Analyst at an Automotive OEM (Original Equipment Manufacturer; FORD, TOYOTA, BMW etc) and your Manager has asked you to analyze a sample data set of Electric Vehicle Population in Washington State, to answer the following questions:

1. What Make & Model is the Most Popular?
2. What Make & Model is the Least Popular?
3. How many cars across all the OEMs fall into these two categories for Clean Alternative Fuel Vehicle Eligibility?
   • Clean Alternative Fuel Vehicle Eligible
   • Not eligible due to low battery range

Answer

• Please upload your answers below in the comment section for the exercise
• A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.

Margi

Answers in attachment

Bhagyaraj Mullangi

Hi,

Here are the answers

Q1 and Q2: Attached xlsx sheet(Q1-Q2-Topper-Least.xlsx)

Q3: Attached (Q3-part1-part2.xlsx)

 

Susan DeWitt

I got the answers but was thinking there would be a way to summarize for the top x or bottom x values.

Baba_Majekodunmi_703

Susan DeWitt said:

I got the answers but was thinking there would be a way to summarize for the top x or bottom x values.

Excellent work Susan!

David Nash

Attempt

Cassandra Cassady

1 attachment