Tabulation: Formulas, Shortcuts and Solved Examples — MCQs with Answers (Set 3)

The Aditya value was 92 in Match 4 and 34 in Match 5. Change = 34 – 92 = -58. Percentage change = (change / original value) x 100 = (-58 / 92) x 100 = -63.04%. Rounded, this is a 63% decrease from Match 4 to Match 5.

First add each row across its 5 categories to get a row total. The row totals are Match 1 = 365, Match 2 = 335, Match 3 = 258, Match 4 = 476, Match 5 = 389. Add these 5 row totals together: 365 + 335 + 258 + 476 + 389 = 1823. So the grand total runs scored across all matches and categories is 1823.

In Match 5, the table gives Arjun = 123 and Rahul = 113. Percentage formula: (Arjun / Rahul) x 100. (123 / 113) x 100 = 108.85%. Rounded to the nearest whole number, that is 109%.

The Academic value was 102 in Q2 and 188 in Q3. Change = 188 – 102 = 86. Percentage change = (change / original value) x 100 = (86 / 102) x 100 = 84.31%. Rounded, this is a 84% increase from Q2 to Q3.

In Q3, the table gives Academic = 188 and Children’s = 171. Write this as the ratio 188 : 171. The greatest common divisor of 188 and 171 is 1. Dividing both terms by 1 gives 188 : 171, the ratio in lowest terms.

The total books sold of Poetry across all 5 rows is 491. Average = total divided by the number of rows. Average = 491 / 5 = 98.2. Check: 98.2 multiplied by 5 gives back approximately 491.

In Q4, the table lists a value for each of the 5 categories. The values are: Poetry = 184, Children’s = 107, Academic = 56, Non-Fiction = 168, Biography = 182. Compare all 5 categories to find the largest value. Poetry has the highest value, at 184. So Poetry had the highest books sold in Q4.

In 2014, the table gives Manali = 33 and Shimla = 333. Write this as the ratio 33 : 333. The greatest common divisor of 33 and 333 is 3. Dividing both terms by 3 gives 11 : 111, the ratio in lowest terms.

The total tourists visiting of Goa across all 5 rows is 1534. Average = total divided by the number of rows. Average = 1534 / 5 = 306.8. Check: 306.8 multiplied by 5 gives back approximately 1534.

In 2016, the table gives Goa = 366 and Udaipur = 160. Percentage formula: (Goa / Udaipur) x 100. (366 / 160) x 100 = 228.75%. Rounded to the nearest whole number, that is 229%.

Look at the row for 2013 in the table. It has one value for each of the 5 categories: 53, 229, 215, 293 and 278. Add all 5 values together: 53 + 229 + 215 + 293 + 278 = 1068. So the total tourists visiting of all categories in 2013 is 1068.

The Udaipur column in the table has one value for each year. Reading down the column, the values are 53, 259, 478, 160 and 316. Add all 5 values together: 53 + 259 + 478 + 160 + 316 = 1266. So the total tourists visiting of Udaipur is 1266.

In Q1, the table gives Biography = 69 and Self-Help = 27. Percentage formula: (Biography / Self-Help) x 100. (69 / 27) x 100 = 255.56%. Rounded to the nearest whole number, that is 256%.

In Q1, the table lists a value for each of the 5 categories. The values are: Comics = 114, Self-Help = 27, Academic = 28, Biography = 69, Poetry = 23. Compare all 5 categories to find the largest value. Comics has the highest value, at 114. So Comics had the highest books sold in Q1.

In Q5, the table lists a value for each of the 5 categories. The values are: Comics = 175, Self-Help = 127, Academic = 181, Biography = 108, Poetry = 33. Compare all 5 categories to find the smallest value. Poetry has the lowest value, at 33. So Poetry had the lowest books sold in Q5.

In Q1, the table gives Poetry = 23 and Biography = 69. To find the difference, subtract the smaller value from the larger one. Biography is larger, so difference = 69 – 23 = 46. Check: 23 + 46 = 69, which matches Biography’s value.

The total books sold of all categories in Q4 is 449. Average = total divided by the number of categories. Average = 449 / 5 = 89.8. Check: 89.8 multiplied by 5 gives back approximately 449.

In 2014, the table gives Udaipur = 300 and Kochi = 159. To find the difference, subtract the smaller value from the larger one. Udaipur is larger, so difference = 300 – 159 = 141. Check: 159 + 141 = 300, which matches Udaipur’s value.

In 2013, the table lists a value for each of the 5 categories. The values are: Shimla = 79, Ooty = 393, Manali = 70, Kochi = 414, Udaipur = 358. Compare all 5 categories to find the smallest value. Manali has the lowest value, at 70. So Manali had the lowest tourists visiting in 2013.

Look at the row for 2017 in the table. It has one value for each of the 5 categories: 295, 170, 195, 457 and 219. Add all 5 values together: 295 + 170 + 195 + 457 + 219 = 1336. So the total tourists visiting of all categories in 2017 is 1336.

In 2015, the table gives Kochi = 142 and Udaipur = 230. Write this as the ratio 142 : 230. The greatest common divisor of 142 and 230 is 2. Dividing both terms by 2 gives 71 : 115, the ratio in lowest terms.

The Kochi value was 159 in 2014 and 142 in 2015. Change = 142 – 159 = -17. Percentage change = (change / original value) x 100 = (-17 / 159) x 100 = -10.69%. Rounded, this is a 11% decrease from 2014 to 2015.

Look at the row for 2022 in the table. It has one value for each of the 5 categories: 27, 114, 162, 153 and 138. Add all 5 values together: 27 + 114 + 162 + 153 + 138 = 594. So the total quantity exported of all categories in 2022 is 594.

The total quantity exported of Wheat across all 5 rows is 512. Average = total divided by the number of rows. Average = 512 / 5 = 102.4. Check: 102.4 multiplied by 5 gives back approximately 512.

In 2022, the table lists a value for each of the 5 categories. The values are: Wheat = 27, Sugar = 114, Coffee = 162, Rice = 153, Cotton = 138. Compare all 5 categories to find the smallest value. Wheat has the lowest value, at 27. So Wheat had the lowest quantity exported in 2022.