Average Based Data Interpretation Quiz 15 (10 MCQs)

This set of multiple-choice questions evaluates the understanding of arithmetic mean calculation, including the use of Excel functions for average calculations. It covers concepts such as summing values, division by count, and data interpretation. Students will practice calculating averages for various scenarios, including test scores, total cost, and weighted averages.

Quiz Instructions

Select an option to see the correct answer instantly.

1. How do you find the average of two numbers?
2. The weights of three children is 34.2 Kg, 36.8 Kg and 40.9 Kg. Find the average weight
3. The formula of average is .....
4. You own a jewelry company. The number of pieces made by each of your five employees last week are as follows: 18,23,22,19, and 23. On average, how many pieces of jewelry did your employees make?
5. The average age of a group of 12 students is 20 years. If 4 more students join the group, the average age increases by 1 year. The average age of the new students is .....
6. Carlos earned $ 23, $ 29, $ 25, $ 16, and $ 17 in tips at each of the tables he served at a restaurant. What is the mean of the tips he received?
7. The last four times that Jimmy filled up his tank of gas, the average price per gallon of gas was $ 3.05. If the average price stays drops to $ 2.50 the next two times that Jimmy fills up his tank, then what would the average price per gallon for all of the trips be?
8. Which formula will calculate the average of data in a given range?
9. Hannah has scored the following number of points in the last five games: 2, 57, 38, 42, 6. What is her average over those games?
10. Paulo got these markers in three tests: 72, 80 and 82. He had one more test to sit. He wanted an average of 80 for the four tests. What mark must he get in the fourth test?

Frequently Asked Questions

What is the arithmetic mean?

The arithmetic mean is the sum of a set of numbers divided by the count of those numbers, representing the average value.

How is the average age calculated?

The average age is calculated by summing the ages of all individuals and then dividing by the number of individuals.

What is the purpose of data interpretation in this context?

Data interpretation helps in understanding and analyzing numerical data to derive meaningful insights and conclusions.

How can the average function in Excel be used?

The average function in Excel calculates the arithmetic mean of a range of cells, simplifying the process of finding averages.

What is the difference between mean and weighted average?

The mean is the sum of all values divided by the number of values, while a weighted average takes into account the relative importance of each value.