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
Create a derived table which computes row number for employees in the USA partitioned by the employee’s country.
Write sql query to create given table.
Using software.subscriptions table, pull all columns for subscriptions that have been cancelled.
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
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
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning