How to normalize data in Excel

View detailed instructions here: spreadcheaters...

[@ashnour]

I've been struggling with t-tests, a suggestion was made to normalize the data which brought me here. I'll have to say that your explanation is what actually made me to realize the initial concepts delivered by the previous tutors.

[@Gayani01]

Your explanation is very clear and simple. Thank you.

[@mark91345]

Very nice, concise explanation of normalization (how to normalize).

[@alialmuhanna4938]

This was straightforward. Thank you so much.

[@Mirchi_007]

How to convert it back

[@Mirchi_007]

It if we have normalised data how to convert it to real data ?

[@98HappyCupcake]

If you have many data sets how do you do then? Does it work if you add the " min" together and the "max" together from each data set

[@abhishekchakraborty7802]

Hearty Thanks Madam for your short & crisp explanation of the topic. Is there any way to do the vice-versa i.e to convert normalised data into actual data? If so, kindly explain. Regards

[@joshuanyoni5378]

hiya. thanks for the vid. what do we do if there's missing data for the standard normal

[@sowuchi5788]

die ig idk

[@jamilusalisu3293]

Can I please normalize my data before using in response surface methodology(RSM)

[@mounaouarhi3039]

Thank, did we normilize the data that already betwen 0 and 1?

[@hobelarge6389]

yes, it's relative to 0 and 1, not literally the values. a normal distribution normalizes a data set by how much it varies about it's mean on a scale from 0 to 1 or -1. it's to compare and standardize measurements that may have been taken with different scales/tools. so if a data set already lies between 0 and 1, it doesn't necessarily mean it's normalized

[@mounaouarhi3039]

@@hobelarge6389 thank you

[@shatabdisinha6779]

LIFE SAVER THANKS MAM

[@TheArun1111]

It is not working with negative values

[@stefanstuffin]

Perfect video

[@BongaLovesJesus]

Thanks

[@spreadcheaters4997]

Welcome

[@sowuchi5788]

MEEEOOOOOOWWWWWWWW