This lesson combines statistical functions to analyze real-world datasets.
Example — Sales Analysis
|
Employee |
Department |
Sales |
Attendance |
|
Amit |
Sales |
85000 |
95% |
|
Neha |
HR |
45000 |
92% |
|
Rahul |
Sales |
120000 |
88% |
|
Priya |
Sales |
95000 |
96% |
|
Simran |
HR |
55000 |
85% |
|
Karan |
Sales |
135000 |
90% |
Questions to Analyze
Total number of employees
=COUNTA(A2:A7)
Highest Sales
=MAX(C2:C7)
Lowest Sales
=MIN(C2:C7)
Average Sales
=AVERAGE(C2:C7)
Number of Sales employees
=COUNTIF(B2:B7,”Sales”)
Average Sales of Sales department
=AVERAGEIF(B2:B7,”Sales”,C2:C7)
Number of Sales employees with sales above ₹90,000
=COUNTIFS(B2:B7,”Sales”,C2:C7,”>90000″)
Practice
Answer at least 10 business questions from the dataset using statistical functions.