
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 solution
Chapter 2 Solutions
Data Mining for Business Analytics: Concepts, Techniques, and Applications with XLMiner
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
- 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 Learning



