Data Mining for Business Analytics: Concepts, Techniques, and Applications with XLMiner
Data Mining for Business Analytics: Concepts, Techniques, and Applications with XLMiner
3rd Edition
ISBN: 9781118729274
Author: Galit Shmueli, Peter C. Bruce, Nitin R. Patel
Publisher: WILEY
bartleby

Concept explainers

Expert Solution & Answer
Book Icon
Chapter 2, Problem 8P

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:

Mean = Sum of all termsTotal number of terms

Standard deviation = xiμ2N

The calculation for the mean value of age is as follows:

Mean = 25+56+65+32+41+496=44.67

The calculation for the mean value of income is as follows:

Mean = 49000+156000+99000+192000+39000+570006=98666.67

The calculation of the standard deviation value for age is as follows:

Mean = 49000+156000+99000+192000+39000+570006=98666

Blurred answer
Students have asked these similar questions
Normalise the table to 3rd Normal Form.
Normalize the table to fourth normal form.
Question 2 Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL queries are used to insert, update and modify data. By referring to the Table1 below, write the SQL statements for the following: Table 1: Students PhoneNumber ID 1234 4567 Names Aishah Absya Ah Meng Bee Chean Buchanan Country Somalia Malaysia China Age 18 21 20 0131234561 0131234562 8910 01312345673 1112 1314 01312345674 0131234565 Korea Korea 19 20
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning