🧩 Data & Tables

Structured data cleanup, analysis, transformation, and table workflows

Analyze data skewness to measure the asymmetry of probability distribution and identify data patterns

Comprehensive standard deviation analysis with variability assessment, confidence intervals, and practical insights

Generate interactive pivot tables from CSV/JSON data with customizable row, column, and value field configurations

Scale and normalize features using various methods for machine learning preprocessing and data standardization

Comprehensive data distribution analysis with normality tests, outlier detection, and goodness-of-fit assessments

Comprehensive missing value detection, analysis, and intelligent handling with multiple strategies

Perform one-way Analysis of Variance (ANOVA) to compare means across multiple groups

Comprehensive normality testing using multiple statistical methods

Analyze data kurtosis to measure the "tailedness" of distribution and detect heavy-tailed or light-tailed patterns

Calculate weighted averages with various methods including weighted mean, median, variance and sensitivity analysis

Generate simple VBA macros for Excel automation

Build Excel formulas with common functions and operators