Data Normalization Methods: Understanding and Choosing the Right One

  • Context:
  • Thread starter Thread starter aruwin
  • Start date Start date
  • Tags Tags
    Data Normalization
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
3 replies · 3K views
aruwin
Messages
204
Reaction score
0
Hello, please help me with this problem. The question is in the picture. I don't know how to normzalize the data. How to know which method should be used? I need two methods of normalization here. HELP!
Please teach me in detail.
View attachment 1755
 

Attachments

  • IMG_5460.JPG
    IMG_5460.JPG
    47.6 KB · Views: 119
Physics news on Phys.org
aruwin said:
Hello, please help me with this problem. The question is in the picture. I don't know how to normzalize the data. How to know which method should be used? I need two methods of normalization here. HELP!
Please teach me in detail.
View attachment 1755

Hi aruwin! :)

Two different normalization methods might be:
  1. Approximate with a normal distribution.
    Subtract the mean, and divide the result by the standard deviation.
  2. Scale to the same range.
    For instance by dividing each score by the highest one.
 
I like Serena said:
Hi aruwin! :)

Two different normalization methods might be:
  1. Approximate with a normal distribution.
    Subtract the mean, and divide the result by the standard deviation.
  2. Scale to the same range.
    For instance by dividing each score by the highest one.
Thanks for replying but could you please tell me why do you pick those two methods? And tell me how to use them.
 
aruwin said:
Thanks for replying but could you please tell me why do you pick those two methods? And tell me how to use them.

Well, we need to combine the different categories numerically.
For that they have to be "normalized", that is, they need to have a similar range.
I'm just mentioning 2 methods to do it.

How to use it?
Well, for method 1, do you know how to calculate a mean? And a standard deviation?
And for method 2, what do you get if you divide each price by the highest price?