Total Calculations and Averages from Table Data Groups In this chapter, we will learn how to calculate the total for each column in a group of data and how t...
In this chapter, we will learn how to calculate the total for each column in a group of data and how to find the average for a group of data.
Total
The total for a column is simply the sum of all the values in that column.
Example:
| Column Name | Values |
|---|---|
| Apples | 3 |
| Oranges | 5 |
| Grapes | 7 |
| Strawberries | 10 |
| Apples | 2 |
Adding the values in the 'Apples' column, we get:
Total for Apples = 3 + 5 + 7 + 10 + 2 = 30
Average
The average for a column is the sum of all the values in that column divided by the number of values in that column.
Example:
| Column Name | Values |
|---|---|
| Apples | 3 |
| Oranges | 5 |
| Grapes | 7 |
| Strawberries | 10 |
| Apples | 2 |
Adding the values in the 'Apples' column and dividing by 5, we get:
Average for Apples = (3 + 5 + 7 + 10 + 2) / 5 = 5
Using the Data Groupings
When working with data groups, we can easily calculate both the total and average for each column by using the following steps:
Identify the column(s) you want to calculate the total for.
Add the values in each column in the group.
Identify the column(s) you want to calculate the average for.
Divide the sum of the values in the specified column by the number of values in that column.
Remember:
The total for a column will always be a single number.
The average for a column will always be a single number.
Always pay attention to the context of the data and the meaning of each column before calculating the total or average