Tables & Charts

Derivation (brief)

Bar graphs and line graphs are fundamental tools in data visualization. Their purpose is to present complex numerical data in an easily digestible, visual format, making trends, comparisons, and distributions immediately apparent. Bar graphs are excellent for comparing discrete categories, while line graphs are ideal for showing trends over continuous intervals, typically time. They 'derive' their utility from the human brain's ability to quickly process visual patterns rather than raw numbers, significantly speeding up data comprehension compared to raw tables.

Advanced Examples

Question: A double bar graph shows the import and export (in crores) of a country from 2015-2019. * 2015: Import 100, Export 70 * 2016: Import 120, Export 100 * 2017: Import 150, Export 130 * 2018: Import 140, Export 160 * 2019: Import 160, Export 150 In which year was the trade deficit (Import - Export) the highest?

Solution:

1. Calculate Trade Deficit for each year:
   • 2015: 100 - 70 = 30 crores
   • 2016: 120 - 100 = 20 crores
   • 2017: 150 - 130 = 20 crores
   • 2018: 140 - 160 = -20 crores (This is a trade surplus, not a deficit)
   • 2019: 160 - 150 = 10 crores
2. Identify Highest Deficit: The highest positive deficit is 30 crores. Answer: The trade deficit was highest in 2015.

Variation Types

• Histograms: Similar to bar graphs but represent the frequency distribution of continuous data, where bars touch to indicate continuity. Used for ranges of values.
• Frequency Polygons: Often derived from histograms, these connect the midpoints of the top of each bar to show the shape of the distribution, useful for comparing multiple distributions.
• Stacked Bar Graphs: Each bar is divided into segments representing different categories, showing the composition of a total and how it changes across different main categories.
• Multiple Line Graphs: Show trends for several categories simultaneously on the same axes, facilitating direct comparison of their movements and interactions over time.

Time-Saving Methods

1. Mental Math: Practice basic arithmetic to avoid writing down every step, especially for sums and differences. Look for numbers that add up easily (e.g., pairs that sum to 10, 100).
2. Ratio Method for Percentages: Instead of (Change/Original)*100, if a value doubles, it's 100% increase. If it becomes 1.5 times, it's 50% increase. If it reduces to half, it's a 50% decrease. This saves calculation time.
3. Scanning for Max/Min: For questions asking for maximum or minimum values, quickly scan the graph for the highest/lowest point or bar without reading all exact values unless a tie-breaker is needed.
4. Break Down Complex Calculations: For sums or averages of many numbers, group numbers that are easy to add (e.g., numbers ending in 0 or 5) or use a reference point (e.g., assume an average and calculate deviations).

Derivation (brief)

Table DI doesn't involve complex derivations but rather the application of fundamental arithmetic and proportional reasoning to structured data. The core formulas for percentage, ratio, and average are basic mathematical concepts adapted for data analysis. For instance, percentage change is simply expressing the absolute change as a fraction of the original value, then multiplying by 100 to convert to a percentage. The 'derivation' here is more about understanding why these operations are performed on data to extract meaningful insights.

Advanced Examples

Consider a scenario where you have two tables: Table 1: Number of Employees in Departments (2022)

Table 2: Average Salary (in thousands INR) per Employee (2022)

Question: What is the total expenditure on salaries for the IT department in 2022?

Solution:

1. From Table 1, IT department has 120 Male employees and 80 Female employees.
2. From Table 2, Average salary for Male in IT = 90 (thousand INR), Female in IT = 85 (thousand INR).
3. Total salary for Male in IT = 120 * 90 = 10800 (thousand INR)
4. Total salary for Female in IT = 80 * 85 = 6800 (thousand INR)
5. Total expenditure for IT = 10800 + 6800 = 17600 (thousand INR) = 17,600,000 INR

Variation Types

Table DI questions can appear in several formats:

