# Formulas for Table Chart

## Formulas for Table Charts

Here on this page you will learn about the Formulas of Table chart. Data Interpretation problems are based on tables are common in competitive exams.

## Formulas for Table Chart

Table charts become even more powerful when you incorporate mathematical formulas. Here are several ways to use formulas effectively within table charts:

• Basic Arithmetic Operations:
• Summation: Use the SUM formula to calculate the total of a column or row by adding up the values in individual cells.
• Averages: Compute the average of a set of values within a column or row using the AVERAGE formula.
• Subtraction and Multiplication: Perform subtraction and multiplication operations as needed to derive new values based on existing data.
• Statistical Analysis:
• Standard Deviation: Calculate the standard deviation of a dataset using the appropriate formula to understand the data’s dispersion.
• Percentages: Use formulas to express values as percentages of a whole, often helpful for comparing proportions.
• Conditional Formulas:
• IF Statements: Apply conditional formulas to perform actions based on specific conditions. For example, highlight cells that meet certain criteria or perform calculations only when certain conditions are met.
• Date and Time Calculations:
• Date Differences: Compute the difference between two dates to track durations or analyze time-related data.
• Date Functions: Utilize date functions to extract specific components (e.g., year, month, day) from date and time values.

### Formulas for Table chart

• The boxes of the table consist of different types of information such as marks of a student, income of a company, production of some firm, expenditure on different items and so on.
• Generally the first row and column of the table denote the titles.
• The level of questions in tables may be higher or lower as compared to the other form of graphs. This is largely dependent upon the data given in the table and the way questions are framed.

Formulas are the backbone of effective data analysis and visualization within table charts. By leveraging mathematical calculations, you can transform your table charts into dynamic tools for making data-driven decisions. Whether you’re working with financial data, scientific observations, or any other dataset, understanding how to apply formulas effectively can unlock the full potential of table charts.

### Related Banners

Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription

### Questions and Answers for Table chart

The following table gives the sales of batteries manufactured by a company over the years.

Number of Different Types of Batteries Sold by a Company Over the Years (Numbers in Thousands)

 Year 4 AH 7 AH 32 AH 35 AH 55 AH Total 1992 75 144 114 102 108 543 1993 90 126 102 84 126 528 1994 96 114 75 105 135 525 1995 105 90 150 90 75 510 1996 90 75 135 75 90 465 1997 105 60 165 45 120 495 1998 115 85 160 100 145 605

### Question 1.

What was the approximate percentage increase in the sales of 55AH batteries in 1998 compared to that in 1992?

(A) 28%

(B)  31%

(C) 33%

(D) 34%

Explanation:

Required percentage
 = (145 – 108) x 100 % 108
= 34.26%
34%.

### Question 2.

 The total sales of all the seven years is the maximum for which battery?

(A) 4 AH

(B) 7 AH

(C) 32 AH

(D) 35 AH

Explanation:

The total sales (in thousands) of all the seven years for various batteries are:

For 4AH = 75 + 90 + 96 + 105 + 90 + 105 + 115 = 676

For 7AH = 144 + 126 + 114 + 90 + 75 + 60 + 85 = 694

For 32AH = 114 + 102 + 75 + 150 + 135 + 165 + 160 = 901

For 35AH = 102 + 84 + 105 + 90 + 75 + 45 + 100 = 601

For 55AH = 108 + 126 + 135 + 75 + 90 + 120 + 145 = 799.

Clearly, sales are maximum in case of 32AH batteries.

### Question 3.

In case of which battery there was a continuous decrease in sales from 1992 to 1997?

(A) 4 AH

(B) 7 AH

(C) 32 AH

(D) 37 AH

Explanation:

From the table it is clear that the sales of 7AH batteries have been decreasing continuously from 1992 to 1997.

### Question 4.

What is the difference of average of 35 AH and 55 AH batteries in all the years?

(A) 11

(B) 12

(C) 15

(D) 17

Explanation :

Total 35 AH batteries sold = 102+84+105+90+75+45+100 = 601

Average = 85.85

Total 55 AH batteries sold = 108+126+135+75+90+120+145 = 699

Average = 99.85

Difference of Averages = 99.85 – 88.85 = 11

### Question 5.

Calculate how much more or less batteries were sold in the year 1994 than in the year 1996?

(A) 25 % more

(B) 15.25 % more

(C) 10 % less

(D) 12.90 % less

Explanation :

Batteries sold in the year 1994 = 525

Batteries sold in the year 1996 = 465

Difference = 525 -465 = 60

% difference = (60 / 465) * 100

= 12.90 % less

## Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others