Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
a. & g. & i. & j.)- Excel sheet is attached Below.
b. Excel sheet is attached Below.
| TOTAL SUM OF SALES | $10,032,628.85 |
| AVERAGE OF SALES | $3,553.89 |
| STANDARD DEVIATION O FSALES | $1,841.87 |
| VARIANCE OF SALES | $3,391,265.34 |
| MAXIMUM SALES | $14,082.80 |
| MINIMUM SALES | $482.13 |
c. Excel sheet is attached Below.
d. Excel sheet is attached Below.
e.
f. Excel sheet is attached Below.
h. Excel sheet is attached Below.