Home |
Search |
Today's Posts |
#1
|
|||
|
|||
normalizing data
I am in the process of normalizing test results in my school district. I
have roughly 250 test scores which I want to norm. I am relatively new to excel but many have suggested that I use this program to do the statistical work for me. Any and all help will be appreciated. |
#2
|
|||
|
|||
There are plenty of different ways of 'normalizing' data - the classic is
IQ, where the mean is forced to be 100, and one standard deviation is set to 15 points. (Different tests differ in how they assign the standard deviation.) Or you could normalize by dividing by the raw score by the population mean. Or... Tell us how you want to normalize and then we can help you more. HTH, Bernie MS Excel MVP "4gokycats" wrote in message ... I am in the process of normalizing test results in my school district. I have roughly 250 test scores which I want to norm. I am relatively new to excel but many have suggested that I use this program to do the statistical work for me. Any and all help will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Normalizing data formula? | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel |