Skip to content

Quantum XL v18 Help

Data Types

Home / Statistical Tools / Data Types

Data Types¶

Excel does not enforce data types—users can enter text, numbers, dates, or any combination in any cell. For statistical analysis, however, data types matter. Quantum XL lets you specify the data type for each column to ensure accurate analysis.

In This Section¶

Data Types Details ¶

Learn about the five column data types (Numeric, Nominal, Count, Integer, DateTime), how Quantum XL automatically detects types, and what happens when you change a column's type.

DateTime Grouping ¶

When working with DateTime columns, you can group values by year, month, week, day, hour, minute, or second. Learn how DateTime grouping works and when to use each option.

Cyclical Grouping ¶

Learn how to group data by recurring time periods—such as all Mondays together or all Januaries regardless of year—using Excel formulas with the Nominal data type.