Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

Q.b

1. Total Sum of Sales - 10032628.9
2. Average of Sales - 3553.88907
3. Standard Deviation of Sales - 1841.86511
4. Variance of Sales - 3392467.07
5. Maximum Sales - 14082.8
6. Minimum Sales - 482.13

Q.c In worksheet

Q.d In worksheet ( sales data ) in data tab

Q.e In worksheet

Q.f In worksheet ( sales data )

Q.g Sheet 5

Q.h in woeksheet

Q.i In worksheet

Q.j In worksheet ( sales data )