Analyse-it
You are viewing part of the Analyse-it for Microsoft Excel user-guide. When you have read this topic we recommend you view contents of the user-guide or you can read more about Analyse-it, our statistical analysis software for Microsoft Excel.
Topic: Using Analyse-it > Preparing data in Excel > Defining variables > Setting measurement scale for a variable

Setting measurement scale

By default Analyse-it assumes all variables are measured on a continuous scale. In most cases the default suffices and saves from having to set the measurement scale for each variable, but scale will need to be set for nominal or ordinal variables.

To view or change the measurement scale of a variable:

  1. Select a cell in the range containing the variable.
  2. Click Variable on the Analyse-it tab/toolbar to show the Variable properties dialog box.
  3. Select None (the variable will be unavailable in analysis), Nominal, Ordinal or Continuous to set the Measurement scale.
  4. Click OK.

Part of the Analyse-it for Microsoft Excel user guide. For more information about Analyse-it, the statistics add-in for Microsoft Excel, or to download a free 30-day trial please visit http://www.analyse-it.com/. © Analyse-it Software, Ltd. Analyse-it® is a registered trademark. Microsoft® Excel® is a registered trademark of Microsoft.