Concept explainers
Explanation of Solution
Given: The following table:
To find: The possible way to normalize the data.
Solution:
The normalization can be calculated by subtracting the average by each measurement and dividing the difference with the standard deviation. The mean value of age will be 44.67. The mean value of income will be 98666.67. The standard deviation’s value for the age will be 13.65. The standard deviation’s value for the income will be 62867.06. The formula for calculating the mean as well as standard deviation is as follows:
The calculation for the mean value of age is as follows:
The calculation for the mean value of income is as follows:
The calculation of the standard deviation value for age is as follows:
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
Data Mining for Business Analytics: Concepts, Techniques, and Applications with XLMiner
- Suppose you have given the table structure and data shown in tablearrow_forwardPopulate the tables with the following data, Save and print a copy of each table.arrow_forwardDescribe the additional data processing/transformation that would be required if you wanted to sort data by city name on a given table?arrow_forward
- 7.use sql to Display the total number of orders per month. Sort the result from January to December, from the following picturearrow_forward9..use the following data to shown minimum and maximum and average of parts unit pricearrow_forwardProvide SQL queries for tables: employees, departments, 1. List all employees whose first name is "John" and whose last names begin with "B."2. List all employees in the Marketing department, including their employee number, last name, firstname, and salary.arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage