Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 2: [5 Marks] Given the dataset below, during data recording, some issues happened. # Gender M 1 2 M F 3 Age Hours_Per_Day 23

image text in transcribed

Question 2: [5 Marks] Given the dataset below, during data recording, some issues happened. # Gender M 1 2 M F 3 Age Hours_Per_Day 23 1 55 32 2 22 6 5 3 25 4 Preferred_Browser Preferred_Search Engine Facebook Twitter Firefox Google Y N Chrome Google Y Y Firefox Yahoo Y N Firefox Google 99 Y Internet Explorer Bing Y N Internet Explorer Google N N 4 F 5 M 6 M 1) Determine the type of every attribute as binary, nominal, or numeric. Provide the definition domain of every attribute: e.g. Gender = [M, F], Hours_Per_Day = [1,6], etc. [1.5 Marks] 2) Determine three (3) tuples containing data that needs cleaning and precise the issue by ticking the right box in the table below: [2 marks] Noisy data Outlier Missing data Tuple # 3) Explain how to handle each issue and suggest a corrected data. [1.5 Marks]

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

Students also viewed these Databases questions

Question

What are the characteristics of a mature industry?

Answered: 1 week ago

Question

Describe Balor method and give the chemical reaction.

Answered: 1 week ago

Question

How to prepare washing soda from common salt?

Answered: 1 week ago

Question

Explain strong and weak atoms with examples.

Answered: 1 week ago

Question

3. What are potential solutions?

Answered: 1 week ago

Question

Which team solution is more likely to be pursued and why?

Answered: 1 week ago