Question: Question 2 - Data Preprocessing (30%) Suppose you work for a company as an analyst and you are given a data set about the average

Question 2 - Data Preprocessing (30%) Suppose you work for a company as an analyst and you are given a data set about the average monthly temperature in Ottawa. A sample of the data set is shown in the table below: Month, Year January, 2018 February, 2018 March, 2018 April, 2018 May, 2018 Average Monthly Temperature (in Celsius) NULL -7.9 -2.2 6.5 13.5 July, 2018 August, 2018 21.2 NULL One of the challenges in analyzing the data is that it contains missing values (represented as NULL in the table). Your boss suggested that you should replace the missing values by the average value of the entire data. (a) (15%) Explain why your boss' strategy for handling missing values is not reasonable for this dataset. Answer: (b) (15%) Give an alternative method that is more reasonable for imputing (replacing) the missing values in the data. Assume the data points with missing values should not be discarded
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
