Water Consuption
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.
© BrainMass Inc. brainmass.com May 24, 2023, 1:22 pm ad1c9bdddfhttps://brainmass.com/statistics/histogram/statistics-excel-multipart-problem-18747
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 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.