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)