Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
q)b
| products | sum of total | avarage sales | standard deviation of sales | variance of sales | maximum sales | minimumsales |
| Motorcycles | 1166388.3 | 3523.83184 | 2203.117425 | 4853726.39 | 11886.6 | 651.8 |
| Classic Cars | 3919631.7 | 4053.39365 | 2203.117425 | 4853726.39 | 12001 | 640.05 |
| Trucks and Buses | 1127789.8 | 3746.8101 | 2203.117425 | 4853726.39 | 8844.12 | 482.13 |
| Vintage Cars | 1903166.8 | 3135.36547 | 2203.117425 | 4853726.39 | 14082.8 | 541.14 |
| Planes | 975003.57 | 3186.28618 | 2203.117425 | 4853726.39 | 10066.6 | 875.91 |
| Ships | 714437.13 | 3053.15013 | 2203.117425 | 4853726.39 | 6960.48 | 1089.36 |
| Trains | 226243.47 | 2938.22688 | 2203.117425 | 4853726.39 | 8977.05 | 972.4 |