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
- Data Columns
- Input, Original Column: Select the name of the column in the current datasheet that contains the data to be normalized.
- Output, Normalized Column: Select 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.
- Range: Click here to establish the upper and lower limits for the normalized data. Negative numbers can be used.
- Minimum Value: Type in the minimum value for the range within which the original data will be normalized.
- Maximum Value: Enter the maximum value for the range within which the original data will be normalized.
- Decimal Places: Click to the right to type in the number of decimal places to record in the normalized values.
- Access the RockWorks Datasheet 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 Utilities | Stats | 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