Divided by Norm Divide the column or curve by the dataset norm.
Divided by SD Divide the column or curve by the dataset standard deviation. Divided by Median Divide the column or curve by the dataset median value. Divided by Mean Divide the column or curve by the dataset mean value. Divided by Min Divide the column or curve by the dataset minimum value. Divided by Max Divide the column or curve by the dataset maximum value. Z Scores (standardize to N(0, 1)) Normalize data to the standard normal distribution. Normalize to Normalize data to the range 0 to 100. Normalize to Normalize data to the range 0 to 1. If check this option, it will get the statistics quantity from the composite dataset, then divide two columns data by max value in two columns.ĭivided by a Specified Value Divide the column or the curve by the User Defined Value (see below). If not check this option, it will divide Col(A) data by max value in Col(A), and divide Col(B) data by max value in Col(B). This option is not available when Normalize Methods is Divided by a Specified Value, Divided by Reference Cell and Normalize to Point Picked from Graph.įor example, when you can select two columns (Column A and B) as input datasets, and hope to divide data by the max value. Specify whether to treat all input dataset as one composite dataset. When a graph window is active, click Analysis: Mathematics: Normalize Curves.Ĭontrols recalculation of analysis resultsįor more information, see: Recalculating Analysis Resultsįor help with range controls, see: Specifying Your Input Data.When a worksheet is active, click Analysis: Mathematics: Normalize Columns.The cnormalize dialog box acts on plotted data.The rnormalize dialog box acts on worksheet data.For specific information, consult the Reference pages for these two X-Functions: The output from both is similar and both are documented in this topic. There are two user-interface tools that normalize data one for worksheet data and one for plotted data.