# 16.12 Normalize

## Description There are two user-interface tools that normalize data; one for worksheet data and one for plotted data. The output from both is similar and both are documented in this topic. For specific information, consult the Reference pages for these two X-Functions:

##### To Normalize Your Data
1. When a worksheet is active, click Analysis: Mathematics: Normalize Columns...

or

1. When a graph window is active, click Analysis: Mathematics: Normalize Curves...

## Dialog Options

Recalculate Controls recalculation of analysis results None Auto Manual For more information, see: Recalculating Analysis Results Define your input data. For help with range controls, see: Specifying Your Input Data Divided by a Specified Value Divide the column or the curve by the User Defined Value (see below). Normalize to [0, 1] Normalize data to the range 0 to 1. Normalize to [0, 100] Normalize data to the range 0 to 100. Z Scores (standardize to N(0, 1)) Normalize data to the standard normal distribution. Divided by Max Divide the column or curve by the dataset maximum value. Divided by Min Divide the column or curve by the dataset minimum value. Divided by Mean Divide the column or curve by the dataset mean value. Divided by Median Divide the column or curve by the dataset median value. Divided by SD Divide the column or curve by the dataset standard deviation. Divided by Norm Divide the column or curve by the dataset norm. Divided by Mode Divide the column or curve by the dataset mode. Divided by Sum Divide the column or curve by the dataset sum. Use Reference Plot / Use Reference Column Normalize input data to condition specified by the Normalize To list (see below). Divided by Reference Cell Divide the column by a reference cell value. Normalize to Point Picked from Graph Divide the curve by a point picked from a curve. Enter a value. Use when Normalize Methods = Divided by a specified value. Name a worksheet column or reference plot. Used when Normalize Methods = Use Reference Column or Use Reference Plot: Min: Normalize input by setting dataset min to that of reference column/plot. Max: Normalize input by setting dataset max to that of reference column/plot. Mean: Normalize input by setting dataset mean to that of reference column/plot. Median: Normalize input by setting dataset median to that of reference column/plot. Sum: Normalize input by setting dataset sum to that of reference column/plot. For information on methods, see the Algorithm section, below. Divide the worksheet column by the cell value. Launches the Data Reader tool for picking a point on a curve. X-value of point picked with the Data Reader. Y-value of point picked with the Data Reader. Row index number of point picked with the Data Reader. Direct output results. For help with the range controls, see: Output Results.

## Algorithm

For algorithm specifics, see the documentation for the respective X-Functions in the Origin X-Function Help file: