Dataset scale: 1,200 rows analyzed, totaling 1.26M in total price, averaging 1.1K per row (medianDataset scale: 1,200 rows analyzed, totaling 1.26M in total price, averaging 1.1K per row (median
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Abeeha 's avatar
Abeeha saeed
• Jul 10
Dataset scale: 1,200 rows analyzed, totaling 1.26M in total price, averaging 1.1K per row (median 823.62), with a max single value of 3.5K and a min of 11.39.
Anomaly detection: The audit panel flags 28 statistical outliers (beyond 2.5 standard deviations), with the most extreme case highlighted by row number, value, and Z-score a nice touch for surfacing data-quality issues rather than just describing the distribution.
Correlation and concentration: It reports a strong positive correlation (r = 0.72) between unit price and total price (expected, but good to confirm), and flags that coupon usage is concentrated FREESHIP accounts for 26.5% of coupon codes, with an HHI score suggesting a lack of diversity there.
Data quality flag: A missing-values warning notes CouponCode is 26% empty, which is a meaningful caveat any coupon-based segmentation should be read with that gap in mind.
Trend behavior: The time series shows a mild downward drift, confirmed quantitatively by a "temporal shift" note (7.2% contraction in average total price between the first and second half of the date range).
Category breakdown: Chair, Printer, and Laptop lead in total value contribution, with Phone trailing fairly even spread across the seven product types rather than one runaway category.
Forecasting module: The standout addition here is the "Advanced Multi-Model Projection Forecast" panel a linear regression trend (y = -0.11x + 1120.22) projecting values forward to a target of 987.17 by 03/07/2025, with a configurable model selector and forecast horizon (periods slider), plus a caveat about 95% confidence intervals and seasonality risk.
StatisticsMicrosoft Excel
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started