Normalizing Data

A frequent question for people first learning statistical procedures is how to normalize data.  Other terms for normalizing may include standardizing, scaling and centering (though the last two terms may mean something other than the first two terms).  In my field (literacy) many of my colleagues work with count data on text data and thus have a need for comparing across data sets.  Normalizing data is one means of accomplishing this.  A while back I wrote a guide for people in my field to help with normalizing data.  Though it was written for them it’s really a good guide for any statistics beginner.

The guide is broken into three parts:

  1. An introduction to normalizing text data  (if you don’t care about this skip on to section two)
  2. An explanation of the standard score formula (doing it by hand)
  3. A guide to doing normalization in excel (with pictures)

Normalizing Text  Data (Click Here)          ← good normalizing guide for anyone not just those who deal with text


1 Comment

Filed under Data, Transformation

One response to “Normalizing Data

  1. Hanna

    It was very useful, thanks 🙂

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s