• Simple Tables: A single table showing data for different categories over time or across various attributes.
• Multi-Table Problems: Two or more related tables, where data from one table is needed to solve questions based on another (as shown in the advanced example).
• Table-cum-Chart: A table providing raw data, while a related chart (bar, pie, line) visually represents some aspect of that data, or vice versa. Questions might require integrating information from both.
• Missing Data Tables: Some cells might be intentionally left blank, requiring you to infer values based on given totals or relationships.
• Growth Rate/CAGR: Questions might involve calculating compound annual growth rate (CAGR) or simple year-on-year growth rates.

Time-Saving Methods

• Pre-computation (Selective): If a table is small and many questions ask for row/column totals or averages, quickly calculate and jot them down. Otherwise, compute only what's needed for each question.
• Visual Scan for Extremes: For "highest/lowest" questions, quickly scan rows/columns. Often, you don't need exact values, just relative comparison.
• Percentage Point vs. Percentage Change: Understand the difference. If a value goes from 20% to 25%, it's a 5 percentage point increase, but a ((25-20)/20)*100 = 25% percentage change.
• Digit Sum/Unit Digit: For large calculations, sometimes the unit digit of the answer or the sum of digits can help eliminate options.
• Break Down Complex Calculations: Instead of doing (120*90) + (80*85) in one go, break it into 120*90 and 80*85 and then add. This reduces error.
• Focus on the Question's Core: Identify exactly what is being asked. Is it a ratio, a percentage, an average, or a difference? This prevents unnecessary calculations.

Derivation (brief)

A circle represents a complete whole, which is universally measured as 360 degrees. In the context of data, this whole is also considered 100% of the total. Therefore, 100% of the data corresponds to 360 degrees. This fundamental equivalence (100% = 360°) allows for direct conversion: 1% = 3.6 degrees, and 1 degree = (100/360)% = (5/18)%. These ratios form the basis for all pie chart calculations.

Advanced Examples

Question: Two pie charts show the distribution of students in different streams (Arts, Science, Commerce). Chart 1 is for Boys (Total 1200), Chart 2 for Girls (Total 800). If 25% of Boys are in Science and 30% of Girls are in Science, what is the total number of students in Science, and what is the ratio of Boys to Girls in Science?

Solution:

1. Boys in Science: (25/100) * 1200 = 300 boys
2. Girls in Science: (30/100) * 800 = 240 girls
3. Total students in Science: 300 + 240 = 540 students
4. Ratio of Boys to Girls in Science: 300 : 240 = 30 : 24 = 5 : 4

This example demonstrates combining data from multiple pie charts, a common advanced scenario.

Variation Types

Pie charts can be presented in various ways:

1. Percentage-based Pie Charts: Each sector explicitly shows its percentage share. This is the most common and direct type.
2. Degree-based Pie Charts: Each sector explicitly shows its central angle in degrees. Requires conversion to percentage or direct use with 360°.
3. Value-based Pie Charts: Each sector shows an absolute value (e.g., number of students, amount of money). The total value is either given or needs to be calculated by summing all sector values. Percentages/angles are then derived from these values.
4. Nested Pie Charts: A larger pie chart with one of its sectors further broken down into a smaller, nested pie chart. This requires sequential calculations.

Time-Saving Methods

1. Focus on Ratios/Differences: Many questions ask for ratios or differences between sectors. Calculate the ratio/difference of percentages/angles first, then apply to the total if needed. For example, if asked for the difference in expenditure between Food (30%) and Rent (15%) from a total of ₹45,000, calculate (30-15)% = 15% of ₹45,000 directly, which is ₹6,750.
2. Use Options to Eliminate: Before detailed calculations, quickly scan the options. Sometimes, a rough estimate or a quick check of the last digit can eliminate several options.
3. Mental Math for Multiples: Recognize that 360 is divisible by many numbers (2, 3, 4, 5, 6, 8, 9, 10, 12, etc.). This helps in quickly simplifying fractions like 72/360 = 1/5, 90/360 = 1/4.
4. Avoid Unnecessary Conversions: If the question asks for the ratio of two sectors' central angles, and you have their percentages, simply use the ratio of percentages (e.g., 20% : 30% = 2:3). No need to convert to degrees first.