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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!