Altair Monarch Learning Series 2023 Exercise 5 Solution: Electric Vehicle Population Analysis

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited September 2023 in Altair RapidMiner

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

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.

 


Tagged:

Categories