Run EDA (Exploratory Data Analysis)

Overview

Exploratory Data Analysis (EDA) in DataStripes provides instant insights into your data, helping you understand distributions, spot anomalies, and identify relationships between variables—all without leaving your spreadsheet.

Running EDA

1. Right-click a column header in your sheet.

2. Select EDA Analysis from the context menu.

3. A dedicated modal will appear with a statistical report, including:

   • Mean, median, and standard deviation

   • Distribution histogram

   • Outlier detection (IQR and Z-score methods)

   • Correlation with other columns

   • Data completeness and missing value analysis

Advanced EDA Features

• Interactive Charts: Hover over histograms and scatter plots for detailed tooltips.

• Correlation Matrix: See how your selected column relates to all other numeric columns.

• Export EDA Report: Download the analysis as a PDF or image for sharing.

• Custom Ranges: Run EDA on filtered or selected data ranges for focused analysis.

Interpreting Results

• Use the histogram to spot skewness or multimodal distributions.

• Outlier detection highlights values that may need review or cleaning.

• High correlation values suggest strong relationships—use these for further analysis or dashboarding.

Tips & Best Practices

• Run EDA before building dashboards or running models to understand your data quality.

• Use EDA to validate data after import or transformation.

• Combine EDA with custom formulas for deeper insights.

Troubleshooting

• If EDA is unavailable, check that your column contains numeric data.

• For very large datasets, EDA may sample data for performance.

EDA in DataStripes is designed for speed and clarity—use it often to keep your data analysis on track.