Purchase Solution

# Water Consuption

Not what you're looking for?

Question 1
The file ?assignment data.xls? (SEE ATTACHED FILE)contains daily data on water consumption in the cities of Canberra and Queanbeyan from January 1st 2000 to March 25th 2004.

(a) Extract the data for the year 2000 when there were no water restrictions and the year 2003 when there were water restrictions. Use the histogram tool in Excel (Tools > Data Analysis > Histogram) to draw histograms of water consumption for these two years separately. Use class intervals of width 10ML with a stated lower limit of 80ML. Make sure you follow the appropriate graphic presentation guidelines.

(b) Describe the shape of the distribution for the two histograms separately and then make a comparison.

(c) Use Tools > Data Analysis > Descriptive Statistics to find descriptive statistics for the water consumption in 2000 and the water consumption in 2003. INCLUDE THE EXCEL OUTPUT.

(d) Use fx > Statistical > Quartiles to calculate quartiles of for the water consumption in 2000 and the water consumption in 2003.

(e) Give a five-figure summary for the water consumption in 2000 and the water consumption in 2003. Present these results in a table.

(f) Draw comparative boxplots of the water consumption in 2000 and the water consumption in 2003. This means that both boxplots must be on the same graph. You may do this by hand.

(g) Describe the shape of the distribution for the two boxplots separately and then make a comparison. Compare the information obtained from the boxplots with the information obtained from the histograms.

##### Solution Summary

Question 1
The file ?assignment data.xls? (SEE ATTACHED FILE)contains daily data on water consumption in the cities of Canberra and Queanbeyan from January 1st 2000 to March 25th 2004.

(a) Extract the data for the year 2000 when there were no water restrictions and the year 2003 when there were water restrictions. Use the histogram tool in Excel (Tools > Data Analysis > Histogram) to draw histograms of water consumption for these two years separately. Use class intervals of width 10ML with a stated lower limit of 80ML. Make sure you follow the appropriate graphic presentation guidelines.

(b) Describe the shape of the distribution for the two histograms separately and then make a comparison.

(c) Use Tools > Data Analysis > Descriptive Statistics to find descriptive statistics for the water consumption in 2000 and the water consumption in 2003. INCLUDE THE EXCEL OUTPUT.

(d) Use fx > Statistical > Quartiles to calculate quartiles of for the water consumption in 2000 and the water consumption in 2003.

(e) Give a five-figure summary for the water consumption in 2000 and the water consumption in 2003. Present these results in a table.

(f) Draw comparative boxplots of the water consumption in 2000 and the water consumption in 2003. This means that both boxplots must be on the same graph. You may do this by hand.

(g) Describe the shape of the distribution for the two boxplots separately and then make a comparison. Compare the information obtained from the boxplots with the information obtained from the histograms.

##### Solution Preview

Please see attachment. Analysis can be found in the file: stat.doc. an Excel file is attached as well.

Hi, this is a multipart question in my introductory statistics course that I would like to see solved.

Question 1
The file ?assignment data.xls? (SEE ATTACHED FILE)contains daily data on water consumption in the cities of Canberra and Queanbeyan from January 1st 2000 to March 25th 2004.

(a) Extract the data for the year 2000 when there were no water restrictions and the year 2003 when there were water restrictions. Use the histogram tool in Excel (Tools > Data Analysis > Histogram) to draw histograms of water consumption for these two years separately. Use class intervals of width 10ML with a stated lower limit of 80ML. Make sure you follow the appropriate graphic presentation guidelines.

The data for the year 2000

The data for the year 2003

...

Solution provided by:
###### Education
• BSc , Wuhan Univ. China
• MA, Shandong Univ.
###### Recent Feedback
• "Your solution, looks excellent. I recognize things from previous chapters. I have seen the standard deviation formula you used to get 5.154. I do understand the Central Limit Theorem needs the sample size (n) to be greater than 30, we have 100. I do understand the sample mean(s) of the population will follow a normal distribution, and that CLT states the sample mean of population is the population (mean), we have 143.74. But when and WHY do we use the standard deviation formula where you got 5.154. WHEN & Why use standard deviation of the sample mean. I don't understand, why don't we simply use the "100" I understand that standard deviation is the square root of variance. I do understand that the variance is the square of the differences of each sample data value minus the mean. But somehow, why not use 100, why use standard deviation of sample mean? Please help explain."
• "excellent work"
• "Thank you so much for all of your help!!! I will be posting another assignment. Please let me know (once posted), if the credits I'm offering is enough or you ! Thanks again!"
• "Thank you"
• "Thank you very much for your valuable time and assistance!"

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

##### Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.