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 > About Continuous scale

About Continuous scale

By default Analyse-it assumes variables are measured on a continuous scale. Continuous scale is sometimes further sub-divided into ratio and interval scales, but Analyse-it does not distinguish these scales as they rarely affect the choice of statistical test.

Continuous observations should be entered on the worksheet as numeric values. Excel formulas can be used to calculate observations or transform the observations of another variable. An Excel Number format should be applied to the cells containing the observations to aid presentation and help Analyse-it determine the precision to which statistics based on the variable will be presented (see Setting observation precision).

IMPORTANT  When Analyse-it reads the observations of a variable it gets the full-precision numeric value stored in the cell, rather than using the value as displayed.



Add to: del.icio.us del.icio.us | digg it! | Stumble upon

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.