Information Technology IT – 17 Data analysis and visualization | e-Consult
17 Data analysis and visualization (1 questions)
Login to see all questions.
Click on a question to view the answer
Question 1: Total Students per Department
Pivot Table Layout:
- Rows: Department
- Values: Count of Students (ensure the 'Count of Students' field is selected)
Chart Type: A bar chart is suitable. The department names will be on the X-axis and the number of students will be on the Y-axis. This allows for a direct comparison of enrollment numbers between departments.
Question 2: Distribution of Students by Year within Department
Pivot Table Layout:
- Rows: Department
- Columns: Year of Study
- Values: Count of Students
Chart Type: A stacked bar chart is appropriate. Each bar will represent a department, and the segments within each bar will represent the number of students in each year of study. This visually shows the proportion of students in each year within each department.