Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
b.
| SUM OF SALES | 10032628.9 |
| AVERAGE OF SALES | 3553.88907 |
| STANDARD DEVIATION OF SALES | 1841.86511 |
| VARIANCE OF SALES | 3392467.07 |
| MAXIMUM OF SALES | 14082.8 |
| MINIMUM OF SALES | 482.13 |
h.
| TOTAL SALES OF ALL SHIPPED | 9291501.08 |
| TOTAL SALES OF ALL CANCELLED | 194487.48 |
| TOTAL SALES OF ALL DISPUTED | 72212.86 |
| TOTAL SALES OF ALL IN PROCESS | 144729.96 |
| TOTAL SALES OF ALL ON HOLD | 178979.19 |
| TOTAL SALES OF ALL RESOLVED | 150718.28 |