Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started