Identify average water usage per month

Reference no: EM13990145

Thirty households in a Paarl suburb were surveyed to identify their average water usage per month (in kilolitres, kl). The usage per household was:

10	18	30	13	42	14	9	15	19	20
25	15	24	12	15	16	22	22	8	33
50	26	16	32	25	26	16	26	25	12

Use Excel's Data > Data Analysis > Descriptive Statistics option and, where necessary, the function keyQUARTILE to answer the following questions:

(a) Find the mean, median and modal water usage across the 30 households.

(b) Find the variance and standard deviation of water usage per household.

(d) Interpret the findings from (a) to (c) for the municipal officer who conducted this survey.

(e) If there are 750 households in the Paarl suburb, what is the most likely total water usage (in kl) amongst all these households:

(i) in a month?

(ii) in a year?

Reference no: EM13990145

Questions Cloud

What are the biggest challenges facing danaher : What are the biggest challenges facing Danaher in 2010? What can Larry Culp do to prepare the organization for these challenges

Average variable costs are minimized at a rate of output : Use only integers (whole numbers) without decimal points or other symbols for your answers. Round to the nearest integer if necessary.

What wavelength is needed : An energy of 30.5 ev is needed to remove an electron from the n = w state of a lithium atom. if a single photon accomplishes this task what wavelength is needed?

What percent of variation are restaurant sales explained : Which of the coefficients are statistically significant and which are not? Explain. What percent of variation are restaurant sales explained by this equation?

Identify average water usage per month : Thirty households in a Paarl suburb were surveyed to identify their average water usage per month (in kilolitres, kl). The usage per household was:

Company financial embezzlement cases : Article topic ideas: Information breaches (these will be the vast majority), disgruntled employee cases involving data theft or leaking of information and company financial embezzlement cases that are directly related to IT

Equity portfolio-car sales : Find the average price paid per share in an equity portfolio consisting of: 40 shares bought for R15 each; 10 shares bought for R20 each; 5 shares bought for R40 each; and 50 shares bought for R10 each. Use the weighted average formula.

Evaluate present marketing strategy selected company : Identify the company you selected and evaluate its present marketing strategy. Provide evidence to support your evaluation. Determine what, if anything, the marketing manager should do to change the current strategy

What categories of data are difficult or impossible to find : What categories of data are difficult or impossible to find on the Internet? (When using the Internet, be sure to provide specific websites or URLs.)

User Account

All Pages