30a. Problems based on tables

 30. Problems based on tables, graphs, pie charts - step by step solution procedure and detailed explanation for each problem. Give me 10 examples for each variety of problem.

1. Problems Based on Tables

Tables organize data in rows and columns, making it easy to compare values across categories or time periods. Below are the 10 problems with full solutions.

Problem 1

Problem Statement:
The table below shows the number of cars sold by a dealership in four different models (A, B, C, D) over three months (January, February, March).

Month	Model A	Model B	Model C	Model D
January	50	30	20	10
February	60	40	25	15
March	70	50	30	20

Question: What is the total number of cars sold in March, and what percentage of the total sales in March does Model A represent?

Step-by-Step Solution:

• Understand the Data:
• The table shows car sales for four models (A, B, C, D) across three months.
• We need: (1) Total cars sold in March, (2) Percentage of Model A’s sales in March.
• Extract Relevant Data:
• March sales: Model A = 70, Model B = 50, Model C = 30, Model D = 20.
• Calculate Total Sales in March:
• Total = Model A + Model B + Model C + Model D
• Total = 70 + 50 + 30 + 20 = 170 cars.
• Calculate Percentage for Model A:
• Model A sales in March = 70.
• Percentage = (Model A sales / Total sales) × 100
• Percentage = (70 / 170) × 100 ≈ 41.176%.
• Rounded to two decimal places: 41.18%.
• Verify:
• Total: 70 + 50 + 30 + 20 = 170.
• Percentage: (70 ÷ 170) × 100 ≈ 41.176, confirms 41.18% when rounded.
• Present the Answer:
• Total cars sold in March: 170.
• Percentage of Model A: 41.18%.

---

Problem 2

Problem Statement:
Table: Monthly expenses (in $) for a household (Food, Rent, Utilities, Transport) for 2024.

Month	Food	Rent	Utilities	Transport
Jan	400	1000	150	200
Feb	420	1000	160	210
Mar	450	1000	170	220

Question: What is the total expense in February?

Step-by-Step Solution:

• Understand the Data:
• The table shows monthly expenses for four categories in 2024.
• We need the total expenses for February.
• Extract Relevant Data:
• February expenses: Food = 420, Rent = 1000, Utilities = 160, Transport = 210.
• Calculate Total Expenses:
• Total = Food + Rent + Utilities + Transport
• Total = 420 + 1000 + 160 + 210 = 1790.
• Verify:
• Recalculate: 420 + 1000 = 1420, 1420 + 160 = 1580, 1580 + 210 = 1790.
• Present the Answer:
• Total expense in February: $1790.

---

Problem 3

Problem Statement:
Table: Students’ scores in three subjects (Math, Science, English).

Student	Math	Science	English
A	85	90	88
B	78	82	80
C	92	95	90

Question: What is the average score of Student B?

Step-by-Step Solution:

• Understand the Data:
• The table shows scores for three students in three subjects.
• We need the average score for Student B.
• Extract Relevant Data:
• Student B scores: Math = 78, Science = 82, English = 80.
• Calculate Average:
• Average = (Math + Science + English) / Number of subjects
• Average = (78 + 82 + 80) / 3
• Sum = 78 + 82 = 160, 160 + 80 = 240.
• Average = 240 / 3 = 80.
• Verify:
• Sum: 78 + 82 + 80 = 240.
• Average: 240 ÷ 3 = 80.
• Present the Answer:
• Average score of Student B: 80.

---

Problem 4

Problem Statement:
Table: Sales (in units) of three products (P1, P2, P3) in two stores.

Store	P1	P2	P3
S1	100	150	200
S2	120	180	250

Question: What is the difference in P2 sales between S1 and S2?

Step-by-Step Solution:

• Understand the Data:
• The table shows sales of three products in two stores.
• We need the difference in P2 sales between S1 and S2.
• Extract Relevant Data:
• P2 sales: S1 = 150, S2 = 180.
• Calculate Difference:
• Difference = P2 sales in S2 – P2 sales in S1
• Difference = 180 – 150 = 30.
• Verify:
• Recalculate: 180 – 150 = 30.
• Present the Answer:
• Difference in P2 sales: 30 units.

---

Problem 5

Problem Statement:
Table: Temperature (°C) in four cities over three days.

Day	City A	City B	City C	City D
Day 1	20	22	18	25
Day 2	21	23	19	26
Day 3	22	24	20	27

Question: What is the average temperature in City C?

Step-by-Step Solution:

• Understand the Data:
• The table shows temperatures for four cities over three days.
• We need the average temperature for City C.
• Extract Relevant Data:
• City C temperatures: Day 1 = 18, Day 2 = 19, Day 3 = 20.
• Calculate Average:
• Average = (Day 1 + Day 2 + Day 3) / Number of days
• Sum = 18 + 19 + 20 = 57.
• Average = 57 / 3 = 19.
• Verify:
• Sum: 18 + 19 = 37, 37 + 20 = 57.
• Average: 57 ÷ 3 = 19.
• Present the Answer:
• Average temperature in City C: 19°C.

