How To: Normalize and Standardize Data in Excel

This video demonstrates how to normalize and standardize data in Excel using both manual formula entry and alternatively using the STANDARDIZE function. Standardized data is created and used to compare stock and bond market relative daily movements.

[OzScout]

Excellent explanation! Clear & concise! - Thankyou from Oz!

[kevinq]

best video on data normalization, to the point

[jdosses]

Awesome! Very useful, finally understood the concepts

[Artharjan]

Learnt a lot through this video...thanks so much...God bless you.

[siktrading]

Excellent video & fantastic explanation!!! Thank you very much!!!

[ssgstatswithexcel]

Thanks a lot sir. Beyond doubt learnt a lot.

[dheeraj]

Absolutely Mesmerizing, Thanks a lot for such an amazing description

[michaelabghari]

Great analysis, I personally questioning return of BRK shares under performing compare to spy, he benefiting his fame,

[Geek]

Use F4 key to select "Absolute Cell Reference" :)

[ireneantillano]

Hi, thank you for your video, it was very informative and useful. I have a problem that I am trying to resolve... Maybe you can help me. I have historical data of balances on my accounting books. I am trying to figure out what the "normal balance range" should be for each account, for example the account should have a balance between -100, 000 and 200, 000, this way I will have an interval that will trigger further investigation of the balance in case it is ever outside this range. The first thing I did was standardize the data, but now I need to return to the original values to construct the "normal range", how can you do this?

[diaconescutiberiu]

Q: why did you normalise & standardise with the % change and not actual (closing) data? Is there a reason to chose one over the other?

[mohamed.montaser]

the formula u showed for STANDARDIZE is the formula for z-score

[KoldFiyure]

When you said "Lets go ahead and populate that down to the bottom..." what did you hit to make the numbers autofill down like that?

[datacool]

Hello sir, I'm confused about the norm.dist and standardize functions, as far as I know the norm.dist function is also to find zscore, but doesn't standardization also use the same formula to find zscore? Then why are the results different? CMIIW

[xerxessultanian]

thank you for real. i wonder if there are some zero price data or some messing price data, must we delete these days or make them somehow? i hear there is a approach and we can make five days data by running a geometric codes in mathlab but i don't know how...? i wonder if you know more details about what i'm talking about...

[ABC]

Can you normalize promotion type that has qualitative info ?

[tinashemukota]

How do you deal with negative numbers after calculating the percentage change? All your negative numbers are in brackets and represented as positive.

[mahamsaleem]

hy if i have a likert scale questionaire response like high moderate low and no how can i normalized in values to calculate minimum and maximum plz reply

[CxJr]

How did you get the max and min values

[dara_]

how did u get brackets instead of - symbol