Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
(b)
| Question:b | |
| i. Total Sum of Sales | =SUM(E2:E2824) |
| ii. Average of Sales | =AVERAGE(E2:E2824) |
| iii. Standard Deviation of Sales | =STDEV(E2:E2824) |
| iv. Variance of Sales | =VAR(E2:E2824) |
| v. Maximum Sales | =MAX(E2:E2824) |
| vi. Minimum Sales | =MIN(E2:E2824) |
(h)
| Question:b | |
| i. Total Sum of Sales | =SUM(E2:E2824) |
| ii. Average of Sales | =AVERAGE(E2:E2824) |
| iii. Standard Deviation of Sales | =STDEV(E2:E2824) |
| iv. Variance of Sales | =VAR(E2:E2824) |
| v. Maximum Sales | =MAX(E2:E2824) |
| vi. Minimum Sales | =MIN(E2:E2824) |