full marks 100 section a 100 marks answer all questions in this sectio
Search for question
Question
(Full marks: 100)
Section A (100 marks)
Answer all questions in this section.
You are given a dataset pertaining to the tasks assigned for this ECA. The name of the
dataset is <Electric_Vehicle_Population_Data_usa.csv>. This dataset is posted with
the ECA question paper on the Canvas system.
Question 1
For the given dataset, produce a table that identifies and justifies the data type (nominal,
ordinal, interval, or ratio) for each variable; the table should present the summary
statistics (mean, median, number of observations, mode, minimum and maximum) for all
the variables. Present the answer in tabular format.
(20 marks)
Question 2
Inspect the data for quality issues and prepare the data using appropriate treatment
methods. Explain the data quality issues identified and treatment methods applied with
the aid of suitable screenshots. (Maximum word count: 250 words)
(30 marks)
Question 3
For the treated dataset, develop four charts to visualise and explain the key patterns found
in the data. Use each of the following chart types or features at least once:
• Reference line
• Parameters
Provide screenshots of the charts in your report. (Maximum word count: 300 words).
Question 4
(25 marks)
Using the charts created in Question 3, develop a business performance dashboard.
Explain how your dashboard follows the Dashboard Design Principles. Provide a
screenshot of your dashboard in the report. Set up two (2) relevant Actions (of different
types) for advanced dashboard navigation so that users can perform some of the following
tasks: filtering, highlighting, drilling down or navigating to an external HTTP link.
Provide screenshots of the Action settings. (Maximum word count: 300 words)
- END OF ECA PAPER
(25 marks)