Data is uploaded to the Wistats application in Excel format. Preparing and cleaning your data beforehand is essential to ensure accurate analysis.

📋 Preparation Guidelines

• For example, in the gender column, replace values such as 0 and 1 with male and female.
• Correct incorrect entries in cells or leave them blank if necessary.
• Try to define categorical variables with two distinct options — this will make your statistical analysis easier to interpret.

💡 Tip: Ensure data type consistency (text, number, date, etc.) across cells. This prevents potential calculation or parsing errors in Wistats analysis modules.

🚀 Data Upload Process

1. Click on the Project menu.
2. In the upper right corner, click New Project or select your Credit.
3. Enter the project name.
4. Select and upload your Excel file.

🧠 System Analysis

• The system automatically classifies your data as categorical or numerical.
• It detects unusually high or low values.
• Automatically determines the most suitable data types.
• You need to correct incorrectly recognized fields.
• Sometimes numeric data may actually represent categorical values — in that case, you should adjust it manually.

🛠️ Edit Screen

The system automatically opens the Edit Screen, where data types are categorized as follows:

• Categorical data: select
• Integer data: integer
• Decimal data: float
• Date or time data: datetime
• Other data: text

💾 Saving

If you made any edits, click the Save button. If no edits are needed, you can simply close the screen.

You can create a new column by defining rules based on other columns.

1. Click the New Column button on the column list.
2. Edit the name of your new column.

📘 Defining the Column Type

Select the appropriate data type according to the kind of data your new column will contain:

• select → if it will contain categorical options
• integer → if it will contain whole numbers
• float → if it will contain decimal numbers
• datetime → if it will contain date or time data
• text → for all other cases

🎯 Creating Category Options

If you choose the select type, you can add new options in the Option List.

Click the ⭐ icon next to an option to define a rule using other columns.

⚙️ Generating Column Data with Functions

1. Set the Manual Column Design Type parameter to “Column Rules and Functions.”
2. In the newly visible Column Rules and Functions section, click the ➕ icon to add your function.
3. Click the Function button to view all available functions, search by name, and insert examples automatically.
4. In functions, add the column’s numeric ID after the col expression to specify which column’s value should be used in the calculation.

After defining your columns, click the Save button. The system will automatically calculate and generate cell data. If you edit and save the functions again, recalculations will be performed automatically.

---

🧮 Example: Creating an Age Group Column

Let’s create a new column that categorizes age groups based on the Age column. Our categories will be:

• Over 50 years old
• Under 50 years old

🔹 Method 1: Using Option Rules

1. Set the column type as select.
2. In the Column Options section, define your category options and rules.
3. Click the Save button.
4. Switch to the dataset view to review the generated results.

🔹 Method 2: Using Column Rules and Functions

1. Again, set the column type as select.
2. In the function field, write your category expression inside single quotes.
3. Create your first function and define its rule, then duplicate and adjust it for the second rule.

🧠 How Function Logic Works

• The system executes functions sequentially.
• It continues execution until the last function that returns a positive (True) result.
• If a text string is written inside the function without a defined rule, that text is directly written into the cell.