Find out the average consumption per person from your data. You can use the formulae in a spreadsheet.
The average consumption per person is calculated by dividing the total water consumption of all surveyed families by the total number of people in those families.
In a spreadsheet, if total consumption is in column G and number of members is in column C, the formula would be =SUM(G2:G8)/SUM(C2:C8).
For example, if total consumption is 200 litres for 30 people, the average consumption per person would be approximately 6.67 litres.
The chapter on page 16 explains how to use Excel formulae to analyse data. The hint provided states that when you divide values in the G column (Total consumption) from those in the C column (Number of members), Excel will calculate the average automatically.
Students can use formulae like =SUM() to add totals and then divide by the total number of members.
Explanation
The chapter on page 16 explains how to use Excel formulae to analyse data. The hint provided states that when you divide values in the G column (Total consumption) from those in the C column (Number of members), Excel will calculate the average automatically. Students can use formulae like =SUM() to add totals and then divide by the total number of members.
Solution Steps
Step 1: Collect data from surveyed families including total water consumption and number of family members.
Step 2: Enter data in a spreadsheet with columns for family name, number of members, and consumption categories.
Step 3: Calculate total consumption for each family using =SUM() formula.
Step 4: Calculate total consumption of all families using =SUM() on the total column.
Step 5: Calculate total number of people from all families using =SUM() on the members column.
Step 6: Divide total consumption by total number of people to get average consumption per person.