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

b-i.Total Sum of Sales=10032628.85

ii.Average of Sales=3553.88907190932

iii.Standard Deviation of Sales=1841.86510574018

iv.Variance of Sales=3392467.0677433

v.Maximum Sales=14082.8

vi.Minimum Sales=482.13

c- answer available in sheet "c_ques_pivot"

e-answer available in sheet "e_ques_pivot"

f-done in work sheet

g-done in work sheet

f-=SUMIF(G2:G2824,"Shipped",E2:E2824)=9291501.08000001

"Cancelled" =194487.48

"Disputed" =72212.86

"In Process" =144729.96

"On Hold" =178979.19

i-done in work sheet

j-done in work sheet