---

Problem 6

Problem Statement:
Table: Production (in tons) of three crops (Wheat, Rice, Corn) in 2023.

Crop	Q1	Q2	Q3	Q4
Wheat	500	600	550	620
Rice	400	450	420	480
Corn	300	350	320	400

Question: What is the total production of Rice in 2023?

Step-by-Step Solution:

• Understand the Data:
• The table shows quarterly production for three crops in 2023.
• We need the total production of Rice.
• Extract Relevant Data:
• Rice production: Q1 =领, Q2 = 400, Q2 = 450, Q3 = 420, Q4 = 480.
• Calculate Total Production:
• Total = Q1 + Q2 + Q3 + Q4
• Total = 400 + 450 + 420 + 480 = 1750.
• Verify:
• Sum: 400 + 450 = 850, 850 + 420 = 1270, 1270 + 480 = 1750.
• Present the Answer:
• Total production of Rice: 1750 tons.

---

Problem 7

Problem Statement:
Table: Employees’ salaries (in $) in four departments.

Dept	Emp1	Emp2	Emp3
HR	3000	3200	3100
IT	4000	4200	4100
Sales	3500	3600	3400
Mktg	3800	3900	3700

Question: What is the average salary in IT?

Step-by-Step Solution:

• Understand the Data:
• The table shows salaries for three employees in four departments.
• We need the average salary in the IT department.
• Extract Relevant Data:
• IT salaries: Emp1 = 4000, Emp2 = 4200, Emp3 = 4100.
• Calculate Average:
• Average = (Emp1 + Emp2 + Emp3) / Number of employees
• Sum = 4000 + 4200 + 4100 = 12,300.
• Average = 12,300 / 3 = 4100.
• Verify:
• Sum: 4000 + 4200 = 8200, 8200 + 4100 = 12,300.
• Average: 12,300 ÷ 3 = 4100.
• Present the Answer:
• Average salary in IT: $4100.

---

Problem 8

Problem Statement:
Table: Books sold by genre in a bookstore.

Genre	Jan	Feb	Mar
Fiction	200	220	250
Non-Fic	150	160	170
Sci-Fi	100	110	120

Question: What is the total number of Fiction books sold?

Step-by-Step Solution:

• Understand the Data:
• The table shows books sold by genre over three months.
• We need the total number of Fiction books sold.
• Extract Relevant Data:
• Fiction sales: Jan = 200, Feb = 220, Mar = 250.
• Calculate Total:
• Total = Jan + Feb + Mar
• Total = 200 + 220 + 250 = 670.
• Verify:
• Sum: 200 + 220 = 420, 420 + 250 = 670.
• Present the Answer:
• Total Fiction books sold: 670.

---

Problem 9

Problem Statement:
Table: Distance (km) traveled by four vehicles daily.

Day	V1	V2	V3	V4
Mon	50	60	55	70
Tue	55	65	60	75
Wed	60	70	65	80

Question: What is the total distance traveled by V4?

Step-by-Step Solution:

• Understand the Data:
• The table shows distances traveled by four vehicles over three days.
• We need the total distance for V4.
• Extract Relevant Data:
• V4 distances: Mon = 70, Tue = 75, Wed = 80.
• Calculate Total:
• Total = Mon + Tue + Wed
• Total = 70 + 75 + 80 = 225.
• Verify:
• Sum: 70 + 75 = 145, 145 + 80 = 225.
• Present the Answer:
• Total distance traveled by V4: 225 km.

---

Problem 10

Problem Statement:
Table: Hours worked by employees in a week.

Emp	Mon	Tue	Wed	Thu	Fri
E1	8	7	8	6	7
E2	6	8	7	8	6
E3	7	6	8	7	8

Question: What is the average hours worked by E1?

Step-by-Step Solution:

• Understand the Data:
• The table shows hours worked by three employees over five days.
• We need the average hours for E1.
• Extract Relevant Data:
• E1 hours: Mon = 8, Tue = 7, Wed = 8, Thu = 6, Fri = 7.
• Calculate Average:
• Average = (Mon + Tue + Wed + Thu + Fri) / Number of days
• Sum = 8 + 7 + 8 + 6 + 7 = 36.
• Average = 36 / 5 = 7.2.
• Verify:
• Sum: 8 + 7 = 15, 15 + 8 = 23, 23 + 6 = 29, 29 + 7 = 36.
• Average: 36 ÷ 5 = 7.2.
• Present the Answer:
• Average hours worked by E1: 7.2 hours.