Project: Student Performance & Sales Analysis
Create a workbook with two sections.
Part A — Student Performance
|
Student |
English |
Maths |
Science |
Total |
Average |
Rank |
|
Amit |
78 |
85 |
72 |
|||
|
Neha |
65 |
92 |
88 |
|||
|
Rahul |
90 |
76 |
84 |
|||
|
Priya |
95 |
89 |
91 |
|||
|
Simran |
55 |
68 |
62 |
Required Formulas
Total
=SUM(B2:D2)
Average
=AVERAGE(B2:D2)
Rank
=RANK.EQ(E2,$E$2:$E$6,0)
Highest Total
=MAX(E2:E6)
Lowest Total
=MIN(E2:E6)
Part B — 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% |
Calculate:
- Total employees
- Average sales
- Maximum sales
- Minimum sales
- Number of Sales employees
- Average Sales department sales
- Number of employees with sales above ₹90,000
- Top 3 sales values
- Sales ranking
Final Challenge
Create a Statistical Analysis Dashboard containing:
- Average
- Median
- Highest
- Lowest
- Total count
- Department count
- Conditional count
- Conditional average
- Employee ranking
- Top 3 values