Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions

Question

LO3 Discuss the steps of a typical selection process.

Answered: 1 week ago