Preparing data for analysis

Analyse-it takes your data for analysis directly from an Excel worksheet. It also provides commands to arrange and structure your data ready to analyze. In addition, you can use the built-in Excel commands to transform, sort, and filter data.

• Datasets
  A dataset is a range of contiguous cells on an Excel worksheet containing data to analyze.
• Variables
  A variable is an attribute of an object. The value of a variable can vary from one thing to another.
• Measurement scales
  Five different scales are used to classify measurements based on how much information each measurement conveys.
• Missing values
  Missing values occur when no data is recorded for an observation; you intended to make an observation but did not. Missing data are a common occurrence and can have a significant effect on the statistical analysis.
• Case and frequency form data
  Most data are available in case form with data for each sampling unit. Sometimes data are not available for each unit but are already summarized by counting the frequency of occurrences of each value, called frequency form data.