I will do data analysis and future forecasting for your business

Pakistan

I speak Urdu, English

Excel Solutions That Work

I provide high-quality services tailored to each client’s unique needs. Whether it’s managing large datasets, building dynamic formulas, or designing clean and interactive reports, I ensure precision,...
About this Gig

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

Technology:

Excel

Analysis type:

Statistical analysis

Expertise:

Business Insights

Trends

Prediction

Statistics

Programming language:

Other

My Portfolio