Standardize dataset with high outliers Is there a better way to standardize a dataset with outliers than to normalized value (z-score) based on the mean and standard deviation? I am using the Excel STANDARDIZE function.
I have two datasets with huge outliers and I cannot remove them. Here is a summary of one of them.
Min. value: 0.29
Mean: 402,1
SD: 2222,89
Max. value: 23793
As can be noticed, I have a big range of values and all the lower values stay "hidden" by the highest ones.
What is the best way to standardize this dataset?


if it is one category of data then okay. Otherwise, you will use some robust statistics to overcome the problem like median, quartiles etc. Z-score will not be suitable as it is based on deviation from the mean.
