RockWorks | Utilities | Statistics | Normalize
This program is used to read a single column of values from the datasheet and normalize the values so that they range between two user-specified values. The resulting data are listed in a new datasheet column. Normalizing data values to range between the same minima and maxima can be helpful if you are analyzing multiple measurements whose values and ranges are different.
Menu Options
Step-by-Step Summary
Menu Options
- Input Column, Original: Click on this item, along the left side of the Normalize Data window, to select the name of the column in the current datasheet that contains the data to be normalized.
- Output Column, Normalized: Select from the drop-down list the name of the column in the current datasheet where the normalized data are to be stored. Be warned that any existing data in the column will be overwritten.
- New Data Range:
- Minimum Value, Maximum Value: Click on these items to type in the minimum and maximum values for the range within which the original data will be normalized. This establishes the upper and lower limits for the normalized data. Negative numbers can be used.
- Decimal Places: Click to the right to type in the number of decimal places to record in the normalized values.
Step-by-Step Summary
- Access the RockWorks Utilities program tab.
- Enter/open/import your data into the datasheet. Be sure that the file contains at least one column of data to be read and normalized.
- Select the Statistics | Normalize menu option.
- Enter the requested menu settings, described above.
- Click the Process button when all of this information has been entered.
The program will normalize (rescale) the samples in the source column to lie within the specified range. It will store the normalized data in the selected column in the datasheet.
Back to Statistics Menu Summary
RockWare home page