Assume you are giving a dataset that is based on user surveys. You notice that many surveys have missing fields. You also notice that some surveys have fields on a scale of 1 to 5 while others are on scale of 1 to 10. The survey has mixed information using metric measurements and the imperial system. There are some different fields depending on the country, but they all relate to the location of the participant. You also notice that some values just don't make sense. What analysis would you do on the data set to come up with a data cleaning plan? What are some normalization and cleaning tasks you could do based on the information provided in this description?

Assume you are giving a dataset that is based on user surveys. You notice that many surveys have missing fields. You also notice that some surveys have fields on a scale of 1 to 5 while others are on scale of 1 to 10. The survey has mixed information using metric measurements and the imperial system. There are some different fields depending on the country, but they all relate to the location of the participant. You also notice that some values just don't make sense. What analysis would you do on the data set to come up with a data cleaning plan? What are some normalization and cleaning tasks you could do based on the information provided in this description?

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter11: User Interfaces, Visual Basic For Applications (vba), And Collaboration Features

Section: Chapter Questions

Problem 5EYW

See similar textbooks

Similar questions

Why is it important to separate the data into two sets for training and validation? What will the training set's purpose be? What is the validation set's purpose?
The Vegan Garden is a little restaurant that may be found in the tranquil village of Dawnsville. It has been five years since the eatery first opened its doors. At the moment, sales are recorded manually via the use of cash registers, and monthly sales reports and other corporate paperwork, such as information on employees and suppliers, are kept in dated filing cabinets. The owner of Vegan Garden has made the decision to develop an information system. He then went and sought the aid of a company that specializes in information technology in order to design an information system that would be suitable for the current commercial operations of the Vegan Garden.You have been given the responsibility of serving as the project manager for the creation of the Vegan Garden information system.As the project manager of the development project, it is your responsibility to advise the owner of Vegan Garden about the information system security issues that exist. Provide an explanation for ANY…
Why is it important to separate the data into two sets for training and validation? What will the training set's purpose be? What is the validation set's purpose? Computer science
Why is it necessary to divide the data into training and validation sets? What will be the purpose of the training set? What is the purpose of the validation set?
Use a conventional histogram as a guide for analyzing data. Is it OK to have a normalized histogram but not a non-normalized one?
Find a complex design with a bug, and provide enough evidence to confirm that the bug cannot be detected with gdb, but can be detected with ASAN. Please add the reference(s) if you plan to borrow from online resouces
Draw the ER/EER model for the given scenario. Manufacturer have unique name, an address, and a phone number. Products have a product_id, a name and price. Products may be classified into electronics and grocery. Electronic products have description, type attributes. Groceries have fssai_number, date_of manufacture, date_of_expiry. Each product is made by one manufacturer, and different manufacturers may produce different products.. Customers are identified by their unique social security number. They have email addresses, and physical addresses. Several customers may live at the same (physical) address, but we assume that no two customers have the same email address. An order has a unique order number, and a date. An order is placed by one customer. For each order, there are one or more products ordered, and there is a quantity for each product on the order
We used to put large amounts of ungrouped data into intervals that we chose as a general rule. We have to deal with huge and hard problems, just like in the real world. Are there any pros or cons to working in a group instead of alone?
Please use excel or matlab Simulate 100 random normal variables with mean 1.5 and standard deviation and create a histogram which shows the data in the range between −4 and 10, with class intervals of length 0.5 Make sure that your name and current date are also included in the histogram title on this and all the other histograms you generate for this exercise.
Use python to solve this. Task: Handling missing data (Replacing missing data with the mean value or others) Plot a histogram for each numerical attribute Splitting the Dataset into the Training set and Test set
Model evaluation Create a predictions variable using your fitted model and the test dataset; call it y_pred. Then get the accuracy score of your predictions and save it in a variable called accuracy. Finally get the confusion matrix for your predictions and save it in a variable called confusion_mat. Code: y_pred = Noneaccuracy = Noneconfusion_mat = None
integrate 5 references in your analysis that support your points.